BIP report is not listening to this filter

Question

Hello Experts,

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

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

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,

Sangeeta Pandey · Answer

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,

Saresh-Oracle · Answer

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