Selective Drill

[dbomrrsm]

In Webi 6.5 when a user drills outside the original context of the report a new query is sent to the database. In Webi this creates the sql with a where clause of the last item drilled so if a user selects department A to drill on the sql has a where clause of where department = 'department a'.

I would have expected the full client reporting tool to do something similar but this seems to produce sql that has no where clauses other than those that were in the original query.

Can full client be configured to only retrieve data for the last item drill on ?

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[dbomrrsm]

OK sussed it !

Tools > Options > Drill Tab - tick Apply Drill Filters.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]