Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Sathyaseelan Chandran
    Unable to use 2 Subject Areas in the OTBI reportAnswered
    Topic posted July 2, 2019 by Sathyaseelan ChandranRed Ribbon: 250+ Points, tagged Fusion Financial reporting, OTBI 
    181 Views, 7 Comments
    Title:
    Unable to use 2 Subject Areas in the OTBI report
    Summary:
    OTBI error while using Payables Payments - Disbursements Real Time and Payables Invoices - Transactions Real Time
    Content:

    Team,

    We have created an OTBI report using the Payables Payments - Disbursements Real Time subject area for displaying the invoice details, payment details and Invoice distribution details distinguished by the Location and Legal entity.

    But the distribution not splits to give in detail. Instead of that actual invoice amount is printed in all the lines. Hence I have added Payables Invoices - Transactions Real Time to display the invoice distribution Location and Legal entity as separate column.

    After added the columns the report completed in error as "You may be able to evaluate this query if you remove one of the following column references:". I have attached the error details.

    Please help me to resolve the issue. How to join different subject areas to provide the output.

    Thanks,

    Sathyaseelan

    Document:

    Best Comment

    Sathyaseelan Chandran

    Hi All,


    Based on the below Oracle Note I have created an OTBI report by using Payment and Transaction subject area. It worked fine as expcted.

     FA OTBI: Error When Using Distribution Concatenated Segments Column In OTBI Invoice Details Report (Doc ID 2205652.1)

    Comments Are Closed

     

    • Sridhar Tumati

      Hi,

      Please find the attached document. Hope this will meet you demand.

      FA OTBI: Error When Using Distribution Concatenated Segments Column In OTBI Invoice Details Report (Doc ID 2205652.1)

      Regards,

      Sridhar

      • Sathyaseelan Chandran

        Hi Sridhar,

        Thanks for sharing the Note. Based on this oracle note only I created an Analysis but some how the report not produced an correct output. Lot of Duplicate values. Hence created an new report with keeping this Note as reference. And it worked.

        Thanks,

        Sathyaseelan.C

    • Milind Dalvi

      By design two subject areas cannot be joined. You have two options

      1. Develop custom data model to meet your reporting requirement

      2. Raise SR/Idea with oracle for this requirement.

    • Sudhakara Rao Kovuru

      Hi Milind,

      I am wondering like how we can able develop custom data model in OTBI? can you please share the details if you have so that we can also try?

      Thanks,

      -Sudha.

    • Milind Dalvi

      You will not be able to create data model in OTBI, Data model needs to be created in BI publisher. 

      This link will help you on that.

      https://www.youtube.com/watch?v=Z08GtJIGpcQ

       

      Regards

      Milind

    • Sudhakara Rao Kovuru

      Thanks for the clarification, we know from BIP side.

    • Sathyaseelan Chandran

      Hi All,


      Based on the below Oracle Note I have created an OTBI report by using Payment and Transaction subject area. It worked fine as expcted.

       FA OTBI: Error When Using Distribution Concatenated Segments Column In OTBI Invoice Details Report (Doc ID 2205652.1)