Being careful in SSAS to not make a cube/dimension unprocessed

A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes a cube to become unprocessed, forcing you to do a full process so the cube is usable.  Nothing is worse than making a change without realizing it will cause the need for a full process on all the partitions of a cube that will take many hours.

For example, a process full on a dimension will cause cube/measures group/related partitions to become unavailable/unprocessed.  Here are other actions that will make your cube unprocessed:

  • New measure group
  • New measure
  • Edit measure aggregation method
  • Edit dimension usage

Here are other actions that will make your dimension unprocessed (and therefore all cubes connected to the dimension become unprocessed):

  • Add an attribute to a dimension
  • Change the order by property of an attribute
  • Edit the attribute relationship
  • Add or delete dimension translation

So, make sure you understand which changes will cause an unprocessed state which makes the cube unusable so you can do it off-hours so you don’t end up getting angry phone calls that the cube is not working!

More info:

SSAS: Which change makes the cube/dimension unprocessed?

Processing Analysis Services Objects

Cube “Process State” changing to UnProcessed

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQLServerPedia Syndication, SSAS. Bookmark the permalink.

2 Responses to Being careful in SSAS to not make a cube/dimension unprocessed

  1. Kiran says:

    Hi,
    Always i got stuck at an error when runnig job with cube.
    How can i trace the follwoing error, can any body suggest on this as urgent basis:

    “Unexpected end of file has occurred. The following elements are
    not closed: root, return, ExecuteResponse, soap:Body, soap:Envelope. Line 107952, position 1”

    thanks

  2. flame says:

    thanks, very useful.

    I’ve found that changing order of used dimensions (moving one of the time dimensions above, for semiadditive measures), without any other changes, also makes cube unprocessed.

Leave a Reply

Your email address will not be published. Required fields are marked *