To create shared non-level 0 members by using the level references build method, ensure that primary and secondary roll-ups are specified in one record. You can specify unlimited secondary roll-ups, as long as they are all in one record.
Define the field type for the parent of the shared member as duplicate level (DUPLEVEL), and then enter the level number. To create a shared member of the same generation, set the level number of the secondary roll-up to have the same number of levels as the primary roll-up. 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 product lines 100, 200, and 300 with a parent called Soda and parents called TBC and Grandma’s, use the sample data file and rules file shown in Figure 99, Sample Rules File: Non-Level 0 Members Shared at Different Generations Using Level References. This data source and rules file work only if the Diet, TBC, and Grandma’s members exist in the outline. The DUPLEVEL field is always created as a child of the dimension (at generation 2), unless the named level field already exists in the outline.