I need to determine the hierarchy level in Drill mode when the user remove the filters without drilling up.
The information given by the DrillFilters() function helps to determine which drill filter is used and how deep the user have drilled. I determine the hierarchy level with this function as the user drill down or up in order to dynamically re-sort the rows based on a hidden column (supplementary order sequence objects).
But when the user drill down to the level he needs and then remove the drill filter or select All value in every drill filters, the DrillFilters() function becomes useless.
Is there a way to determine the hierarchy level displayed without the DrillFilters() ? I have tried many combinaison of other functions without success.
Have you tried performing a test on a drillfilters(n) value to check for presence? Based on that knowledge you should be able to create an if-then-logic flag as a local variable and thus be able to determine what level the user has executed. You said that drillfilters() was useless at a point, so how do you know that? In the past I’ve had trouble testing on a drillfilters() equation using equals space (="") or isnull, so what I’ve wound up doing is something like this in lieu of:
Hi John, thanks for your reply, somebody who takes time to help is always appriciated.
You asked
In fact I wrote in my first post:
By removing the drill filters (not drilling up) the user is allowed to keep the level in the hierarchy and compare all items at that level… But the DrillFilters() then become empty and does not give me any clue what level the hierarchy is display in the report.
I’m trying to determine the level of the hierarchy even when the user remove all drillfilters().
Thank you for your patience, I re-read your item and now understand the issue.
Reference
.
The WebI is quite powerful, that is why sometimes providing InfoView access only gives us complete control over the reporting process. If you have users who insist on using WebI and then destroy your good work by choosing items in the drill filters, then zap the variables out of the drill filter, and then get “suspended” in animation, and WebI doesn’t provide a “Danger, Will Robinson” voice, then there is bound to be trouble, as you are describing. A way to circumvent this activity is to put items in the output as a Section. Of course, User Joe can wipe out your Sections also, but if you get a hold of someone’s report and start dropping sections back in and above stuff and realize that only certain data values are appearing in the sections (quick look at the Map), it will confirm that your user has performed the death defying “suspend” and it will give you the ammo back you are seeking. DrillFilters() is merely a view and tell capability, not a “Danger, Will Robinson” voice, unfortunately.
Hi John, thanks for the reply, I had so much fun reading it, remembering Lost in space… In fact I have a kind of Mr Schmidt in the test group. He usualy get us all on our teeth in meetings, looking at little tiny details with a big magnafying glass while the obvious can get in is face without him noticing it!
I also have same issue if either of you ever figured anything out. I am trying to use a hyperlink at the same time as drilling and so need the same thing. if the user drills, sets the drill filters all to All Values, how on earth do I know which object in the hierarchy I am now looking at? it is the only part that doesn’t work. seems odd I can’t figure out what object is in a certain column in a dynamic fashion.
There was simply no solutions to this problem then. I did not investigate this problem with the new versions of WebI since I’m no longer with the client!
(BOB member since 2007-07-11)
(BOB member since 2006-09-12)
(BOB member since 2007-07-11)
(BOB member since 2006-09-12)
(BOB member since 2008-06-02)