Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Austin Cox
    BIP Expense Report Approver
    Topic posted August 14, 2019 by Austin CoxGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, OBIEE Answers, OTBI, Reports 
    36 Views
    Title:
    BIP Expense Report Approver
    Summary:
    Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI Publisher
    Content:

    The goal of this report is to utilize bursting to send out a summary of expense reports related to various managers throughout the organization.

    Example: A manager gets a weekly report showing all expenses of employees who reports to him/her.

    One area where I am stuck is pulling in the approver of the expense report. I have attached the SQL that I currently have.

    Any suggestions would be greatly appreciated!

    Document: