Hi all

I have cubes that I browse often in analysis manager, The stogare mode is
HOLAP. The first dimension that opens ( alphabetically first ) is Account
which is relatively large, so it takes quite a time to open it. I used the
Parttion Aggregation Utility to set an aggregation on the first level of
this dimension ( right below the All level ) and All level for all other
dimensions hoping that will speed up. However it still opens very slowly and
there is a select from the fact table running on SQL server during this
time. Any suggestions?

Thanks
Plamen

Hi Plamen,

First of all, I would suggest you change your storage mode from HOLAP to
MOLAP. I've never seen a scenario where HOLAP really makes sense as a storage
option: MOLAP performs better and doesn't usually take that much more space.
It will probably stop that SELECT statement running...

If you do still think you need to design aggregations manually after that,
take a look at the following entry on my blog that contains some tips
http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!119.entry

HTH,

Chris

"Plamen Doykov" wrote:

Hi Chris

Thanks. I changed the storage mode; now it performs much better.


"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote