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?
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
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.