Changes to cube creation
As of Planning Analytics Workspace 2.0.75, you can no longer create a cube from the Data tree in a book.
Cubes can be created only in a Modeling workbench. Additionally, the cube creation process has been modified and an option to create a new cube based on the structure of an existing cube is now available.
Create a new cube on the Modeling workbench
To create a cube:
- Open a Modeling workbench.
- Expand the Modeling tools menu, then click Create cube.
- Select the database on which you want to create the cube.
- Enter a name for the cube.
- Click Next.
- 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.
- 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.
- Click Create to create the new cube.
Create a new cube based on the structure of an existing cube
If a cube exists with the structure and dimensionality that you want you use in a new cube, the
Create from cube option provides a handy shortcut for cube creation.
- Open a Modeling workbench.
- In the Databases tree, locate the existing cube that you want to use as the basis for a new cube.
- Right-click the existing cube, then click Create from cube.
- Enter a new Cube name, then click Next. The dimensions from the existing cube are preselected and ordered as specified in the existing cube.
- Optionally, you can select additional dimension to include in the new cube, remove preselected dimension, or change the order of dimensions for the new cube.
- Click Create.