Calculated Members

You have the possibility to create your own dimension members, based on the existing ones.

To add calculated members to some hierarchy you have to click with the right mouse button on that hierarchy in the hierarchies list. In the context menu select “Calculated Members…”:

After that a window will appear for managing the calculated members from the selected hierarchy:

To add a new calculated member, press the button as shown in the picture above. A wizard will appear that will help you to create a new member:

In the first step you have two options:

• Function over set;
• Custom MDX.

The second option is for experts familiar with MDX querying language and enables you to create a calculated member with a custom MDX query.

Let’s consider the first option. If you select it and press Next you will see the following form:

Let’s build the calculated member that will show the total value of the measures for the years 2015 and 2016. To do that, select “Sum” in the “Function” field. In the “Measure” field leave the value “Current Measure” to make the summary value calculated over the currently selected measure. In the bottom part of the window you can see an elements tree where you can select the elements whose values will be counted in the sum. Select “CY 2015” and “CY 2016” as shown in the picture:

After pressing “Finish” the new calculated element will be created:

Now add the hierarchy with the new element (“Date.Calendar” in our case) to your report on rows or columns. Open the member selector and you will see a new calculated member there:

Add this element to the selection to see the result:

You can edit calculated members in the same management window that you used to add the member. There are buttons for editing and removing a member:

You can also edit the calculated members from the context menu:

Pay attention, that in the calculated members’ management window you can see only elements from the hierarchy for which you opened that window. To see the elements from the other hierarchy click the right mouse button on that hierarchy and select the item “Calculated Members”.

Let’s edit our calculated member, so that it will show not the sum but the average value. To do that, select the element in the calculated members’ management window and press the Edit button.

In the “Function” field change the value from “Sum” to “Average” and press «OK»:

Now look at your report, it should show the average value for two selected years:

This way you can create any number of calculated members in different hierarchies and use them in your reports.