Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    ALVIN LEUNG
    How to pass field value(s) from Page to OTBI...
    Topic posted December 13, 2017 by ALVIN LEUNG, tagged BI Publisher, Fusion Procurement reporting, Fusion Supply Chain Management reporting, OTBI, Reports, Tip 
    109 Views, 1 Comment
    Title:
    How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?
    Summary:
    An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?
    Content:

    An iFrame is created in an existing Page layout in order to accommodate a OTBI report (see attached screenshor).  User will enter  the search criteria in a  Page and I need to generate a OTBI report basing on the value entered.   I would like to know how to pass field value(s)  from  a Page layout to OTBI and execute the report   without asking the user to re-enter the search criteria again. Pls note that this iFrame  is an add-on to a existing Page layout which I don't want to interrupt the existing process. 

    Thanks and have a nice day. 

     

    regards

    alvin leung 

      

    Image:

    Comment

     

    • Alexey Shtrakhov

      Hi Alvin,

      would like to know this as well.
      On BIP report I know how to do this. https://cloudcustomerconnect.oracle.com/posts/023dbae005 .Maybe this can help you.
      Binding Variable you have to use, but not exactly sure how you can pass it to OTBI report.. Some Variable based filter you should create I guess or some Variable based Prompt...

      T Alexey