Create calculated members using MDX example

Create calculated members using MDX based on the Bicycle Sales cube.

This example creates new Gross Profit and Gross Profit Margin measures.

Start by creating a connection to the BicycleSales Demo Cube. This cube only has one measure, Value, but several different views of the data, provided by the KeyFigures hierarchy.

To create the calculated measures:

1. Open the Manage Calculations box by selecting Anaplan XL > Custom Calculations.
2. To create the Gross Profit member, select Insert a new calculated member. A new 'untitled' member appears. 
3. Fill in these details for the new member.

4. Create a second calculated member for the Gross Profit Margin member, and fill in these details.

•  To enter the format string, select Show advanced controls link under the Expressions section.
• There are now members in the KeyFigures hierarchy. If you want to use them as normal measures, create two more members in the Measures hierarchy:

1. Select OK to create the calculated members.

You can now see the new measures in context. To find badly performing product groups for 2004, follow these steps:

1. Select Anaplan XL > Grid.
2. Move Measures to columns, Product to rows, and Time to headers.
3. Select the Time hierarchy, then select 2004.
4. Select the Measures hierarchy to select the Gross Profit and Gross Profit Margin measures.
5. Select OK to insert the grid.

When you drill down on the Product hierarchy, you can see that Road S8000 is the failing product.

You can extend this report to use In-cell charts. See Visual grids for performance analysis to continue.