Data Source Differences for Aggregate Storage Dimension Builds

Data sources for modifying aggregate storage outlines should not include field values that apply only to block storage outlines. Table 204 lists the member codes that are recognized in dimension build data sources as properties for members of aggregate storage database outlines. Any other consolidation code is ignored and + (Add) is assumed. See Using the Data Source to Work with Member Properties.

Table 204. Valid Consolidation Properties for Members of Aggregate Storage Outlines

Code

Description

%

Express as a percentage of the current total in a consolidation (applies only to members of a dynamic hierarchy)

*

Multiply by the current total in a consolidation (applies only to members of a dynamic hierarchy)

+

Add to the current total in a consolidation (applies only to members of a dynamic hierarchy)

-

Subtract from the current total in a consolidation (applies only to members of a dynamic hierarchy)

/

Divide by the current total in a consolidation (applies only to members of a dynamic hierarchy)

~

Exclude from the consolidation (applies only to members of a dynamic hierarchy or members beneath Label Only members in a stored hierarchy)

O

Tag as label only

N

Never allow data sharing

C

Set member as top of a stored hierarchy (applies to dimension member or generation 2 member)

D

Set member as top of a dynamic hierarchy (applies to dimension member or generation 2 member)

H

Set dimension member as multiple hierarchies enabled (applies to dimension member only)

Currency name and currency category field types are not supported for aggregate storage outlines.

In aggregate storage outlines, formulas must be specified in the same format as MDX numeric value expressions. See Developing Formulas on Aggregate Storage Outlines.