Query does not change dynamically on Drilling

building reports webintelligence
1

Hi,

We want that during drill, the query is generated on runtime. But we can see that all levels of the hierarchy are selected already when the first time the report is run. After drilling on a particular Value the query does not change to show the filter in the where clause of the query.

Note- We have checked the option “Use Query Drill” in WebI.

We require that the query gets regenerated everytime drill is done to improve performance and to restrict the amount of data fetched based on the drill filter applied.

Thanks,
Pooja

Pooja.29.84 (BOB member since 2010-04-28)