Extra columns in drill down report

building reports webintelligence
1

Hi Friends,

I have an issue with drill down report, searched thru the forum, got some help but looking for some more help.

My requirement is to generate a drill down report.say suppose I have columns A,B,C to be displayed on the main report and on drill down from A to D, the drilled report should contain A,D,B,C,E(Bydefault only D,B,C will be shown) .

In short in the drilled report I need the object A( which I drilled from), D (newly drilled object),E(some other object linked to D,at the same level in DB), B,C (from main report) on the drilled report…

A,B,C --> A,D,E,B,C

Is this possible ??

yellos (BOB member since 2009-09-17)

2

You can use the function “DrillFilters()” to show the drilled columns

dgpotter :uk: (BOB member since 2010-01-04)

3

Hello dgpotter,

Cold you please elaborate oh this ?

Is it possible to add some extra columns to the drilled report using drillfilter() ??

yellos (BOB member since 2009-09-17)

4

Maybe you could look at open document, as an alternative to a standard drill?

Mak 1 :uk: (BOB member since 2005-01-06)

5

Thanks Mak,

But with Opendocument we can go to another report but not flexible as drill down report for analysis??
Can you just guide me…

yellos (BOB member since 2009-09-17)

6

In what way :? ?

I think it is the only way that you will get the extra columns that you require.
If analysis is also required, you will know better than me whether open document is a suitable alternative, i.e. they are your requirements :).

Mak 1 :uk: (BOB member since 2005-01-06)

7

This is a question on DRILL mode.

Apparently, when i created this report and ran it in DRILL mode; down to the next level of the hierarchy.BUt now I want to restore it to its original format (which was without the lowest level of the hierarchy). I notice that the lowest level automatically appears in the list of available objects in the Edit REport (although it is not selected in the Edit Query NOR is it in any of the DRILL filters forthe reports).

Please help. I need to get rid of this lowest level (restore report to original).

ashmem (BOB member since 2008-05-21)

8

Well, you should go into the query and remove it from the scope of analysis, maybe?
Have you also tried re-running it?

Mak 1 :uk: (BOB member since 2005-01-06)

9

I’ve actually done something similar with the use of the DrillFilter() function and alerters. I ‘trick’ it by making a column all white with no borders, etc. if the If(DrillFilters()…) variable is one value and then display the colors, borders, etc. if the variable is the other value.

It only works well if you can have columns at the beginning or end of the table.

cfollen (BOB member since 2005-03-31)