Skip to main content

OLAP Cube

An OLAP cube is a multidimensional data structure that stores aggregated and calculated information from your data warehouse. It organizes data into dimensions, measures, and slices, allowing you to analyze information from different perspectives without running complex queries. By using cubes, you can quickly explore trends, compare key metrics, and drill into details for deeper insights.

You can refresh cube data at any time by selecting Refresh Screen Data from the left panel. This ensures the cube reflects the most recent data available.

Create a cube​

  1. In the navigation panel, click the gear icon at the bottom left.
  2. Select OLAP Manager from the sidebar.
  3. In the Options panel on the right, click the Add Cube icon.
  4. Enter a description.
  5. Enter the name used in the SEI for the table. Do not use spaces.
  6. Click Save. Your cube appears in the list, and its details are displayed on the right for customization.

Customize a cube​

  1. Select your cube from the list.
  2. Update the settings as needed in the Cube Details panel.
  3. Click Save to apply your changes.

Cube Details settings​

SettingDescription
DescriptionSpecifies the text label for identifying the cube in the list.
Table NameSpecifies the name used in the SEI database for the table. Do not use spaces.
In ProductionPrevents changes to the cube structure. When cleared, the structure can be modified but the data is inaccessible to users.
Auto-Deactivate on FailureAutomatically removes the cube from production if a load fails. This prevents users from accessing incomplete or outdated data. This option is enabled by default.
DescriptionSynchronizes a description table in the data warehouse. This table stores labels (for example, customer names) that are typically not included in regular cubes but can be linked with other cubes.
LoggingRecords each cube build, load, or refresh in the database log. Avoid enabling logging for high-frequency refreshes to prevent log overload.
Columnstore indexesCreates columnstore indexes on the cube to reduce disk usage and improve slice loading speed.

  • The clustered index is created after a Load All process.
  • The columnstore clustered index is created after a Build process.
For details, see Columnstore indexes overview.
No null in sourcesRemoves NULL logic from the WHERE clause when the source data does not contain null values. Applies to Oracle data warehouses only.
Disable indexes during RefreshTemporarily disables indexes before inserting data in the history table during a refresh. This can improve performance for large datasets. Indexes are re-enabled afterward. This option cannot be enabled when Columnstore indexes is set.

Edit an existing cube​

  1. In the navigation panel, click the gear icon at the bottom left.
  2. Select OLAP Manager from the sidebar.
  3. Select the cube you want to edit.
  4. Make the necessary changes from the Cube Details panel.
  5. Click Save.

Delete a cube​

  1. In the navigation panel, click the gear icon at the bottom left.
  2. Select OLAP Manager from the sidebar.
  3. Select the cube you want to delete.
  4. In the Options panel on the right, click the Actions icon.
  5. Select Delete Cube.
  6. In the confirmation dialog, select the checkbox, and then click Yes.