Working with Cubes

Adding a Cube

To add a cube:

  1. Click on to create a new cube. You can also press "c" instead.

  2. The cursor will change to a crosshair. Move the cursor near the left of the Playpen area, and click. The Cube Properties box will appear.

  3. Enter the following information:

    In this field ...

    Do this ...

    Name

    Enter a measure name.

    Caption

    Enter the measure caption.

    Default measure (optional)

    Enter the default measure. Leave this field empty if you create a new cube.

    Fact table

    Either select an existing table or create a new view using a SQL statement.

  4. Click on OK.

  5. You can now add measures to the cube.

Adding a Virtual Cube

Virtual cubes are not supported yet.

Adding a Dimension to a Cube

To add a dimension to a cube please readthe section called “Adding a Dimension usage”.