You use the Dimension Properties tab to set general dimension properties.
For any dimension, in the Dimension Type node, you select a dimension type:
Existing definition or none—Apply the dimension type that the outline specifies (the default). If the outline does not specify a type, Essbase applies “none.”
None—Do not apply a dimension type.
Accounts—Use the dimension for measured items, such as profit or inventory. Only one dimension per outline can be tagged as accounts. If you tag a dimension as accounts, set the Accounts dimension properties.
Time—Use the dimension to describe how often data is collected and updated. Only one dimension per outline can be tagged as time.
Country—Use the dimension (block storage only) to track business activities in multiple countries. For a country dimension, in the “Currency name” box, you can enter a currency name.
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:
Existing definition or unique—Apply the uniqueness setting that the outline specifies (the default). If the outline does not specify a setting, Essbase applies “unique.”
Member names unique in dimension—Require unique member names.
Member names duplicated in dimension—Allow duplicate (non-unique) member names.
For any dimension, in the “Data storage” node, you select a storage option:
Existing definition or store—Apply the storage setting that the outline specifies (the default). If the outline does not specify a setting, Essbase applies “store.”
Store data—Store the data with the dimension.
Never share—Do not share the data associated with the dimension. Thus, even for implied share relationships, such as between parent and child, data is duplicated (stored with the parent and the child). This option does not apply to stored hierarchies within aggregate storage outlines.
Label only—Do not associate data with the dimension. For aggregate storage outlines, this option has restrictions.
Dynamic calc and store—Calculate the data associated with the dimension (block storage only) when the data is requested by a user and store the calculated data.
Dynamic calc—Calculate the data associated with the dimension (block storage only) when the data is requested by a user and discard (do not store) the calculated data.
For any dimension of a block storage database, in the Configuration node, you select a configuration option:
Existing definition or sparse—Apply the configuration setting that the outline specifies (the default). If the outline does not specify a setting, Essbase applies “sparse.”
Dense—Dense dimensions should contain data values for many dimension intersections.
Note: | Because you cannot associate attributes with members of dense dimensions, do not set the storage setting of a base dimension to dense. |
Sparse—Sparse dimensions should contain data values for few dimension intersections. For example, if all products are not sold in all markets, the Products dimension should be sparse.
For any dimension of an aggregate storage database, in the ”Hierarchy type node, you select a hierarchy type:
Existing definition or stored—Apply the hierarchy setting that the outline specifies. If the outline does not specify a setting, Essbase applies “stored.”
Multiple hierarchy enabled—Use both stored and dynamic hierarchies.
Stored—The default. The accounts dimension cannot be stored.
Dynamic—The accounts dimension is automatically set as dynamic.
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:
Existing value or 0—Apply the solve order setting that the outline specifies. If the outline does not specify a setting, Essbase applies “0.”
New value—Assign a calculation priority (0–127). The formula on the dimension or member that is assigned the highest solve order is calculated first. Values less than 0 or greater than 127 are reset to 0 and 127, respectively. No warning message is displayed. The default value is 0.
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. |
“Setting Dimension and Member Properties” in the Oracle Essbase Database Administrator's Guide