• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Create Logical Table and Logical Columns & Logical Join in

1 . In the BMM layer, right-click the Sample Sales business model and select New Object –> Logical Table to open the Logical Table dialog box.


2 . On the General tab, name the logical table D5 Sales Rep.


3 . Click OK to add the logical table to the business model.


Notice that the D5 Sales Rep icon has a # sign. This is because you have not yet defined the logical join relationship. When you define the logical join later in this tutorial the icon will change accordingly.
4 . Drag all six columns from D50 Sales Rep in the Physical layer to D5 Sales Rep in the BMM layer. This action creates logical columns and adds a D50 Sales Rep logical table source to D5 Sales Rep.


5 . Rename the D50 Sales Rep logical table source to LTS1 Sales Rep.


6 . In the Physical layer, expand D52 Sales Rep Position.


7 . Drag POSTN_DESC and POSTN_LEVEL from D52 Sales Rep Position to LTS1 Sales Rep. Note that you are dragging the columns to the logical table source, not the logical table. Dragging to the logical table would create a second logical table source.


8 . Drag DISTANCE from D51 Sales Rep Parent Child to LTS1 Sales Rep. Again, you drag the column to the logical table source, not the logical table.


9 . Rename the logical columns:

Old NameNew Name
POSTN_KEYPosition Key
TYPESales Rep Type
EMPL_NAMESales Rep Name
EMPLOYEE_KEYSales Rep Number
HIRE_DTHire Date
MGR_IDManager Number
POSTN_LEVELPosition Level
 DISTANCEClosure Distance


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.

 Create a Logical Join

1 . In the BMM layer, select D5 Sales Rep and F1 Revenue.


2 . Right-click either highlighted table and select Business Model Diagram –> Selected TablesOnly to open the Business Model Diagram.


3 . Create a logical join between D5 Sales Rep and F1 Revenue with F1 Revenue at the many end of the join.


4 . Close the Business Model Diagram. Notice that the icon has changed for the D5 Sales Rep table.

For indepth understanding of OBIEE click on

Review Date
Reviewed Item
Create Logical Table and Logical Columns & Logical Join in OBIEE
Author Rating

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Create Logical Table and Logical Columns & Logical Join in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.