Using Parent-Child References to Create Different Generation Shared Members

To create shared members at different generations using the parent-child references build method, define the PARENT and CHILD field types. Ensure that Essbase is set up to allow sharing (on the Dimension Build Settings tab of the Dimension Build Settings dialog box, clear the Do not share option). When sharing is enabled, Essbase automatically creates duplicate members under a new parent as shared members.

Figure 97. Sample Rules File: Members Shared at Different Generations Using Parent-Child References

This image illustrates a rules file for creating shared members at different generations using the parent-child references build method.