Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Passing OBIEE Value to BIP Report

Received Response
131
Views
2
Comments
User_IP06I
User_IP06I Rank 4 - Community Specialist
edited Aug 13, 2024 5:16PM in Oracle Analytics Forum

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 Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    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

  • Sherry J George
    Sherry J George Rank 4 - Community Specialist

    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.