Cube Building and Modifying Examples

Synchronizing Column Changes

The Synchronize Column Changes function enables you to synchronize a cube when the input table for an existing cube has encountered a column name change. This function finds the name differences between the cube and its input table and changes the hierarchy level names to match the input table column names. The Synchronize Levels function obtains the cube metadata from the metadata repository and compares the names between the input table and the cube hierarchy. If a discrepancy is found, a new cube file and definition are created with the new level name. The level name of the existing cube is then updated to reflect the new column name. The Synchronize Levels function is available for a cube if the cube physically exists and you have writemetadata permissions for that cube.

In SAS OLAP Cube Studio, select a cube in the tree view and right-click. On the context menu, select Maintain Synchronize Column Changes.

The Synchronize Column Changes message dialog box opens. Select OK to continue with the synchronize function. Select Cancel to exit the function.

[untitled graphic]

You can also use the SYNCHRONIZE_COLUMNS option if you are synchronizing the column changes with a PROC OLAP statement. See the SYNCHRONIZE_COLUMNS option on the PROC OLAP Statement for more information.

Top of Page