1. Database Administrator's Guide for Oracle Essbase
  2. Dimension Build Examples
  3. Build Duplicate Member Outlines
  4. Build Qualified Member Names Using the Load Rule

Build Qualified Member Names Using the Load Rule

If you want to build to a duplicate member name outline, but the source data does not contain the qualified member names, you can add static values in the Essbase dimension build rule to edit and join multiple fields, resulting in qualified member names.

Before you can build duplicate member names, they must be enabled also in the outline properties. Refer to Duplicate Member Names in Outlines for more information.

To create qualified member names, use static values to create brackets and periods, and moves/joins to build the names. For example, you can assign population attributes to existing city members in a duplicate member dimension. You can use join, move, and create operations to build the qualified name.

For example, assume the cities in the following source of data already exist in the outline. You want to associate with the cities the population attributes in the last column of this four-column source of data:


Central  "Kansas City"  Missouri    1070052
East     "New York"     Albany  8104079

Reshape this source file through the dimension build rule to build qualified names and sequence the field columns. Make the following changes in Preview mode so you can observe the static values in the preview data.

  1. Create a data file qualmbr.txt containing the records above. Upload the data file to the cube directory.

  2. On the Applications page, open the application and then open the database (cube).

  3. Select the Scripts tab, and then click Rules.


    Scripts tab is selected and Rules tile is highlighted, in Essbase web interface.

  4. Click Create and choose Dimension Build (Regular).


    In the database dialog, create button is pressed and option Dimension Build (Regular) is selected

  5. In the New Rule dialog,

    1. Enter a rule name; for example, qualmbr.

    2. For Source Type select File, click Catalog and navigate to qualmbr.txt.

    3. Leave the Header Record Number and Dimension Build Record Number fields as 0.

    4. Change the Delimiter value from Comma to Tab.

    5. Click Proceed.

  6. Use Create > With Static Value four times, to create one field each for the following text elements:

    • [

    • ].[

    • ].[

    • ]

  7. Using Move operations, move the fields to the following sequence:


    Static field values in a dimension build rule. Field 1: "[", Field 2: "Central", Field 3: "].[", Field 4: "Missouri", Field 5: "].[", Field 6: "Kansas City", Field 7: "]", Field 8: "1070052". Second record with Albany has similar fields.

  8. Use Join operations to make the elements into just two fields:


    Static field values in dimension build rule. Field 1: "[Central].[Kansas City].[Missouri]", Field 2: "1070052". Second record with Albany has similar fields.

  9. Set the field types.


    Field selections made in dimension build rule are Field 1: Market > Parent. Field 2: Market > Child.

  10. Click Dimension and define the build method. In the example above, Parent Child method works.

  11. Check other dimension build operational instructions. Ensure that the Unique setting is Duplicate or Existing.

  12. Verify the rule, then save and close. If there are any errors, see Requirements for Valid Dimension Build Rule Files.

  13. Run the dimension build job.