Open Rpd in online mode.
Go to physical layer and right click EMP physical table and
select create alias.
Create a primary key as EMP NO for EMP Mgr.
Create a join in between Fact (EMP) to EMP Mgr in physical
layer as follows.
"orcl".""."SCOTT"."EMP
Mgr"."EMPNO" =
"orcl".""."SCOTT"."EMP"."MGR"
Drag to BMM layer rename as "Manager Name" and
give the join condition , Drag to presentation layer ,Save and check consistency.
No comments:
Post a Comment