Building and Loading the OLAP Cubes

To create the cube database structure in the NectariCube database previously installed, you need to build the cubes.

  1. In the upper right-hand corner, click on the to access the Administration section.

  2. In the left pane, click OLAP Manager.
  3. In the right pane, click Manage.

  4. In the left column, select all the cubes to build by ticking the check box next to the Description column.
  5. In the Manage window:

    1. Select Build in the Action drop-down list.

    2. Select environment(s).

    3. Click Confirm.

  6. In the Confirmation window, select the option and click Yes.

  7. If errors occur refer to Logs to activate the logging feature.

Now that the cubes are built, you can now populate them.

  1. In the right pane, click Manage.
  2. In the left column, select all the cubes to load by ticking the checkbox next to the Description column.
  3. In the Manage window:

    1. Select Load All in the Action drop-down list.

    2. Select environment(s).

    3. Click Confirm.

  4. In the Confirmation window, select the option and click Yes.

The template installation is now complete. Regular data refresh jobs for the cubes can now be scheduled; refer to Scheduler.