Adding Members as Siblings of the Lowest Level

You can add new members from a data source as siblings of members that reside at the lowest level of a dimension—at the level 0 branch. When Essbase encounters a new member in a data source, it scans the outline for the level 0 branch of members and adds the new member as a sibling of these members.

Note:

If the outline contains multiple groups of members at this level, Essbase adds the new member to the first group of members that it encounters.

For example, the data source (SIBLOW.TXT) and the rules file (SIBLOW.RUL) in Figure 77, Rules File Fields Set to Add Members as Siblings of the Lowest Level contain new members (A100-10 and A100-99) to add to the Measures dimension.

Figure 77. Rules File Fields Set to Add Members as Siblings of the Lowest Level

This image illustrates a rules file for adding members as siblings of the lowest-level existing member.

To add the example members dynamically to the database, set the values shown in Table 45 in the rules file:

Table 45. Example of Adding Members as Siblings of the Lowest Level

Field

Value

See

Field 3 (Measures)

Setting Field Type Information

Fields 1, 2, 4, 5, and 6

Ignore the fields

Ignoring Fields

Measures dimension

Select the “Add as sibling of lowest level” build method

Selecting a Build Method

Figure 78, Tree for Adding Members as Siblings of the Lowest Level shows the tree that Essbase builds from this data source and rules file. A100–20 and A100–99 are added as siblings of Margin.

Figure 78. Tree for Adding Members as Siblings of the Lowest Level

This image shows the new members added as siblings of Margin, as described in the text preceding the image.