Creating cubes
- Select Dashboards > OLAP > Edit Database.
- In the Database Structure widget, select the database to which to add a cube.
- Select Cubes and click New Cube in the Cubes of [database_name] widget.
- Specify this information:
- Name
- Specify the name of the new cube.
- Caption
- The specified cube name is used as the caption. Optionally, specify a different caption.
- Description
- Optionally, specify a description of the cube.
- Click Next
-
In the Available
Dimensions column, select dimensions to add to the cube, and
click the arrow icon. Use Shift and Ctrl to select multiple dimensions. If you
select commercial dimensions, any protection that has been applied to them
remains.
Caution:String elements in all but the last dimension are handled as numeric elements.
- Click Next.
- Optionally, specify the measure dimension and the format dimension.
- Optionally, specify the format dimension.
-
Optionally, enable cube access control.
If cube access control is enabled, the permissions that are defined in the #_TABACC cube have effect.
- Click Finish.
- To specify a cache partition dimension for the cube, edit the cube's properties.