No aggregation for HOLAP in SSAS2005 -
11-17-2006
, 02:49 PM
I did some tests about storage mode in SSAS2005. The test result for
HOLAP is strange.
Could any expert give me an explanation?
Thanks in advance.
The test cube has 3 dimensions and 3 measures. Two dimension has 1,000
members and one has 10 members. The fact row in the cube is 10,000,000.
StorgeMode for all dimension: MOLAP
StorgeMode for cube/measure group/partition: HOLAP
The aggregation design wizard informs that 7 aggregations (17M bytes)
should be created.
But there is no aggregation files for the cube after I fully process
the database.
If I change the storage mode for the partition from HOLAP to MOLAP,
*.agg.rigid.data file is there.
The MDX query to rank top 10 dimension1 by dimension2 takes 30 seconds
for HOLAP mode. But it takes only 10 seconds for MOLAP mode.
Do I miss some settings or it is a bug? |