I have created a dashboard with a single page containing two sections. In first section i am having a prompted report for region and a Region Dashboard prompt ,
in second section i am having two prompted reports for region , i mean region dashboard prompt drives all other reports in that page. When ever I select a region from the dashboard prompt i am seeing message on Dashboard page as **"_Undo drills and view prompt values_"**
If any one having the solution let me know in detail,How to overcome this.......
This issue is caused by having saved prompt value in the analysis.
Check if there is a staticMemberGroup tag present in your analysis XML (edit the analysis and go to Advanced tab to see the XML). Within the staticMemberGroup element will be your saved value.
How to fix this:
Remove the column from the prompt section of the analysis. You can move it to excluded columns or remove it from the report completely. Purpose of this is to get the analysis refreshed so we get new XML without the saved value.
After the analysis is refreshed you can put the column back to the prompts section and save.
Check the XML again and make sure that staticMemberGroup element is not present.
The important thing here is not to choose any value in your prompt while you are in edit mode before you save the analysis. This is how a static value gets saved in the XML.