OBIEE 11G Add a New Logical Table Source

1 . In the BMM layer, expand Sample Sales > D3 Customer > Sources. Notice that the D3 Customer logical table has one logical table source named D3 Customer.
Screenshot for Step
2 . Rename the D3 Customer logical table source (not the logical table) to LTS1 Customer.
Screenshot for Step
3 . Double-click LTS1 Customer to open the Logical Table Source dialog box.
Screenshot for Step
4 . Click the Column Mapping tab and notice that all logical columns map to physical columns in the same physical table: D3 Customer. It may be necessary to scroll to the right to see the Physical Table column. Make sure "Show mapped columns" is selected.
Screenshot for Step
5 . Click OK to close the Logical Table Source dialog box.
6 . In the Physical layer, expand orcl > BISAMPLE.
Screenshot for Step
7 . Drag D4 Address from the Physical layer to the D3 Customer logical table in the BMM layer. Notice this creates a new logical table source named D4 Address for the D3 Customer logical table. It also creates new logical columns that map to the D4 Address physical table.
Screenshot for Step
8 . In the BMM layer, double-click the new D4 Address logical table source to open the Logical Table Source dialog box.
Screenshot for Step
9 . On the General tab, enter LTS2 Customer Address in the Name field.
Screenshot for Step
10 . Click the Column Mapping tab and notice that all logical columns map to physical columns in the same physical table: D4 Address. If necessary, select Show mapped columns and deselect Show unmapped columns.
Screenshot for Step
11 . Click OK to close the Logical Table Source dialog box.
Screenshot for Step
12 . Confirm that the D3 Customer logical table now has two logical table sources: LTS1 Customer and LTS2 Customer Address. A single logical table now maps to two physical sources.
Screenshot for Step
13 . Right-click the new ADDRESS_KEY column and select Delete. This is a duplicate column and is not needed.
Screenshot for Step
14 . Click Yes to confirm the delete.
Screenshot for Step
15 . Use the Rename Wizard or a manual renaming technique to rename the new address logical columns (with uppercase letters) in D3 Customer. Your results should look similar to the screenshot. Hint: To use the Rename Wizard, select all of the new logical columns, then right-click any one of the highlighted columns and select Rename Wizard to launch the wizard. If you need help using the Rename Wizard, refer to these steps from earlier in this tutorial.
Screenshot for Step
16 . Rename the remaining logical table sources according to the following table. Recall that logical table sources are located in the Sources folder for a logical table. For example: D2 Product > Sources.
Logical Table Source
Rename
D2 Product LTS1 Product
F1 Revenue LTS1 Revenue
Your results should look similar to the screenshot.
Screenshot for Step

No comments:

Post a Comment

Popular Posts