Parent-child dimension
Mon, 05 Nov 2007 11:48:03 +0100
I'm trying to connect a parent-child dimension to my fact table.
I would like to browse cube measure (sold items quantity) through the
dimension "Groups" representing items family (tree structure).
Here are the tables:
Fact table (items sold with quantity):
------------------
IdItem;Quantity
1;5
2;2
3; ...
|
NUll in All Cube Measures
Sun, 4 Nov 2007 13:47:56 -0000
Greetings one and all, any advice gratefully received on the following:
Using SQL 2005 my cube processess and deploys without error and I can browse
the dimensions to see all of the values for each attribute however all of my
measures within each on my measure groups return null using the cube
browser.
T ...
|
Re: Relational Views as Transformation Method in Data Warehouse
Sat, 03 Nov 2007 10:15:06 -0700
On Sep 26, 4:14 pm, Marco Russo <marco.ru...@loader.it> wrote:
> On Sep 20, 9:04 pm, DanUp <dupton.@.DecisionLab.Dot.Net.> wrote:
>
>
>
>
>
> > Open Question:
> > A recent post-reply, one expert (Marco Russo) indicated that he doesn't like
> > to use relational views as a quasi-ETL method, but rather prefer ...
|
How to use the bcp command prompt utility to import data into a ta
Sat, 3 Nov 2007 01:57:19 -0700
How to use the bcp command prompt utility to import data into the "Test"
table
Click Start->Run->cmd.
In the command window , type cd c:\ which will take you to the root of c:\.
At the C:\ prompt, type bcp Testdb..Test in Test.txt -c -T, and then press
Enter.
The bcp command identifies the datab ...
|
Seeking advice on design
Thu, 01 Nov 2007 06:22:58 -0700
I am new to Analysis Services (and DW in general) and have been
getting up to speed using "The Microsoft Data Warehouse Toolkit" [by
J. Mundy and W. Thornthwaite]
I am using a star schema with a factless fact table because the fact
is an event.
My question involves a set of boolean flags. There are 16 yes/n ...
|
BULK INSERT performance
Thu, 1 Nov 2007 08:49:39 -0400
Question/sanity check about BULK INSERT performance.
I load a 300,000 row text file into my largest table every day. The file loads into an empty table with the same structure and
defaults but no indexes in about 10 seconds, for a rate of 30,000 rows/sec. The same file takes more like 3000 seconds to load int ...
|
SQL 2005 Analysis Memory requirement
Tue, 30 Oct 2007 12:07:35 -0400
Hello everyone,
We are planning to purchase hardware for Analysis Server. I want to see
what configuration everyone is using for the Analysis Server. How much RAM
on your server, how many processors, size of the cub, Server edition, etc...
Someone indicates that we need 64 bit SQL Server 2005 for Analysi ...
|
|
|
SQLServer Error: 536, Invalid length parameter passed to the SUBST
Mon, 29 Oct 2007 12:31:02 -0700
I am trying to run an SSIS package from SQL Server 2005 Standard Edition with
SP2 and I am getting the following error: 'SQLServer Error: 536, Invalid
length parameter passed to the SUBSTRING function. [SQLSTATE 42000]'. I am
storing the packages in the SQL Server database and I have setup credentials
for a ...
|
MDX to find out number
Sat, 27 Oct 2007 05:03:52 -0000
How to find out ID in dimension if name is given?
for eg. in product dimension
ID Product
1 Shoes
2 Computer
3 Clothes
If name of product is "Clothes" then How to find count surrogate key
is 3?
...
|
Simple (?) MDX query
Fri, 26 Oct 2007 22:27:31 +0200
I have a question.
Data is in an Analysis Services database, and MDX is not my strongpoint.
Imagine a desired result set like this. Not the most complex, i admit:
Company Last Years Sales Current Sales Total
Adv.Works 10000 4000 14000
Northwind 3200 ...
|
