Updating SAS OLAP Cubes

Updating Cubes in SAS OLAP Cube Studio

The Incremental Update function in SAS OLAP Cube Studio enables you to add new members and new data to a cube as well as update captions for dimensions, hierarchies, levels, member properties, and measures. The Incremental Update function enables you to specify cube updates and submit the generated procedure code without rebuilding the cube. Although you can add data to a cube, the cube structure cannot be modified. Adding or removing dimensions, levels, measures, hierarchies and properties is not part of the Incremental Update function.

When you initially create a cube, you can establish whether the cube will allow new members to be added to the cube at a later point. You can also allow new members to be added to a specific dimension on a cube. The Cube Designer - Dimensions page and the Dimension Designer - General page on the Cube Designer wizard have the option Allow new members during incremental update. See the SAS OLAP Cube Studio Help for further details.

The Incremental Update wizard is available from the Actions menu and the context menu in SAS OLAP Cube Studio. It is active on the menu if the selected cube meets the requirements for adding data. If you select the Incremental Updates function, a drop-down menu opens. Depending on the type of update you need to perform, select one of the following options.

Update In-Place
Generate New Cube
Coalesce Incremental Data

After you have updated your cube, you can check to see a list of the generations for the cube. Select the Generations tab on the Properties dialog box for the cube.

See the SAS OLAP Cube Studio Help for further details on the Incremental Update function.

Top of Page