Also you can check if this option works

You can try this ...Have two presentation variable pv_1 and pv_2..then use SQL result as prompt value ....and try something like this .... in 1st prompt value SELECT first_source FROM 1st_table WHERE first_source in (select 2nd_Source from 2nd_table where @{pv_2}{dummy} or 'dummy'=@{pv_2}{dummy}) 2nd Prompt Value : SELECT…

Try this .. '@{PV_Supply}{SometingElse}'='SometingElse' or "Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse}'='Yes'

Check the version difference of the odd one with other databases. It probably generating different explain plan. Capture the explain plan in both databases. That will give you and insight. Thanks Arijit

You can set default value to 'Something Else' or can change it like ... "Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse }'='Yes' You can also update default value of the dashboard prompt

You can convert Filter to SQL and try something like this ... @{PV_Supply} ='Yes' and supply date < ship date or @{PV_Supply} ='No' and supply date > ship date

I was not able to use repository variable or presentation variable in the column interaction section to describe an URL. But able to use it little different way achieving the same result. I have a session variable called USER_CC, I have assigned value http://google.com to it. Now in column properties I have declared it as…

OBIEE BI Server's Web Service can be used to invoke cache purge procedures from any machine . You need to do some configuration on the OBIEE server side though. It also can be purged with database direct SQL. The solution depends on how much access you have and how you want to achieve it. Thanks Arijit

Just to add with what Christian said, You can have a pivot table in a dashboard with Dashboard prompt that will do what you are looking for. Thanks Arijit

This blog should help you to get your top 3 + other combined report ready. https://www.rittmanmead.com/blog/2010/09/oracle-bi-ee-11g-filters-selection-steps-top-n-products-case-study/

What is not working, Can you please little more specific? I can see with hide and without hide it worked same way.

There are few blogs on Linux random number entropy issue. We had suffered that. Check if you are hitting it. How to Diagnose a Linux Entropy Issue on WebLogic Server Instances (Doc ID 1574979.1) Thanks Arijit

Not exactly like this but I have seen similar issue with 12c where the same report works in 11.1.1.7. I did work around by hiding the column in column properties. 

Thanks efocal, tried everything you listed (as well Oracle recommendation for this bug). These workarounds are not fixing the issue. Arijit

You can use custom mesg for no data...

IE version 11.0.96000 OBIEE 12.2.1.2.0 Thanks Arijit

Yes, you declare presentation variable in dashboard prompt. Then you can use it in your report like this ...

The object needs to be same in Report A and B in order to "Is Prompted" work properly. You can add an unprotected filter on the column and check if the value changes in report B. As unprotected filter and is prompted works same way. You can also use presentation variable to force Report B to use value from the report A.…

No it did not. We have RHEL 6.8. Oracle had prereq for 6.6 and prereq for RHEL 7. We followed 6.6 package requirements. It does not include numactl. Though requirement for RHEL 7 does have numactl in it. Thanks Arijit

Resolved it by installing numactl in RHEL.