mobileNavlogo
headerlogo

Blog

Create Logical Table and Logical Columns & Logical Join in OBIEE

10 October, 2020

Related Blogs

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

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

2

 

 

Desired to gain proficiency on OBIEE Training? Explore the blog post on OBIEE  training to become a pro in "OBIEE Training Online"

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

2

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.

2

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

2

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

2

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.

2

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.

2

9 . Rename the logical columns:

Old Name New Name
POSTN_KEY Position Key
TYPE Sales Rep Type
EMPL_NAME Sales Rep Name
EMPLOYEE_KEY Sales Rep Number
HIRE_DT Hire Date
MGR_ID Manager Number
POSTN_DESC Position
POSTN_LEVEL Position Level
 DISTANCE Closure Distance

2

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

2

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

2

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

2

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

For an in-depth understanding of OBIEE click on

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 .