Updating and Rebuilding Private Dimensions

Analysis Services

Analysis Services

Updating and Rebuilding Private Dimensions

After you update a private dimension or its table, you must process it. To process a private dimension, process the cube in which it is included. The type of cube processing that is required depends on the type of change made to the dimension. One of the following cube processing options is appropriate:

  • Refresh data option

    Processes the addition of members (that is, rows) to the dimension table. This method does not process changes to a dimension's structure or relationships among members or deletion of members.

  • Full process option

    Processes changes to a dimension's structure such as adding, deleting, or moving a level. This method also processes changes to member relationships such as moving a member from one parent member to another.

Exceptions are changing dimensions, whose cubes do not always require processing with the Full process option after changes to the dimension's structure or changes to member relationships. Changing dimensions include virtual, parent-child, and relational OLAP (ROLAP) dimensions. For more information, see Changing Dimensions.

For information about processing a cube by using the Refresh data option, see Updating and Refreshing Cube Data. For information about processing a cube by using the Full process option, see Processing Cubes.