how to reset data dynamically in dashboard prompts without clicking on reset button in obiee 12c?

DollyG

Hi Gianni,

Agreed.  But, I cannot use "Limit values by" option, as I have to apply certain other conditions in Prompts, which is only possible using "SQL Results".

Is it possible to use these other conditions elsewhere or somewhere in rpd, so that I could use "Limit By" option in prompt and problem could be solved?

SQL result query:

SELECT "delivery health report"."Master Mappings"."Product Name" s_1 FROM "delivery health report" WHERE (("Master Mappings"."Reporting" ='Yes') AND ("Master Mappings"."Lob" IN (@{pv_lob}['@']{'na'}) or '@{pv_lob}' = '') AND (("Master Mappings"."Effective Date" IN (SELECT max("Master Mappings"."Effective Date") FROM "delivery health report" FETCH FIRST 65001 ROWS ONLY)))) FETCH FIRST 65001 ROWS ONLY