Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

List of physical joins in the RPD

Received Response
161
Views
4
Comments

Content:

Is there a way we can get the list of all physical joins defined in the OAC RPD? Repository documentation tool is giving lineage from physical layer till presentation layer. But join conditions are missing. Any way of getting entire list of physical joins?

Version (include the version you are using, if applicable):

OAC BI Administrator tool

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    Hi Sahithi,

    From the Joins manager, you can view all the physical joins - like below. However, if you are looking to export and document, not sure if that's feasible.



  • Sahithi Kolasani-Oracle
    Sahithi Kolasani-Oracle Rank 5 - Community Champion

    Hi Amrita,

    Yeah, looking for the export of these joins into a csv or xls file. As of now, when we copy and paste, it comes like below which is not the format we are looking for.

    -DECLARE FOREIGN KEY "Data Warehouse".."ADW"."Fact_W_SITE_PROTCL_DEVTNS_F"."Fact_W_RXI_SITE_PROTCL_DEVTNS_F_Foreign Key#7" AS "Fact_W_SITE_PROTCL_DEVTNS_F_Foreign Key#7" HAVING

    (  "Data Warehouse".."ADW"."Fact_W_SITE_PROTCL_DEVTNS_F"."COMPANY_TGT_WID" ) REFERENCES "Data Warehouse".."ADW"."Dim_W_COMPANY_TGT_D"."Dim_W_COMPANY_TGT_D_Key"

    PRIVILEGES ( READ);

  • Subhakara Netala-Oracle
    Subhakara Netala-Oracle Rank 6 - Analytics Lead

    Hi Sahithi,

    From Repository query, select Type as Physical Foreign and click on query. You can see all joins also from column we can select required columns from the list. Finally it can be saved into CSV file. Check will this suffice your requirement.


  • Sahithi Kolasani-Oracle
    Sahithi Kolasani-Oracle Rank 5 - Community Champion

    Thank you Subhakara. It worked like a charm!