This content has been marked as final. Show 3 replies
But i tried with a simple scott RPD. It has two tables DEP and EMP. In the criteria section i dragged and dropped 4 columns. DEPNO, DNAME, ENAME AND SALARY. And in the criteria filter section, i added the column "DNAME" and chose the static filter as "ACCOUNTING". when i clicked on the results tab. It displayed the results related to DNAME-ACCOUNTING. After that, I created a dashboard_Prompt in which i chose the column prompt and the column as DNAME and the condition i gave is - equal to. In the Dashboard section, I dragged and dropped both the Dashboard_Prompt and Analysis. In the Dashboard, in Dashboard_Prompt section is chose the value "RESEARCH". Now the default analysis that was displaying the results related DNAME-ACCOUNTING changed and filtered the data related to DNAME-RESEARCH.
By this experiment, I guess giving static value in criteria and changing it in the Dashboard_prompt will work. Is it right?
Yes, it will override the analysis filter values based on dashboard prompt values.
Ex: in your analysis filter u have Column County set as "India" and your dashboard prompt selected value is "Singapore" then the o/p will override by Dashboard prompt value.