If you use this build method, when Essbase encounters a new member in the source data, it scans the outline for the level 0 branch of members and adds the new member(s) as a sibling of these members.

For this dimension build example, assume you want to add A100-20 and A100-99 as siblings of the lowest level members in the Measures dimension.

Assume you want to use the following text data file to add the new members:

100-10	Texas	A100-10	100	120	100
200-20	Texas	A100-99	111	154	180

You can create the following rule file to build the dimensions using the Add as a sibling at the lowest level build method.

To recreate this example,

1. Import/build the Sample Basic cube, using the application workbook available from the gallery in the file catalog on the Essbase Server.

2. Create a tab-delimited data file like the following, name it siblow.txt, and upload it to the Sample Basic cube directory.

   100-10	Texas	A100-10	100	120	100
   200-20	Texas	A100-99	111	154	180

3. On the Applications page, expand the application (Sample).

4. From the Actions menu, to the right of the cube name (Basic), launch the inspector.

   
   
   
   
   

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

   
   
   
   
   

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

   
   
   
   
   

7. In the New Rule dialog,

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

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

      When you click Catalog, the file is expected to be located in the cube directory on the Essbase Server by default, so you must have already uploaded it using the Files section of the Essbase web interface. If the file is on your client machine, click File Browser to locate the file.

   3. Leave the Header Record Number and Dimension Build Record Number fields as 0. Header records are not useful for dimension builds.

   4. Change the Delimiter value from Comma to Tab.

   5. Click Proceed.

   6. The dimension build rule opens with undefined fields, and preview data (from the text file) populating the grid below the fields.
      
      

8. As this is a new rule, there are no dimensions associated yet.

   1. Click Dimensions.
      
      
      
      
   2. Select or type the dimension name Measures, and click Add.

9. Now you need to define the build method and check other dimension build operational instructions. Click Measures to edit the properties.

10. Change Build Method to Add as sibling of lowest level, and leave the Member Name field below it blank.
    
    

    Click OK.

11. Click the Dimension selector in Field 3, and select Measures.
    
    

12. Leave the Type selector of Field 3 blank.

13. Select Fields 1 - 6. To do this, click on the inactive header area labeled Field 1, hold down Shift key, and click the Field 6 header area. Now hold the Control key and click field 3 to deselect it. Click Ignore.
    
    

    As a result, this rule will only operate on the third field of each record. Ignoring fields can be helpful when you don't need to use every field in the source for your dimension build, yet you don't want to prepare different sources.

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

15. Run the dimension build job.

16. View the outline, and inspect the children of Margin (in the Measures dimension) to confirm that the members were added.