Child Live Access Source to Parent Warehouse Source

Important: This scenario is supported for Appliance spaces where the Live Access source is located on the same database instance as the Birst warehouse.

Tip: Starting with 5.20.4, for Live Access sources modeled in Manage Local Sources, in the child space use Manage Local Sources – Joins – Add Join to create a join between a child dimension and parent fact, and/or between a child fact and a parent dimension.

1. Create the package in the parent space. See Creating a Package.
2. Import the package to the child space. See Importing a Package.
3. In the child space, go to Admin - Define Sources - Data Flow.
4. Right-click on the Live Access source and select Join to a Related Source.
   
5. Drag-and-drop the line on the parent fact or dimension.
   
   
6. Specify the join.
   
7. All columns can be selected for the Live Access source. However, for the warehouse source only level key columns can be included in the join.
   
   
8. Create your reports and dashboards using the blended data.