|
|
|
January 2003 March 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Whats in a cube? Posted by ChrisR at 2/28/2006 8:39:23 PM I know that I define what makes up a cube. I know that I point Analysis
Services to a data source. But when I create a cube, is it actually making a
copy of that data source defined by my dimensions and measures? Or is it
just creating meta data with my definitions?
TIA, ChrisR
...more >>
Syntax help. Posted by ChrisR at 2/23/2006 3:42:26 PM Im a total newbie to Analysis Services and MDX, so please bear with me.
This code works:
IIF(Ancestor([Product].CurrentMember,[Product].[Category]).Name =
"Bread","Bring","Don't Bring")
So it would seem to me that this code would be syntactically correct, but
its not:
Ancestor ([Pr...more >>
Suggestion for Handling Very Large Tables (SQL 2000) Posted by Christian Nunciato at 2/21/2006 6:41:26 PM Hi all:
I just learned today that a project I'm working on has a couple of very
large tables that need, somehow, to be optimized for searching. One table
has roughly 7 million rows, and another, its relative, has over 16 million.
At present, client applications only insert into these tabl...more >>
Need an expert advice Posted by Chris at 2/20/2006 11:59:28 AM Hi,
we have a legacy database on a UNIX box for our production system (OLTP).
This is the only database used for both OLTP and custom reporting. The
database is now hugh and reporting is very limited as well as slow
processing. When certain reports are run the users have latency in inputing
...more >>
Design opinion? Posted by Dodo Lurker at 2/18/2006 1:21:22 PM Hi
I am starting the task of creating a data warehouse for my company's OLTP
system and we would like to offload reporting to a reporting schema at a
data warehouse. We have 2 kinds of reports: operational (used daily and
need data just about real time) and analytical (used to determine sale...more >>
Cant see my Analysis Services Cube in Excel.... Posted by ChrisR at 2/17/2006 1:28:28 PM Im having the symptoms described in:
http://support.microsoft.com/kb/287079/en-us
But have tried the workaround to no avail. An important note would be that I
have Excel on Box1 and AS on Box2. When connecting to AS on Box1, this issue
doesnt occur.
Any other ideas?
TIA, ChrisR
...more >>
Help with restore in Analysis Services.(Cannot attach to the OLAP. Posted by ChrisR at 2/16/2006 2:49:35 PM Howdy all. Im a total AS newbiew so please bear with me. I RClick the server/
Restore Database/ "\\path.cab", but the message I get is "Cannot attach to
the OLAP data directory".
Ideas?
TIA, ChrisR...more >>
Calculated Member in SQL 2005 Posted by Justin at 2/15/2006 5:27:29 PM I'm trying to create a 'YTD Actual' Member in SQL Server 2005 Analysis
Services. Here is the code:
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
CRM - Warehouse integration Posted by Wreck at 2/14/2006 6:12:26 PM Hi,
Does anyone here have any experience integrating a CRM system and a
warehouse within the enterprise?
Any documentation/white papers would be appreciated.
Thanks,
Wreck.
...more >>
Best practices for reporting: Replicated servers + data warehouse server?? Posted by Sean Aitken at 2/13/2006 11:16:24 AM Good afternoon,
Lately there has been discussion of what the best practice would be for
enterprise reporting needs. Specifically, we currently have online OLTP
servers for our business apps, as well as a data warehouse server.
A member of our team has suggested that we create a new server fa...more >>
Moving from OLTP to OLAP info? Posted by Oded Dror at 2/13/2006 6:15:51 AM Hi there,
Where can I find information about
How to move your database from OLTP to OLAP
what are the steps (stage1 stage2 indexing issue etc..)
with real source code examples
In sql server we have Adventure Works OLTP database
And OLAP database but no one show you how to move
from OLTP t...more >>
SQL 2005 Creating FKs Posted by enzat at 2/12/2006 10:31:58 PM Hi,
I am in the middle of creating a data warehouse and wanted to add some
FK constraints.
However, I've found that when creating them via the 'relationships'
tab, something strange occurs!
I have a FACT table which references PKs in my Dimension tables, hence
my FKs.
Though, when I create ...more >>
Copy tables with autoincrement values Posted by JumpingMattFlash at 2/12/2006 7:51:28 AM I'm trying to establish the quickest and easiest solution to a problem
involving copying data from our live server to our test one.
The database contains approximately 30 tables with about 500mb of data
expanding at about 10% a month. The issue is that in order to refresh the
database on ou...more >>
Error while processing cube Posted by esl at 2/10/2006 2:17:37 PM Hi All,
I keep on getting the following error while processing a cube in SSAS
2005:
Connection could not be established to the Data Source with
DataSourceID <my_data_source_name>
I don't understand why as my project deployement completed successfully
and a "Test Connection" of my Data Sour...more >>
Analysis Services NLB Posted by mi.balle NO[at]SPAM gmail.com at 2/9/2006 9:45:55 AM Hi everyone, I'm setting up two Analysis Services servers in NLB
following the directions in the link
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/olapsite.mspx
After some tries, both servers are working fine alone (trough each
server name), but not trough the NLB. Any Idea...more >>
In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables. Posted by Daniel at 2/9/2006 1:39:54 AM In TSQL how to use OPENXML to open an ntext field in a table? I can not read
the ntext into a local var as TSQL does not allowe ntext local variables.
...more >>
SCD Type 2 -- not aggregating up the hierarchy Posted by Dog at 2/8/2006 9:54:42 AM Hi,
I have an SSAS 2005 cube w/a product dimension which contains the
following hierarchy:
Company --> Store --> Department --> Product
I have just converted the Product dimension to be SCD Type 2, so that
we can preserve the history of the movement of a product from one
department to a...more >>
Variable as criteria Posted by Greg at 2/7/2006 5:14:27 PM I would like to reference a variable as the criteria in a query. I want the
criteria to be as follows: in('A','B'). I would assume you set the variable
to equal this but I am doing something wrong
declare @exclusion varchar(255)
set @exclusion = ('A','B','C')
select * from table where...more >>
Datafile Full Posted by JackCool at 2/5/2006 1:09:59 AM Hi NG,
We have a datafile on drive d: and the log file on drive e: and now the
problem is drive d: is running out of space. We are planning to buy a new
hardisk drive f: what should I do next after we install the new hardisk?
Should I create a new datafile and include that in the primary f...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |