Edit cube metadata

You can edit cube metadata that describes the cube and controls its visibility and availability.

Complete the following steps to edit the metadata for a cube in a semantic model:

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 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 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. Click the More Actions icon and select Edit. The Cube Editor window opens.

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

   1. In the Mandatory Information section, enter a new Cube Name.

      Note: By changing the name of the cube, previous existing reports built using this cube from this model will no longer work, be cautious doing this action.

   2. In the Optional Information section, edit one or more of the following options:

      Option	Description
      Default Measure	The measure used by default when the cube is queried to aggregate or visualize data for analysis or in a report.
      Cache	Value indicating whether the fact table data for the cube is stored in memory by the Mondrian engine. Caching fact table data for a cube can improve query performance by reducing how often the engine must fetch data from the data connection. The default value is true.
      Visible	Value indicating whether the cube 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.
      Enabled	Value indicating whether the cube is active and available for use in the semantic model. You can temporarily disable a cube without deleting it from the model. The default value is true.

   3. In the Describe Cube section, edit one or more of the following options:

      Option	Description
      Caption	String of text that is displayed instead of the cube’s name. You can use captions to provide a user-friendly label for reports or for localization so that the cube's name appears in the local language.
      Description	Description of the cube to help users understand the purpose or contents of the cube.

7. Click Apply. Edits to the cube’s metadata are applied.

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