Dimension Properties Dialog Box—Dimension Properties Tab

You use the Dimension Properties tab to set general dimension properties.

For any dimension, in the Dimension Type node, you select a dimension type:

For any block storage dimension, if you want to calculate the dimension on the second pass through the database, select the “Two-pass calculation” option.

For any dimension of a database enabled for duplicate member names, in the “Member names unique in dimension” node, you specify a member name uniqueness setting:

For any dimension, in the “Data storage” node, you select a storage option:

For any dimension of a block storage database, in the Configuration node, you select a configuration option:

For any dimension of an aggregate storage database, in the ”Hierarchy type node, you select a hierarchy type:

Note:

For information about restrictions related to dynamic and stored hierarchies, see “Hierarchies” in the Oracle Essbase Database Administrator's Guide.

You can assign solve order settings for dimensions and for members. For a dimension, you select an option in the “Dimension solve order' node. For a member, you select an option in the “Solve order” node:

Note:

Members that are not assigned a solve order inherit the solve order of their dimension. For detailed information about solve order, see “Calculation Order” in the Oracle Essbase Database Administrator's Guide.

Related Information