Hi All,
Is there a way to improve the processing of partition of the
cube.Everyday I need to do full processing of 10 partitions and that is
consuming a lot of time.


My Production serever is bit slow or less memory (that can be one
reason)
I want to optimise on the software side.

also
everyday new customers add and old customers modify their records.
So in my fact table I have to add new customer records and delete old
customer modified records.
So I have to do 'full process' of cube than daily
increments????(Please correct me)

I have 10 partitions in my cube and the data is bit bulk.

Please suggest a way to to automate the processing.Evevryday I manually
open each partition and process

Can you guide me how to go about this and the code snippets (c#)
To 1: Create instance of cube and partitions
2.Process the partitions
3.How to automate this code for a particular time?

Please suggest with your experience .

Rgds
BI sai

do you use SSAS2005 or 2000?
in 2000 take a look at the DSO API
in SSAS2005 you can create XML/A scripts or use the ADOMD.NET API.

your partition are by what?
by time or something else?
if its by time, you can process only the "today" partition instead of
everything.

also you can do an incremental update.
if you can identify new rows in the fact table (like sales of the day), you
can do an incremental process to add only these new rows in the cube
partitions.


"BI_sai" <sai.ravi2 (AT) gmail (DOT) com> wrote