OBIEE 11G Create Logical Table and Logical Columns

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.
Screenshot for Step
2 . On the General tab, name the logical table D5 Sales Rep.
Screenshot for Step
3 . Click OK to add the logical table to the business model.
Screenshot for Step
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.
Screenshot for Step
5 . Rename the D50 Sales Rep logical table source to LTS1 Sales Rep.
Screenshot for Step
6 . In the Physical layer, expand D52 Sales Rep Position.
Screenshot for Step
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.
Screenshot for Step
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.
Screenshot for Step
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
Screenshot for Step

No comments:

Post a Comment

Popular Posts