How to use DrillFilters()

building reports webintelligence
1

Hi all,

I have built a report that uses Drill mode to show data at Organisational Structure level. eg Directorate, Branch, Cost Centre, Section.

What I would like to do is that when the user has drilled down to Section, I would like another table displayed with different data. This table should be hidden if the Org structure is higher than Section level.

Is this even possible?, Is it the DrillFilter() function that we use for this?

I know that I can do this using Hyperlink, but at this stage, I don’t want to go down that path.

Any suggestions would be greatly appreciated.

Thanks,

plessiusa :netherlands: (BOB member since 2004-03-22)

2

I have not understood your requirement , but why we use drillfilters() is :

DrillFilters() returns “US” if the document has a drill filter restricting the [Country] object to US

DrillFilters() returns “US - 1999” if the document has a filter restricting [Country] to “US” and [Year] to 1999

DrillFilters("/") returns “US / 1999” if the document has a filter restricting [Country] to “US” and [Year] to 1999

DrillFilters ([Quarter]) returns “Q3” if the document has a drill filter restricting [Quarter] to “Q3”

or you can go through the link :

http://servername/businessobjects/enterprise115/desktoplaunch/help/en/webintelligence/java/webintelligence.htm

aniketp :uk: (BOB member since 2007-10-05)

3

Yes you have missed my point and copying the text out of the manual is not going to help me, I’ve already read that and it didn’t help me that is why I posted on BOB.

What I am trying to do is to understand exactly how a drill filter works.

My requirement has changed slightly from since asking the question originally.

I now have two tables on my report page, one summary, one detail.

In the detail table, there is a column that I would like to be empty up until the report has been drilled to a particular point (in my case Org Structure Section). Once I have drilled down to that point I would then like my empty column to be populated with a dimension.

Any ideas?

plessiusa :netherlands: (BOB member since 2004-03-22)