Purchasing

Get Involved. Join the Conversation.

Topic

    Shubham Chandra
    Multiple subject area Issue in Cloud BI report
    Topic posted August 17, 2017 by Shubham ChandraGreen Ribbon: 100+ Points 
    61 Views, 5 Comments
    Title:
    Multiple subject area Issue in Cloud BI report
    Summary:
    Unable to get the measure values of 2nd subject area
    Content:

    Hi All,

    I am working on Procurement subject areas in cloud BI version is 11.1.1.9
     
    Report Requirement: Report should display total amount spent on different categories with or without Blanket Purchase Agreement
     
    This is required to built with two subject areas 
     
    1. Procurement - Purchasing Real Time
    2. Procurement - Purchasing Agreements Real Time
     

    I pulled in Category name, Purchase order number, Item description, Source Agreement, Purchase Order Distribution Amount (Received Amount) from 1st Subject Area.

    I Pulled Agreement number, Agreed Amount and Released Amount measures from 2nd subject area.

    The report is not displaying the 2nd subject area measures properly.

    How to solve this problem?
     
    Regards,
    Shubham Chandra

    Comment

     

    • Ivan Pena

       

      Hi Shubham,,

      Currently BI does not support cross functional report at document level. (PO number, Line attributes are not shared across different subject areas. ) So customer can't expect they pull Agreement Number from Agreement SA to associate with the PO records from PO subject area. Those are totally separate entities.  Cross functional reports only work for the shared common dimensions such as Item, BU, Supplier. For example: if user create cross functional reports like Supplier, PO amount, Agreement Amount, this will work. However, if the report is drilling down to document level, such as Supplier, PO number, PO amount, Agreement Amount, (PO Number, Agreement Number are document level attributes), the report will not work as expected since PO number from PO subject area does not join to agreement Subject area to get the associated agreement amount.

      For the below report, we can only suggest customer to build a report like:

      Supplier, Item, Category, PO Amount, Agreement Amount, Release Amount.

      Then from PO amount, create another report to drill down for the individual PO record, and from Agreement Amount drill down to another report for the individual agreement record. It's not ideal solution. However, current BI model can do very limited cross functional report. We don't recommend users to create cross functional reports except at common dimension level

       

      Thanks

      Ivan

    • Shubham Chandra

      Hi Ivan,

      I am unable to form the criteria and unable to get the result. Please find attached PO and BPA report.doc (Word Doc) for criteria and other details described in it.

      Regards,

      Shubham

    • Shubham Chandra

      Hi Ivan,

      I am unable to attach word doc in my earlier reply. I am attaching here with image format with same content. PFA.

      Regards,

      Shubham.

    • Ivan Pena

      Hi Shubham,

      Please open a service request so product support/development can more effectively help.

      Ivan

    • MShrini

      Hi Shubham,

      Please make ensure whether at least one fact column is selected or not when the report is developing across two subject areas. If fact column is not used then please try after considered the fact column.  It is recommended by Oracle for cross subject areas.

      Thanks,

      MSrinivasu.