You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL statements for Datastores

edited May 24, 2019 11:47AM in Reporting & Analytics for Sales 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!