Oracle Analytics Cloud and Server

Home› Oracle Analytics› Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Passing OBIEE Value to BIP Report

Received Response
122
Views
2
Comments
User_IP06I
User_IP06I ✭✭✭
edited August 13 in Oracle Analytics Cloud and Server

Hello Experts,

I have a requirement to Pass a value in OBIEE dashboard as a filter to BIP report.

For example, I have California, New York and Colorado as values under State column in a OBIEE dashboard. When I click on California it should open a BIP report (Sales) and filter that report for California sales. Please let me know how I can do this?


Thanks in Advance.

Tagged:

Answers

  • Joel
    Joel ✭✭✭✭✭

    Hi @OracleUser_IP06I

    It’s quite simple really. You need to have a dashboard prompt for the State attribute in your case and this should have a presentation variable associated to it. This presentation variable should have the exact same name as the BI Publisher report parameter for the State attribute.

    Take a look at this for further information. https://blogs.oracle.com/xmlpublisher/running-bip-reports-in-biee-with-prompts

  • sgeorge_otn
    sgeorge_otn ✭

    Hi,

    You can use OBIEE Action link functionality to navigate to a web page. It lets you define parameters and you can provide the BI publisher URL as the address to the web page. Please go through the documentation on how to create the BI publisher report URL with parameter.