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

BIP report is not listening to this filter

Received Response
51
Views
2
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:16PM in Oracle Analytics Forum

Hello Experts,

I created one prompted filter "product name" at my analysis report:

pastedImage_0.png

pastedImage_1.png

I then used this analysis report as model at BIP where I created PRODNAME LOVs and prompt:

pastedImage_3.png

but my BIP report is not listening to this filter.

I guess I can not provide prompt in case of Analysis report based model?

version :Version: OBIEE 12.2.1.4

Thanks,

Answers

  • Saresh-Oracle
    Saresh-Oracle Rank 5 - Community Champion

    Hi Sangeeta,

    Please refer :https://docs.oracle.com/middleware/12212/biee/BIEUG/GUID-1AE2825E-E5F1-461F-B5D8-EC4B74649015.htm#BIEUG1170

    It says,

    • If you are saving a dashboard prompt for use with an Oracle BI Publisher report that receives its data from a SQL query against the Oracle BI Server, Oracle Database, or other JDBC source, then the dashboard prompt's name must match the name of the report's parameter.

    Thanks,

    Sareesh

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics & AI Lead

    Hi Saresh,

    Thanks for your help !!!

    In my case, it is not a dashboard prompt.

    What I did:

    1) I created a table prompt in my Analysis report

    2) I created a BIP data model using this BIP report

    3)I created LOV and parameter in this BIP Model(Parameter name at BIP model  is same as table prompt name at Analysis report).

    4) If I select a values for this parameter at BIP model, data in model is not chaning as per value chosen in parameter.

    Thanks,