In your MSOLAP dir:
- FoodMart 2000\Sales\Sales.fact.data is the cube
- FoodMart 2000\Sales\Sales.agg.rigid.data is your aggregations
These files will be different in cubes with changeing dimensions or HOLAP/ROLAP aggregations
The figures given by the aggregation designer are very crude estimates at best, and cannot be trusted
Keith Henry
Keith Henry
According to everyone I know I "do something with computers?" for a living, so there you go.