2 Replies Latest reply on Dec 4, 2012 7:47 PM by Ahsan Shah

    Join Issue...


      I am new To OBIA.We Are using OBIA 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...
          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
            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
            1 person found this helpful