MS SQL Data Warehousing - Error processing cubes on SQL 2000 AS SP 3

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Error processing cubes on SQL 2000 AS SP 3

Andy S.

2006-03-21, 3:24 am

I am trying to build and process a data cube made up of several smaller
cubes linked in a snowflake schema on SQL 2000 SP 3 Analysis Services SP 3.
I am able to join two cubes together and process successfully, but one I try
to add a second, I get a

Data source provider error: Parsing error occurred prior to ' "CUBE B" WHERE
("CUBE B"."CUBE B COLUMN NAME:(All)!NAME"="CUBE A"."CUBE B COLUMN
NAME:(All)!NAME") GROUP BY "CUBE A"."CUBE C Column Name:(All)!NAME", "CUBE
B"."CUBE B COLUMN B:(All)!NAME", "CUBE B"."CUBE B COLUMN C:(All)!NAME"'.;
Time:3/20/2006 3:56:15 PM

I am linking the cubes on the key columns, and dropping the names as
dimensions. Can someone please advise me as to what I'm doing wrong?
Thanks.

Sponsored Links