Managing Logical Table Sources in OBIEE

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

Managing Logical Table Sources 

In this set of steps, you create multiple logical table sources for the D3 Customer logical table. To create multiple logical table sources you perform the following steps: • Open the Repository in Offline Mode • Add a New Logical Table Source • Create Presentation Layer Objects • Load the Repository • Create and Run an Analysis • Check the Query Log

Open the Repository in Offline Mode:

1 . Return to the Administration Tool, which should still be open. If not, select Start --> Programs  --> Oracle Business Intelligence --> BI Administration.

2 . Open the BISAMPLE repository in offline mode with a repository password is BISAMPLE1. Recall that earlier in this tutorial you created a copy of the online repository and saved it as BISAMPLE.rpd.

3 . Select Manage > Identity to open Identity Manager.

1

These core tutorials will help you to learn the fundamentals of OBIEE 11g.  For an in-depth understanding and practical experience, explore "OBIEE 11g Training".

4 . Select the BI Repository in the left pane.

1

5 . Recall that earlier in this tutorial you created a copy of the online repository with logging level defined for the administrative user. Confirm that your administrative user is visible in the right pane. In this example the administrative user is weblogic.

1

6 . Double-click the administrative user to open the User dialog box. On the User tab, confirm that logging level is set to 2.

1

7 . Click Cancel to close the User dialog box. 8. Select Action > Close to close Identity Manager. The offline BISAMPLE repository now has a user with a logging level set to 2. This will allow you to check the query log as you complete the remaining exercises in this tutorial. You will not have to repeat the steps of copying an online repository.

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.

1

2 . Rename the D3 Customer logical table source (not the logical table) to LTS1 Customer.

1

3 . Double-click LTS1 Customer to open the Logical Table Source dialog box.

1

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.

1

5 . Click OK to close the Logical Table Source dialog box.

6. In the Physical layer, expand orcl > BISAMPLE.

1

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.

1

1

9 . On the General tab, enter LTS2 Customer Address in the Name field.

1

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.

1

11 . Click OK to close the Logical Table Source dialog box.

1

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.

1

13 . Right-click the new ADDRESS_KEY column and select Delete. This is a duplicate column and is not needed.

1

14 . Click Yes to confirm the delete.

1

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.

1

Logical Table Source Rename
D2 Product LTS1 Product
F1 Revenue LTS1 Revenue

Your results should look similar to the screenshot.

1

For an in-depth understanding of OBIEE click on

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.