This discussion is archived
2 Replies Latest reply: Dec 4, 2012 11:47 AM by Ahsan Shah RSS

Join Issue...

962252 Newbie
Currently Being Moderated
Hi,

I am new To OBIA.We Are using OBIA 7.9.6.3 rpd.how to find out join between tables.

we have to join W_INT_ORG_D AND W_ACTIVTY_F AND w_SRVREQ_F let me know what the join condition between to tables.i created based on ROW_WID it is not working.

I want develop report like this

Country_name ORG_NAME Activity SRs
  • 1. Re: Join Issue...
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Follow as:

    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
  • 2. Re: Join Issue...
    Ahsan Shah Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points