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 additional 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 that you need to perform,
select one of the following options.
-
-
-
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 additional details about the Incremental Update function.