Beginning with Service Pack 3, it is possible to synchronize changes of the input data table metadata with the cube metadata. This can be done by adding the SYNCHRONIZE_LEVELS option to the PROC OLAP Statement as follows:

This functionality is only available for existing cubes. The process will check the current SASColumnName attribute of the input columns in the metadata repository. If it differs from the current Level name defined for that column, the Level name of the existing cube will be updated to reflect the changes. The default Level caption will also be updated.

Existing reports and queries will need to be modified to pick up the change. Additionally, any permission conditions, calculated measures or named sets will also need to be updated to reflect the changes.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :