Edit a simple measure in a cube

Edit a simple measure to change the properties that describe the measure, control its visibility and availability, or define which data is pulled from the cube’s fact table.

Complete the following steps to edit a simple 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 simple 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 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*	A unique name for the simple measure.
      Source Column*	Column that is the source of the simple measure's values. If not specified, you must enter a measure expression for the name of an existent column in the Facts table of the cube.
      Default Aggregation*	Default method used in reports of grouping and calculating data for the simple 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 simple measure is displayed (example: 0.00 or #, ###).
      Visible	Value indicating whether the simple 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.
      Data Type	The type of data used for the simple measure. Types include String, Numeric, and Integer.

   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 simple measure’s name. You can use captions to provide a user-friendly label for reports or for localization so that the simple measure’s name appears in the local language.
      Description	A description of the simple measure.

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

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