Embedded Reporting/BI Publisher

Alice Kim, SPHR-SCP

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

Rachel Martorelli-Oracle

Is the offer data there in your XML?

Alice Kim, SPHR-SCP

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

Hi Rachel,

Thanks for your help.

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

 

Alice

RichardChan

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

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

Thanks for everyone's help.