dbTalk Databases Forums  

as2005- no aggregations using holap

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


Discuss as2005- no aggregations using holap in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve S
 
Posts: n/a

Default as2005- no aggregations using holap - 04-25-2006 , 10:26 PM






no aggregations (cube dir empty and query performance poor) created when
using holap. switching to molap resolves. a bug or am i missing a setting?
more- fact table 47m rows, 12 dims, using sp1. i appreciate any help.

Steve


Reply With Quote
  #2  
Old   
BK
 
Posts: n/a

Default Re: as2005- no aggregations using holap - 04-26-2006 , 07:48 AM






MOLAP is always going to out perform the other storage modes in data
retrieval... if you got the storage space and don't need real time
updates then I'd go that way every time.

As for why there were no aggregations, that's another story... If
you've run the design storage wizard and told it to create aggregations
then HOLAP & MOLAP should store them on the AS side and ROLAP will
store them on the DB side...

B


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.