Time for action – calculated members

Calculated members help to perform calculation based on measures, dimension hierarchies, and MDX functions. They are very helpful for covering business requirements with the help of a cube. In this example, we will create a new calculated member for Profit.

  1. In the cube designer, go to the Calculations tab.
  2. Create a new calculated member by clicking on the button that is magnified in the next screenshot.
  3. Rename the calculated member to [Profit].
  4. Write the following expression in the Expression field:
    [Measures].[Sales Amount] - [Measures].[Total Product Cost]
  5. Set the format string as "Currency".
    Time for action – calculated members
  6. Deploy and process this ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.