Rules File Differences for Aggregate Storage Dimension Builds

Rules files for building aggregate storage outlines must define only outline properties and field types that apply to aggregate storage outlines. See Table 192, Outline Differences Between Aggregate Storage and Block Storage.

After converting a block storage outline to aggregate storage, update the rules files by associating them to the aggregate storage version of the outline. See “Associating an Outline with an Editor” in the Oracle Essbase Administration Services Online Help.

Field Type Differences for Aggregate Storage Dimension Builds

The solve order field type is available only on aggregate storage databases.

The field contains a number (0–127) that specifies the order in which the member is evaluated in the outline. Values less than 0 or greater than 127 are reset to 0 and 127, respectively. No warning message is displayed. For information on the solve order property, see Calculation Order.

Valid build methods for solve order:

  • Generation

  • Level

  • Parent-child references

  To set field information, see “Setting Field Types” in the Oracle Essbase Administration Services Online Help.

Data Prep Editor Dialog Boxes for Aggregate Storage

As you edit rules files for aggregate storage databases, some dimension build rules file options that apply only to block storage databases are displayed in Data Prep Editor dialog boxes. Table 203 lists block storage rules file settings that do not apply to aggregate storage outlines. Entries in rules files for these options are ignored when the rules file is processed.

Table 203. Aggregate Storage Dimension Build Rules File Differences

Rules File Location in the Administration Services Interface

Dimension Build Rules File Options That Do Not Apply to Aggregate Storage Databases

Dimension Build Settings dialog box, Global Settings tab

Data configuration options

Dimension Properties dialog box, Dimension Properties tab

Dimension types option: Country

Two-Pass calculation option

Data storage options:

  • Dynamic Calc and Store

  • Dynamic Calc

All configuration options

Dimension Properties dialog box, Accounts Dimension tab

None of the options on this tab apply.

Field Properties dialog box, Dimension Build Properties tab

Field type options:

  • Currency name

  • Currency category

Currency functionality does not apply to aggregate storage databases.

See the Oracle Essbase Administration Services Online Help.