dbTalk Databases Forums  

Limitations when combining cubes from different locations using Linked Cubes

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Limitations when combining cubes from different locations using Linked Cubes in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rajya Bhaiya
 
Posts: n/a

Default Limitations when combining cubes from different locations using Linked Cubes - 06-20-2004 , 02:52 AM






Hi

I have a scenario where I am combining regular cubes from 100 school
districts. I have taken the approach of creating 100 linked cubes and
then create a virtual cube to combint them. Each of the regular cubes
contain 5 dimensions and 10 members.

Since the data volume is very large, I am unable to create a large
data warehouse.

In this scenario, my virtual cube cound end up having a laerge #
measures:

1000 measures
3000 Calculated members

Are there any alternate approaches to solving this problem?

Thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.