You can add all new members as children of a specified parent, generally a “dummy” parent. After Essbase adds all new members to the outline, review the added members and move or delete them in Outline Editor.
When Essbase encounters a new member in the data source, it adds the new member as a child of the parent that you define. The parent must be part of the outline before you start the dimension build.
For example, the data source in Figure 79, Rules File Fields Set to Add Members as a Child of a Specified Parent (SIBPAR.TXT) contains two new members (600-54 and 780-22) for the Product dimension (field 1). Assume that you previously added a member called NewProducts under the Products dimension.
To add the example members to the database under the NewProducts member, set the values shown in Table 46 in the rules file:
Table 46. Example of Adding Members as a Child of a Specified Parent
| ||
Enter NewProducts in the Add as Child of text box. |
Figure 80, Tree for Adding Members as a Child of a Specified Parent shows the tree that Essbase builds from this data source and rules file. 600-54 and 780-22 are added as siblings of NewProducts.