Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

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

Received Response
22
Views
11
Comments
2»

Answers

  • DollyG
    DollyG Rank 5 - Community Champion

    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