Open the Modeler and select a database, then click on Cubes to expand the list of cubes in the database. To create a new cube, either right-click on Cubes or click on the icon, as indicated in the screenshot below:
The New Cube dialog appears, where you can enter a name and description of the cube. You can also select from a list of templates and select dimensions for the cube.
Click OK to finish.
There are two requirements for creating a cube:
- You must have a minimum of two available dimensions in the database.
- Each selected dimension must have at least one element.
Note: with Excel 2007 and newer versions, cubes are limited to 250 dimensions due to processing limitations of the PALO.DATA functions.