Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clearing filters added by drilldown

jsolanFeb 9 2010 — edited Feb 12 2010
I'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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details