Hi,

I'm new to OLAP Services. I have a cube with some dimensions based on
some tables (with huge chunks of data). Actually I use this cube to produce
reports using office web components in asp pages.

Huge data gets imported into my database (on which I use OLAP) on a
scheduled basis. My question is when should keep processing the Cubes.
Should the cube be processed only when its structure or dimension changes,
or every time when the data gets imported into the database. Should the cube
be processed whenever there is change in data or whenever there is a change
in the cube itself or whenever both the previous cases happen?

Can anybody help me with this question? I would like to have a clear
idea about this question at the earliest and some help would be really
appreciated.



Regards,

Hari

You do an incremental process to import new data into the cube. If you
change the cube structure (add a measure, add a dim, add a level, etc.) you
must do a full reprocess.

public @ the domain below
www.tomchester.net

"Haribabu" <hari_cse (AT) hotmail (DOT) com> wrote