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.
cherriesh
It's interesting that you're seeing an error, because 'Process Full' is nothing more than 'Process Data' and then 'Process Index' under the covers.
I'll admit that I was skeptical that executing the two sequentially was faster for you than process full, but I found an Analysis Services best practices whitepaper that confirmed this could happen.
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx
Are you sure you are using 'Process Data' on the cube object itself and not a measure group or partition?
Also, you may want to post this question in the Analysis Services forum.
|||Hi,
I did the process data for both the dimensions and cube. and did also process index for the two.
am i right there?
cherriesh
|||I think that might be your issue. If it processes a dimension after the cube that would explain the error message you received on the step to process the index. Try doing process data for just the cube (it should do the dimensions as part of this).
No comments:
Post a Comment