In many situations, the data for a dimension is in multiple data sources. If you are building dimensions from multiple data sources and want to create multiple roll-ups, load the first data source using the most appropriate build method, and then load all other data sources using the parent-child references build method. Ensure that Essbase is set up to allow sharing (clear Do Not Share on the Dimension Build Settings tab of the Dimension Build Settings dialog box).
For example, using the following Product data source:
"Soft Drinks" Cola "Soft Drinks" "Root Beer" Cola TBC "Root Beer" Grandma’s
Essbase builds the outline illustrated in Figure 104, Sample Outline: Soft Drinks:
Then load the second data source below to relate the products to the vendors using the parent-child build method. Ensure that Essbase is set up to allow sharing.
Vendor TBC Vendor Grandma’s
Essbase builds the outline illustrated in Figure 105, Sample Outline: Vendors (Shared Roll-Ups):