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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Que

    edited May 5, 2017 10:52AM in Reporting and Analytics for HCM 15 comments

    Summary

    Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)

    Content

    Hi Experts,

    Wondering whether it is possible to create a Data Model in Oracle HCM Cloud using multiple data-sets such that:

    Data Set 1 : Based on SQL Query present in HCM Application (say contains fields country, legal employer)

    Data Set 2: Based on Static Data (Excel Spreadheet and contains fields like country, empnumber, firstname and lastname)

    Would like to know whether we can create a report which would hold legal employer,empnumber,firstname and lastname for all records which are having same country value in Data Set 1 and Data Set 2

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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