Aggregate Record Properties

On a case-by-case basis, you must determine which aggregates you want to save for each dimension in the cube collection. You can select either ALL, NONE, or ROOT in the Persist Aggregate field of the Edit Cube Collection Dimension dialog box. Here are explanations for these selections:

• ALL: Select to persist all of the dimension member aggregate values to the database.

• NONE: Select to persist none of the dimension member aggregate values to the database.

• ROOT: Select to persist only the value of the hierarchy root member to the database.

See Defining Additional Cube Collection Dimension Properties.