Reporting and Analytics for Sales

Get Involved. Join the Conversation.

Topic

    Yannik Pietschmann
    SQL statements for Datastores
    Topic posted May 24, 2019 by Yannik Pietschmann, tagged BI Publisher, Opportunity, Reporting and Analytics 
    62 Views, 1 Comment
    Title:
    SQL statements for Datastores
    Summary:
    What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?
    Content:

    Hello,

    we are looking for the concrete SQL statements, which are used for getting the data of an datastore. Especially we need to know how multiple database tables are joined (inner/outer joins?).

    For example the datastore Opportunity (CrmAnalyticsAM.OpportunityAM.Opportunity) uses multiple tables like MOO_OPTY, MOO_REVN, HZ_PARTIES, ... This information can be found in the mapping spreadsheet R13.19A CX OTBI Subject Area Database Mapping.xlsx, which was posted by Ling Xiang (https://cloudcustomerconnect.oracle.com/posts/38c32f731c). What are the concrete SQL statements for getting the data from these tables for the datastore?

    Is there any documentation which provides this kind of information for datastores?

     

    Thanks,

    Yannik

    Comment