Creating Cubes

You can create a cube in a cube diagram using the context menu. You can create the cube dimensions using the carousel for the cube. If you want to connect the cube with a fact set, drag the fact set from other tool windows and drop it in the cube. Use the carousel to use or create hierarchies for a cube dimension.

Creating a New Cube

How to proceed

  1. Position the mouse pointer at your chosen position in the diagram and click on the cube template in the context menu's mini toolbar.

    A new cube is created in the diagram. The name of the cube is automatically selected to be edited.

  2. Enter the name for the cube and confirm with the [Enter] key.

Connecting a Cube with a Fact Set

Context

A cube is a specialization of a view. The connection to a fact set is created using a From clause. The special feature of the creation of a From clause in a cube is that only local attributes of the attribute set are adopted. An appropriate configuration ensures that the right performance indicator stereotypes are used for cube performance indicators.

How to proceed

  • Select the fact set (entity or view) in another tool window and use drag-and-drop to move it to the cube.

    In the cube, appropriate performance indicators are created for all performance indicators of the fact set.

Creating New Cube Dimensions for Existing Dimensions

Context

A cube dimension always references a dimension and uses at least one hierarchy of this dimension as a scale.

How to proceed

  1. Select the cube in the diagram.

    The carousel appears next to the cube.

  2. Drag the cube dimension with the mouse button pressed to the target position and drop it there.

    The dialog for selecting the dimension appears.

  3. Select the dimension and confirm with OK.

    The cube dimension is added as a node in the diagram.

  4. Select the new cube dimension.

    The carousel appears next to the cube.

  5. Drag the cube dimension hierarchy usage with the mouse button pressed to the target position and drop it there.

    The dialog for selecting the hierarchy appears.

  6. Select the hierarchy and confirm with OK.

    The hierarchy is created in the diagram as a container node that contains all of its hierarchy levels and precedences.

  7. Alternatively, select the hierarchy in the Create New Element dialog and enter a name for the new hierarchy in the following dialog.

    The hierarchy is added as an empty Container node in the diagram.

Creating New Cube Dimensions Including New Hierarchy and Dimension

How to proceed

  • Drag the hierarchy's create template from the gallery and drop it on the cube in the diagram.

    A new dimension is created in the background and the hierarchy is created in it.

    Next to the cube, a new cube dimension is created as a node for this new dimension and is connected with the cube by means of an edge.

    Next to this cube dimension, an empty container node is created for the new hierarchy and is connected with the cube dimension by means of an edge.

Assigning Measurement Time to a Cube Dimension

How to proceed

  1. Select the cube dimension in the diagram and select the Measurement Time property from the property area.

    The dialog for selecting the measurement time appears.

  2. Select the measurement time and confirm your selection with OK.

    The selected measurement time is displayed in the node as a property in curly brackets.

  3. Alternatively, select the measurement time in the Create New Element dialog and enter a name for the new measurement time in the following dialog.

    The new measurement time is displayed in the node as a property in curly brackets.