MSAS – Implementing Calculations Using MDX Part 1
In this tutorial we will be learning about Calculated members, Creating Calculated Members, Using Function Libraries to Build Calculated Members and Calculated Member Builder.Understanding Calculated members Calculated members are members of a dimension whose value is calculated at run time using Multidimensional expressions. The values of a calculated member may be derived from other member’s values. For instance Profit is determined by subtracting the value of member costs from value of member sales. This is unlike an input member whose value is directly loaded from the data base. The expressions for calculated members are defined when the member is defined. Calculated…