Hello,
i'm a bit mystified on how partitions will help when a cube is processed.

Could someone point me to a resource, white paper or the like on how it
works ?

Thanks
P

Hi,

The partions help analysis services to save a processing time, because of
processing only partiotion that fact are chaged. (not the whole cube)
and to save a memory during processing.

The user defined partitions are only available in Enterprise Edition of AS.

Look for info about partiotions at the MSDN.

Vladimir Chtepa

"Patricia" <Patricia (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:219BAD37-C64A-4660-8C57-3C8AFB928835 (AT) microsoft (DOT) com...

Patrica,

There are many reasons partitions help us from sppeding up processing times,
managing aggregations, speeding up query times etc, they are explained in
detail here

http://www.microsoft.com/technet/pro...rt6/c2661.mspx


also worth a read
http://www.microsoft.com/technet/pro.../ansvcspg.mspx


Patricia wrote:
--
Message posted via http://www.sqlmonster.com

The Analysis services Performance Guide at
http://www.microsoft.com/technet/pro...ntain/ansvcspg.
mspx has some details.

The key points being:

* Multiple partitions can be processed in parallel.
* Only some partitions may need to be processed.
* Different partitions can have different aggregation designs.
* Different partitions can have different storage modes.
* Partitions can be refreshed individually.

The Query optimizer can also make use of partitions to boost query
performance.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <219BAD37-C64A-4660-8C57-3C8AFB928835 (AT) microsoft (DOT) com>,
Patricia (AT) discussions (DOT) microsoft.com says...

Thanks Guys

"Patricia" wrote: