1. Database Administrator's Guide for Oracle Essbase
  2. Dimension Build Examples
  3. Build Shared Members
  4. Build Shared Roll-Ups from Multiple Data Sources

Build Shared Roll-Ups from Multiple Data Sources

In some situations, the data you need 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 source using the most appropriate build method, and then load all other sources using the parent-child references build method. Ensure that Essbase is set up to allow sharing.

For example, using the following Product data source:

"Soft Drinks"   Cola
"Soft Drinks"   "Root Beer"
Cola            TBC
"Root Beer"     Grandma’s

Essbase builds the hierarchy illustrated in Figure 14-22:

Figure 14-22 Sample Hierarchy: Soft Drinks


Hierarchy before loading Vendor. Product contains Soft Drinks and Vendor. Soft Drinks contains Cola and Root Beer. Cola contains TBC, and Root Beer contains Grandma's.

Then load the second source file below to relate the products to the vendors.

Vendor   TBC
Vendor   Grandma’s

Using the dimension build operational instructions for the rule, select the parent-child build method, and ensure that Essbase is set up to allow sharing, by enabling Share.

Essbase builds the outline illustrated in Figure 14-23:

Figure 14-23 Sample Hierarchy: Vendors (Shared Roll-Ups)


Hierarchy after loading Vendor. Product contains Soft Drinks and Vendor. Soft Drinks contains Cola and Root Beer. Cola contains TBC, and Root Beer contains Grandma's. Vendor contains TBC (shared member) and Grandma's (shared member).