Multiple Logical Sources

Mapping multiple physical tables to a single logical source

This is performed if the tables are in a Snow Flake schema, for aggregate navigation for fragmentation etc. The following example shows how a sub dimension table for Product table can be added as a source.

Method 1

1) Create new sub dimension table and import it to the physical layer.

2) Create the alias of new table and create required join to dimension table (product table).

W_prod_d---<w_prod_exp_d

3) Then in BMM(logical) layer create new logical table>name=prod_exp.

4)      Add tables (w_prod_d and w_prod_exp_d) to the source of new table.

5) Drag and drop the columns (uncommon in both) from the two tables to new logical table in BMM layer.

6) Create join between new table and existing fact table in BMM layer.

7) Specify content for the new table in fact table.

8) DC on new table keys>select primary key.

9) Transfer the new table to the presentation layer. Save and Close.

Method 2

Method 2 is simple add the sub dimension to the source of the Product dimension table and then drag and drop the columns of the sub-dimension table from Physical to BMM layer. Transfer new columns to the presentation layer.