Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Embedded Reporting/BI Publisher
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
-
Is the offer data there in your XML?
0 -
Hi Rachel,
Thanks for your help.
No the offer data is not in the xml. The recruiting data is though.
Alice
0 -
Hi Rachel,
Thanks for your help.
No the offer data is not in the xml. The recruiting data is though.
Alice
0 -
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
0 -
I wound up rebuilding the data definition and the report works!
Thanks for everyone's help.
0