Uniquely Identify Members Through the Load Rule

To ensure that Essbase duplicate member outline hierarchies are built correctly, you need to use qualified member names in the source data, or use the dimension build load rule to construct qualified member names from fields in the source data.

In most situations, the reference method and arrangement of fields provide enough information for Essbase to map data source columns to members in a duplicate member outline. The dimension build rule for duplicate member outlines is similar to the rule for unique member outlines.

The following operations require more complex rules for qualified member names:

  • Parent-child dimension builds: The parent-child build method requires two fields, one for parent and one for child. For duplicate member situations, the parent field must contain the qualified member name. Parent-child dimension builds on duplicate member outlines do not support attribute association. To ensure that attributes are associated with the correct members, perform the associations in a separate pass, using a generation-reference or level-reference load rule.

  • Association of attributes to existing members in the outline: For duplicate member situations, the field to which the attribute is associated must contain the qualified member name.