Add a simple measure to a cube

Add a simple measure to use values pulled directly from a column in the cube’s fact table as a measure.

Complete the following steps to add a simple measure to 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 to which you want to add a measure 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. Select the cube you want to edit, and then click the Add a Measure icon. The Add a Measure dialog opens.

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

5. Select Add Simple Measure, and then click Confirm. The Add a Simple Measure dialog opens.

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

   Option	Description
   Measure Name	A unique name for the simple measure.
   Source Column	Column that is the source of the 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 for grouping and calculating data for the measure.

7. (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.
   Data Type	The type of data used for the measure. Types include String, Numeric, and Integer.

8. (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 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.

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

10. Click Save to save changes to the model.