Creating New Cubes


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.