This content has been marked as final. Show 2 replies
Select the required table able using CTRL and mouse left click then mouse right click->Physical Diagram->Selected Object(s) Only
Once you get the physical diagram on click on available arrow or mapping you can find the joins.
Also using Admin tool->Manage->Joins you can view or create
Appreciate if you mark as correct/helpful
Edited by: Srini VEERAVALLI on Dec 3, 2012 3:32 PM
Service Request Fact.PR_OWNER_ORG_WID --> ROW_WID of W_INT_ORG_D
Activity Fact. OWNER_ORG_WID --> ROW_WID of W_INT_ORG_D
However, the report you want doesnt make much sense. Why would you want to combine the Activity and SR facts into one report..what business value does this provide?
If helpful, pls mark correct or helpful