Hi,

How I can improve particions on Analysis services?

Somebody can recommend me a link on this...?

Thanks,
Cecilia
Chile

My implementation is on SQL 2005

Thanks,
Cecilia
Chile

Hola,

You can improve the reactivity of your cube by modifying its storage
mode. Open your cube within VS, click on the "Partitions" panel, and
you will see the only one that has been created, using "MOLAP 0%".

This percentage trailing MOLAP is related to the quantity of
aggregations that are stored within SSAS. "0%" here means that you
are currently working on a copy of your entire data source view, and
that you are computing every aggregation on the fly.

To improve the speed, you would use the Aggregation Design Wizard which
offers you the possibility to compare the performance gain related to
whatever percentage you enter.

Good luck,
Franck

Hoody wrote: