Edit a calculated measure in a cube

Edit a calculated measure to change the properties that describe the measure, control its visibility and availability, and specify the formula and parent used to calculate the measure.

Note: If you edit a semantic model externally in Pentaho Analyzer and create a calculated measure for the semantic model, the following changes occur in the semantic model:

• Pentaho Analyzer saves the calculated measure in the semantic model's XML as a read-only structure. Read-only structures are visible in Semantic Model Editor but cannot be edited or deleted. Semantic Model Editor displays a read-only structure in the following locations:

  • Canvas mode: Displays read-only structure as grayed-out element.

  • Advanced mode: Displays read-only structure as gray text with grey highlighting.

  • Model Structure tab: Displays read-only structure as grey text with a grey lock icon next to the name.

• When the semantic model is imported back into the Semantic Model Editor, comments in the XML are discarded from the semantic model.

Complete the following steps to edit a calculated measure in a cube:

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. Open the semantic model that contains the cube with a calculated measure you want to edit by completing the following sub steps:

   1. In the Semantic Models list, navigate to the model you want to open by searching or scrolling through the list.

   2. Click Open. The model opens in the canvas.

4. On the canvas, locate the cube, measures node, and measure you want to edit.

   Note: 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.

5. Next to the measure's name, click the More Actions icon and select Edit. The Edit Calculated Measure window opens.

6. Edit options in one or more of the following sections:

   1. In the Mandatory Information section, edit one or more of 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.

      *Required

   2. Expand the Optional Information section, and then edit one or more of the following options:

      Option	Description
      Format	Option that determines how the value for the calculated measure is displayed (example: 0.00 or #, ###).
      Visible	Value indicating whether the calculated 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.

   3. Expand the Describe Measure section, and then 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 calculated measure’s name appears in the local language.
      Description	A description of the calculated measure.

7. Click Apply. Edits to the calculated measure are applied.

8. In the Semantic Model Editor, click Save to save changes to the model.