Clearing filters added by drilldown
jsolanFeb 9 2010 — edited Feb 12 2010I'm trying to find a way to clear the filters that are automatically added by drilldown links.
We have a dimension defined in the rpd file and we have prompts on a dashboard that overlap with some of the drill columns.
For example:
Location Dim would be defined as
State->County->City
We would have a dashboard prompt for State.
The report on the dashboard would be something like:
State | Revenue Dollars
We're using the "Drill In Place" method of drilldown. As users click on a State, a filter is automatically applied to the report and the County column is added as expected. However if the user now goes up to the prompt and selects a different State, the filter gets applied as an "And" causing it to return no data.
Users sometimes would like to be able to keep the drill depth at its current location, but use the dashboard prompts to re-filter the data.
Is this possible?