Create a cube

You can create cubes when you are a Modeler or an Administrator. Cubes are created and stored on a specific database.

Create a cube in Planning Analytics Workspace

About this task

As of Planning Analytics Workspace 2.0.75, cubes can be created only on a Modeling workbench. You cannot create a cube in a book.

Note: When you create a cube using the REST API, transaction logging is enabled on the new cube. The Planning Analytics Workspace modeling workbench uses the REST API for all interactions with TM1®. However, if you create a cube with the CubeCreate TurboIntegrator function, transaction logging is not enabled. To enable transaction logging, use the CubeSetLogChanges TurboIntegrator function.

Procedure

  1. Open a Modeling workbench.
  2. Expand the Modeling tools menu, then click Create a cube.
    Create a cube option on the Modeling tools menu
  3. Select the database on which you want to create the cube.
  4. Enter a name for the cube.
    Cube creation dialog box showing Database and Cube name options
  5. Click Next.
  6. Select the dimensions you want to include in the cube from the Dimensions list. When you select a dimension, it is added to the Selected list.
    Dimension selection screen of the cube creation process
  7. Optionally, you can change the order of dimensions in the cube by clicking a dimension handle and dragging it to a new position or by clicking the Up or Down arrow next to a dimension.
  8. Click Create to create the new cube.