Report Portal

SSAS Event Type Calculation Dimension

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.


Tags: design, mdx


2007-2015 VidasSoft Systems Inc.