Using Level References to Create Different Generation Shared Members

To create shared members of different generations by using the level references build method, ensure that primary and secondary roll-ups are specified in one record. You can specify as many secondary roll-ups as you want, as long as they are all in one record.

Define the field type for the shared member as LEVEL. Then enter the level number. While processing the data source, Essbase creates a parent at the specified level and inserts the shared members under it.

For example, to share the products 100-20, 200-20, and 300-20 with a parent called Diet and two parents called TBC and Grandma’s, use the sample data file and the rules file shown in Figure 96, Sample Rules File: Members Shared at Different Generations Using Level References:

Figure 96. Sample Rules File: Members Shared at Different Generations Using Level References

This image illustrates a rules file for creating shared members of different generations by using the level references build method, as described in the text preceding the image.