When you run an incremental
cube update, you use PROC OLAP to add data and new members to a new
version of the cube. After the update, the new cube is immediately
available for queries under its new cube name. The previous version
of the cube remains active until you disable the old cube and enable
the new version.
Incremental updates
are beneficial because they:
-
enable testing outside of the production
environment
-
can be archived to maintain a history
changes
-
provide for rollback or review
Each version of the
cube remains completely viable. You can enable any version and receive
a fully functional cube that contains all of the data that was previously
available in that version.
Each version of the
cube is represented by a generation folder. The folder contains an
aggregation table. The aggregation table contains the new members
and new data that was added to the cube in that version.
The totality of data
in the new version of the cube is represented by all of the generation
folders and the original aggregation table from which the generations
were built.
When you generate a
new version of a cube, the new version is immediately available for
queries under its new name. To replace the old version with the new
version, using the same cube name, follow these steps:
-
Disable the cube with
PROC OLAPOPERATE, SAS OLAP Cube Studio, or the SAS OLAP Server Monitor.
-
Close all sessions on
the old version of the cube.
-
Rename the old version
of the cube.
-
Rename the new version
of the cube to name of the old cube.
-
As versions accumulate,
you can coalesce cubes to combine all versions into a single, more
efficient aggregation table, as described in the next section.
After you create a new
version of a cube, you can assign the old cube, under its new name,
to a different OLAP schema for archival purposes.
You can delete old versions
as you would with any other cube. Deleting a version removes its metadata.
Physical data that is used by later versions is not deleted. To delete
all generation folders back to the last coalesced cube, coalesce the
new version of the cube.