Add a calculated measure to a cube

Add a calculated view when you want to calculate values for the data you are measuring in a cube by using a multidimensional (MDX) expression.

Complete the following steps to add a calculated measure:

1. Log into the Pentaho User Console (PUC).

2. Open the Semantic Model Editor by taking one of the following actions:

   • If you are using the Modern Design of PUC, in the menu on the left side of the page, click Semantic Model Editor.

   • If you are using the Classic Design of PUC, click File > Semantic Model Editor.

   The Semantic Model Editor opens.

3. In the Semantic Models list, navigate to the model that contains the cube to which you want to add a measure. You can find the model by searching or scrolling through the list.

4. Select the model and click Open. The model opens in the canvas.

5. Locate the cube you want to edit, and then click the Add a Measure icon. The Add a Measure dialog opens.

   Notes:

   • If the Add a Measure icon is not visible, click the More Actions icon, and then select Add a Measure.

   • To locate an element in a large semantic model, you can click the Model Structure tab and then navigate to the element by searching or scrolling through the list.

6. Select Add Calculated Measure, and then click Confirm. The Add Calculated Measure dialog opens.

7. In the Mandatory Information section, enter the required information for the following options:

   Option	Description
   Measure Name	Name for the measure that is unique for all measures in the cube.
   Formula	MDX formula used to calculate the value for the measure.

8. (Optional) Expand the Optional Information section and edit one or more of the following options:

   Option	Description
   Format	Option that determines how the value for the measure is displayed (example: 0.00 or #, ###).
   Visible	Value indicating whether the measure element is visible in the Pentaho Analyzer design environment. Elements that are not visible cannot be accessed directly in Pentaho Analyzer to use in reports. However, hidden elements can still be used to build expressions and conditions that are internally evaluated by the Mondrian engine for reporting. The default value is true.
   Parent	Fully-qualified MDX identifier of the parent member. If not specified, the member will be at the lowest level in the hierarchy.

9. (Optional) Expand the Describe Measure section and edit one or more of the following options:

   Option	Description
   Caption	String of text that is displayed instead of the calculated measure's name. You can use captions to provide a user-friendly label for reports or for localization so that the measure's name appears in the local language.
   Description	A description of the measure.

10. Click Create. The calculated measure is created and added to the Measures node inside the cube.

11. Click Save to save changes to the model.