General OBIEE

Get Involved. Join the Conversation.


    Alice Kim, SPHR-SCP
    Embedded Reporting/BI PublisherAnswered
    Topic posted July 7, 2017 by Alice Kim, SPHR-SCPBronze Crown: 15,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers, Online Layout Editor, Report Delivery, Report Layouts, Report Output, Reports, SQL 
    153 Views, 5 Comments
    Embedded Reporting/BI Publisher
    audit report using offer fields


    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.


    Alice Kim

    Best Comment

    Alice Kim, SPHR-SCP

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

    Thanks for everyone's help.