Avoid Growing Pains: New Cube Update Features You Should Know About

Overview

After a SAS OLAP cube is created, it is possible to update the data for the cube without completely recreating it. The SAS 9.2 OLAP Server enables one to incrementally update SAS OLAP cubes. An incremental update involves adding cell data and members to an existing SAS OLAP cube. Incremental updates of a cube are generally faster than rebuilding the cube from the combined set of input data and update data. There are several decisions one must make before one creates the cube that will make the incremental update process run smoother. One will need to decide how to structure the cube and the input data as well as choose a method of update.