You use the Dimension Build Settings tab to determine how members change during dimension builds.
In the Dimension node, you select a dimension. All options that you select in the Dimension Build Settings tab apply to the selected dimension. If the node is empty, click the Outline button to associate the rules file with an outline.
The tab includes several option groups:
Existing members
Attribute members
Build method
Member sorting
Member update
Options of the Existing members group:
Ignore conflicts—Ignores member names that exist in the outline; cannot be selected if the “Allow moves” option is selected; available only with the Add build method
Allow moves—Within a dimension, moves members and their children to new parents; recognizes primary members and matches them with the data source; cannot be selected if the Ignore conflicts option is selected; not available for duplicate member outlines
Allow property changes—Changes member properties to the properties specified in the data source; makes the Allow UDA changes option available.
Allow formula changes—Changes member formulas to the formulas specified in the data source.
Allow UDA changes—Changes UDA values to the values specified in the data source (If the option is not selected, data-source UDAs are added to existing UDAs)
Allow auto fix shared member prototype errors—If, during a dimension build, a shared member is loaded into a higher position in an outline than its primary member, makes the topmost shared member the primary member and the former primary member a shared member. This prevents a validation error.
Do not share—Rejects records that specify new parents for members; available only with the Parent/child build method; not applicable to members of stored hierarchies within aggregate storage databases (If the option is not selected, shared members can be created.)
Options of the Attribute members group:
Allow association changes—Changes member attribute associations to the associations specified in the data source (For example, if the data source associates the 100-10 member with the 8 Ounce attribute and the outline associates the 100-10 member with the 12 Ounce attribute, Essbase associates the 100-10 member with the 8 Ounce attribute.)
Do not create members—Prevents Essbase from creating members
Options of the Build method group:
Use generation references—Builds dimensions from top-down data sources, numbering generations hierarchically from the top down (the dimension as generation 1, its immediate children as generation 2, and so on)
Use level references—Builds dimensions from bottom-up data sources, numbering levels hierarchically from the bottom up (the lowest level as level 0)
Use parent/child references
Add as sibling of member with matching string
Add as sibling of lowest level
Add as child of—Adds members as children of the selected dimension
Process null values—Promotes primary fields (such as member names) that occur after null fields and ignores secondary fields (such as member properties and aliases) that occur after null fields; available only with the generation and level build methods
Options of the Member sorting group:
None
Ascending
Descending
Options of the Member update group
Merge—Inserts members among existing members (the default)
Remove unspecified—Deletes members that do not exist in the data source; available only with the generation, level, and parent/child build methods
“Understanding Advanced Dimension Building Concepts” in the Oracle Essbase Database Administrator's Guide
“Understanding Shared Members” in the Oracle Essbase Database Administrator's Guide