Technical data

Creating Data Cubes Chapter 5

Note. In the analytic grid, data cubes formatted as members should have

a field type of Edit Box.

Text: Select to format the data cube’s values as text. This option is useful for

entering names, addresses, and other textual data.

Virtual Cube (doesn’t

store data)

Select to set t

he data cube as a virtual data cube.

Clear to set th

edatacubeasanonvirtualdatacube.

See C

hapter 5, “Creating Data Cubes,” Virtual Data Cubes, page 35.

Note. A virtual data cube must contain a formula. Selecting this option

without entering and accepting a formula for a virtual data cube results in

an invalid analytic model.

Calculate Ag

gregate

Select to enable calculation of the data cube’s aggregates.

Note. If Calculate Aggregate is enabled for the data cube, the analytic

calculation engine initially retrieves the aggregate data from the aggregate

record when the analytic instance is loaded, but overwrites this data upon

recalculation. If this check box is disabled, values from the aggregate record

still load when the analytic instance is loaded; however, these values are not

recalculated.

Clear this check box to disable calculation of all of the data cube’s aggregates,

regardless of specified overrides.

Note. Disab

ling aggregate calculation for data cubes disables all aggregate

calculatio

ns, including the default sum a ggregation.

See Chapter 9, “Creating Hierarchies,” Understanding Override Order of

Precedence, page 82.