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 procedure, and then browse the cube with the Product Category hierarchy and a Profit measure.