SSAS Cube Processing Optimization

Sometimes there is not enough time to process you cubes. You will have to optimize processing. You can do many things.

• Try to separate different processes - break everything into smaller processing tasks. Then you will be able to tackle them individually. It will also allow you to more precisely orchestrate which task are you doing when.
• Separate processing of individual cubes.
• Instead of doing full processing of cube, do processing of data and processing of indexes (cube indexes and aggregations) separately. The first operation will involve you relational source, but the second one will use just SSAS. While SSAS server is busy you can do something else with relational engine/server.
• Try to manually set number of parallel tasks for cube processing. You may have better results. Note that you are not limited to numbers in the drop down list. You can type in other numbers.

All Member Formula

Dimensions in Analysis Services 2000 have property that defines value of All member:

All Member Formula = [Reporting Period].[All reporting Period].FirstChild

To convert it to Analysis Services 2005 or Analysis Services 2008 you will need to set it as calculation on cube designer:

CALCULATE;

[Reporting Period].[Reporting Period].[All Reporting Period] = [Reporting Period].[Reporting Period].[All Reporting Period].FirstChild

del.icio.us Tags: MDX,All Member,dimension,SSAS,Analysis Services

MDX Error: "Permission to Access the Referenced Mining Model"

If you get an error like the following back from SSAS server:

Either the user, DEV\Smith, does not have permission to access the referenced mining model, ABCD New Business, or the object does not exist.

This occurs when you omit to specify axis of your MDX query:

select [Product Completion Date] - -on 0

from [SBCD New Business]

del.icio.us Tags: SSAS,Analysis Services,MDX,error,Permission to Access Referenced Mining Model