dbTalk Databases Forums  

No aggregation for HOLAP in SSAS2005

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


Discuss No aggregation for HOLAP in SSAS2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
C.F
 
Posts: n/a

Default 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?


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.