Process Cube

Hi,

I want to process my cube using Process Data and Process Index instead of the Process Full. However, after configuring the 2 Analysis Services Processing Tasks (one for process data and the other for process index) and were executed sequentially (process data first then process index), I got this error:

Errors in the metadata manager. The process type specified for the CASES cube is not valid since it is not processed

Have I done the right thing?

The reason why I prefer using the Process Data and then Process Index, it's because it is much faster than the latter.

I'm not sure though what Process Index is for. As far as I'm concerned, I have done partitions (I used performance gains reaches ) but I don't remember to explicitly declare indexes.

Please help...

cherriesh

Hi,

In theory what you did to me seems as if it should work. Have you tried doing it outside SSIS? So in managment studio, process data and then index, might be a problem with the cube not actually processing the data step properly.

but here is a description of what the different process types do

http://technet.microsoft.com/en-us/library/ms174774.aspx

Hope that helps

Matt

|||

Hi,

The ProcessFull is working fine. I dunno how to do this outside SSIS. Am I right to have Process Data for both Dimension and Cube and to have another Analysis Services Process Task for Process Index for both (Dimension and cube)

cherriesh

|||

Hi,

I found a better link:

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

For the dimensions:

A process full will reprocess the dimension completely

Never done a process index on a dimension, but i would assume process data then process index.

Once the dimensions are processed then process the cube

Process Full

Process data and process index (two seperate tasks I am guessing)

You could try

(task 1) Is to process the structure of the cube (processes all the dimensions)

(task 2) Process full of cube

OR

task 1, process data of dims

task 2, process indexes

task 3, process data of cube

task 4, process indexes of cube

OR

task 1, process structure of cube

task 2, process data of cube

task 3, process indexes of cube

Sure there are lots of different ways.

With reference to aleternative ways of processing:

http://technet.microsoft.com/en-us/library/aa337509.aspx

Hope that helps,

Matt