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 further details.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
