When you add data to
a cube, the values for member properties are normally not updated.
However, you can specify the DIMENSION statement option UPDATE_DIMENSION
and the MEMBERS_AND_PROPERTIES value to update the member properties
for a dimension. When updating member properties, the new values must
be contained in either the ADD_DATA table for a detail load cube
or the update table for the dimension for a star schema load.
For a star schema cube,
it is possible to change the member property values without adding
data to the cube. The table of new data is not required. You can select
to update member properties on all the dimensions or on just certain
dimensions. In both instances, the original dimension table for a
dimension is scanned for new values unless a different table is provided.
The Cube Designer – Dimensions page and the Dimension Designer
- General page have the option
Allow new members during
incremental update. See the SAS OLAP Cube Studio Help
for additional details.