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 |