Adding a cube to the model

  1. Select Dashboards > Data Integrations > OLAP Modeling.
  2. Select the model to which to add a cube.
  3. In the navigation tree, select Cubes.
  4. Click Add.
  5. Specify this information:
    Name
    Specify the name of the cube. After you add the cube to the model, you cannot edit the cube name.
    Default Caption
    Specify the caption for the cube.
    Default Description
    Optionally, specify the description for the cube.
  6. Click Next.
  7. In the Available Dimensions section, select the required dimensions and click the arrow icon to move them to the Selected Dimensions section. To select multiple dimensions, either press SHIFT on your keyboard and then select multiple adjacent dimensions, or press CTRL and select multiple dimensions.
    A cube requires at least two dimensions.
  8. Click Next.
  9. Optionally, specify this information:
    Measure Dimension
    Select the measure dimension. If not set, then you can select it later when you manage the cube properties.
    Format Dimension
    Select the format dimension. If not set, then you can select it later when you manage the cube properties.
    Enable cube access control
    Optionally, enable the cube access control. If enabled, the permissions that are defined in the Table Access Control Cube (#_TABACC) are activated. If disabled, then you can enable it later when you manage the cube properties.
  10. Click Finish.