Oracle Transactional Business Intelligence

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

Embedded Reporting/BI Publisher

Received Response
81
Views
5
Comments

Summary

audit report using offer fields

Content

Hello,

I am trying to build a report for recruiters to use to audit the offers they have created.

The intention is for the recruiter to create and save the offer, then run the report to see if there are any issues with the offer (i.e. bonus amount is 0 but bonus program is quarterly).

I built a data model definition using  the recruiting subject that includes both requisition data (requisition number, requisition title) and offer data (currency, sign on bonus).

When I try to run the report, the requisition data displays, but the offer components do not display. I do not know what the  issue is. Is it because the offer is still in draft?

Thank you in advance for your help.

Regards,

Alice Kim
CDW

Answers

  • Rachel Martorelli-Oracle
    Rachel Martorelli-Oracle Rank 4 - Community Specialist

    Is the offer data there in your XML?

  • Alice Kim, SPHR-SCP
    Alice Kim, SPHR-SCP Rank 2 - Community Beginner

    Hi Rachel,

    Thanks for your help.

    No the offer data is not in the xml. The recruiting data is though.

     

    Alice

  • Alice Kim, SPHR-SCP
    Alice Kim, SPHR-SCP Rank 2 - Community Beginner

    Hi Rachel,

    Thanks for your help.

    No the offer data is not in the xml. The recruiting data is though.

     

    Alice

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    How are you joining these two pieces of information together are they stored in separate facts with conformed dimensions ?

    Can you check the physical query that is being generated through the Administration - Manage Sessions and look at the log 

     

     

  • Alice Kim, SPHR-SCP
    Alice Kim, SPHR-SCP Rank 2 - Community Beginner

    I wound up rebuilding the data definition and the report works!

    Thanks for everyone's help.