Build, Load All, Refresh Cube

Once a cube and all its components (dimensions, measures, slices, etc.) have been defined in the OLAP Manager, it must be built before use. The build process generates all required objects in the data warehouse based on the cube definition. After building, you can schedule and run jobs to load data into the cube or refresh it with the latest data. Choosing the correct action ensures the cube contains accurate and up-to-date information while minimizing system load.

Action	Description
Build	Creates the cube structure in the data warehouse based on its design. This step is required before any data can be loaded.
Load All	Loads all data from the source into the cube, replacing existing data if present. Recommended for initial data loads or complete rebuilds.
Refresh	Updates the cube with new or changed records since the last load, based on tracking or refresh rules. Ideal for regular updates.

Build a cube

Build a specific cube

1. On the Administration page, select OLAP Manager from the sidebar.
2. Select the cube you want to build.
3. In the Cube Details panel, select In Production.
4. In the Options panel on the right, click the Actions icon.
5. Select Build Cube.
6. Choose the environment where the cube should be built.
7. Click Confirm.
8. In the confirmation dialog, select the confirmation option, and then click Yes.

Build multiple cubes at once

1. On the Administration page, select OLAP Manager from the sidebar.
2. In the Options panel, select the Manage icon.
3. In the cubes list, select all cubes you want to build.
4. In Action, select Build from the dropdown list.
5. Select the environment.
6. Click Confirm.

important

Building a cube can overwrite an existing cube structure. If a build or refresh fails, enable logging for that cube so you can review the error details. See Logs for information on locating error lines and troubleshooting issues.

Load all data into a cube

1. On the Administration page, select OLAP Manager from the sidebar.
2. In the Options panel, select the Manage icon.
3. In the cubes list, select all cubes you want to load.
4. In Action, select Load All from the dropdown list.
5. Select the environment.
6. Click Confirm.

Refresh a cube

1. On the Administration page, select OLAP Manager from the sidebar.
2. In the Options panel, select the Manage icon.
3. In the cubes list, select all cubes you want to refresh.
4. In Action, select Refresh from the dropdown list.
5. Select the environment.
6. Click Confirm.