Column that appears only at a specific drill down level

building reports webintelligence
1

Hi all,

Is it possible to have a table column appears/disappears only at a specific level of a drill down ?

Also, is there a way that the drill link appears, not on the “dimension object” ( For instance Country Id), but on a related “details object” ?

Thanks in advance for your help,

jlinho (BOB member since 2009-05-12)

2

It is not possible.

Drill is meant for Dimension objects only.

Thanks

BOCP (BOB member since 2007-07-02)

3

And for the first question is that possible ?

jlinho (BOB member since 2009-05-12)

4

The work around can be that you can define your COUNTRY name as a Dimension.

Thanks

siddhartha.dubey :india: (BOB member since 2006-09-13)

5

You can achieve this by a combination of DRILLFILTERS() and ALERTERS

interactive :us: (BOB member since 2005-04-28)

6

Is an alerter able to hide a column ?

Or are you using something tricky like that:

jlinho (BOB member since 2009-05-12)

7

Sorry but the trick does not work correctly… :frowning:

In edit mode everything is correct but in HTML values do not appear correctly :frowning:

I am quite dissapointed with business objects (WebI), it seems to have so much limitations :cry:

jlinho (BOB member since 2009-05-12)

8

jlinho,

The link that you sent is a totally different issue. The solution that I had proposed using a combo of DRILLFILTERS and ALERTERS works out. I did try a example and it works for me. So no reason why it should not work for you. I tried on XIR2 with SP3 on WebI.

Use DRILL FILTERS() funtion to capture the value of the object that you want.
Eg: If you have STATE, CITY, COUNTRY and REVENUE objects on your report and you want the COUNTRY COLUMN to disappear when you drill down to the CITY LEVEL, use the DRILLFILTERS() function to capture the value of the CITY object.
Now use this object to setup a alerter. Something like this…
IF LENGTH(DRILLFILTER(CITY))=0 or NULL then change the color of the FONT to WHITE to make it look as if it is DISAPPEARS.
It is more like deceiving the system to ‘hide’ the row even though it is there on the report.

Hope you will be able to re-create this and solve your issue.

interactive :us: (BOB member since 2005-04-28)

9

The link above is an error. I did want to refer to another paper: it is a copy-pase problem. Sorry

Thanks. That is what I did but there is like a refresh issue in HTML mode. Works well when making the column white, but if the “hide” operation is to make the column “a zero length” size then it works when I drill in the editor but not in the viewer…

THanks for your answer

jlinho (BOB member since 2009-05-12)