Editing and deleting cubes
When you select a cube in the tree, the Edit Cube dialog box opens in the data section. At the top you see the property fields for names, Cube name, Cube description, and Cube type. In the Dimensions of the Cube list (on the right) you see the dimensions that the cube consists of. The list Available dimensions (on the left) shows the dimensions that can be assigned to the cube. To select the sorting method of the list Available dimensions, click , , or .
| Buttons | Description |
|---|---|
 , 
|
To change the cube structure, move the dimensions from Available dimensions to Dimensions of the Cube, and vice versa, by using these buttons. |
 , 
|
A cube may contain a maximum of 20 dimensions. Adjust the position of a dimension in the Dimensions of the Cube list by using these buttons. |
|
Click this button to remove all dimensions from a cube. |
By selecting the Cube type, you determine the function of a cube:
| Cube type | Description |
|---|---|
| Data | Data cubes (default). |
| Comment | Automatically created cubes which contain the comments. |
| Currencies | System cubes that are nor edited, required for currencies and currency translation. |
| Exchange Rates | System cubes that you cannot edit. They are required for currencies and currency translation. |
| Cell Lock | Cubes that lock cells of assigned cubes. |
| System | System cubes that serve internal purposes of OLAP and Designer. |
| Data Connection | Data connection cubes. |
To delete a cube, select the command on the shortcut menu of the cube in the tree.
Caution:
The position of the
dimensions in the Dimensions of the
Cube list is important for the creation of reports withApplication Studio and should not be changed without
consultation, because report structures must be adjusted.