Embedded Reporting/BI Publisher

Question

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

Alice Kim, SPHR-SCP · Answer

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

Thanks for everyone's help.

RichardChan · Answer

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 · Answer

Hi Rachel,

Thanks for your help.

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

Alice