MS SQL Data Warehousing - Need help linking cubes in a virtual cube

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

Need help linking cubes in a virtual cube

Andy S.

2006-02-14, 9:23 am

I'm using SQL 2000 Analysis Services enterprise edition. I was hoping to
try and build a "relational" cube so I could process support tables in small
cubes and then link them to a master cube. So far, I've been doing a
snowflake type relationship, but that makes designing aggregations take
forever. Is there a way without MDX programming, to say an ID column in
cube A matches a ID column in Cube B and then build a new cube off that? If
this does involve an MDX query, is there a way to easily incorporate into
Excel? Thanks.

--

********************
********************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@noreply.yahoo.com

Please remove "noreply" before replying.

********************
********************
*********

Sponsored Links