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.
- In the cube designer, go to the Calculations tab.
- Create a new calculated member by clicking on the button that is magnified in the next screenshot.
- Rename the calculated member to
[Profit]
. - Write the following expression in the Expression field:
[Measures].[Sales Amount] - [Measures].[Total Product Cost]
- Set the format string as "Currency".
- 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.