Export (0) Print
Expand All
Expand Minimize

Process a Dimension Dialog Box

SQL Server 2000

Process a Dimension Dialog Box

Use this dialog box to process a shared dimension.

This dialog box appears when in the Analysis Manager tree pane, in the Shared Dimensions folder, you right-click a shared dimension, and then click Process.

Options

Incremental update

Select this option to append new dimension members to your shared dimension. This option is appropriate when the structure and relationship of the dimension levels and members have not changed, but new members (that is, rows) have been added to the dimension table.

A cube that incorporates a shared dimension remains available to users while the dimension is incrementally updated, and the added dimension members are available in the cube after the update is complete.

Rebuild the dimension structure

Select this option to completely rebuild the dimension structure. This option is appropriate after you have made changes to the structure or relationship of the dimension levels or members. For example, use this option after you add, delete, or move a level, or after you move a member from one parent member to another.

Important  If a shared dimension's structure is updated and saved but not processed, it will automatically be processed when any cube incorporating the dimension is processed. At that time any other cubes that incorporate the dimension immediately become unavailable to users and must be processed before they can be used again.

Show:
© 2015 Microsoft