SSAS Event Type Calculation Dimension
User Rating: / 0
PoorBest 
Written by Jenny Salvo   
Wednesday, 22 May 2013 21:27

Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For example, we can define a 'Year to Date' calculation in a calculation dimension and it will work for any measure. Alternatively, we could define a new 'Year to Date' calculated member for every current measure in the cube, but this would cause our list of members to expand significantly and create clutter. Therefore, calculation dimensions provide a nice option to minimize the number of calculated members in a cube; yet, still allow users to perform the necessary analysis.

Read more...

 

Tags: design, mdx
 

XL Cubed