Displaying Values of Drill Filters

system · November 18, 2009, 8:14pm

I have 3 drill filters in my report. Year, Month, Day. The result is 2009-Nov-1.

But my requirement is to only show 2009-Nov. Iam not getting the syntax to select only two drill filters instead to 3.

Any inputs please.

Thanks

Abhi

abhi234u (BOB member since 2007-02-12)

system · November 18, 2009, 10:48pm

Can you elaborate how are you passing your drill filters??

Regards,
Shiva

shiva.tomar (BOB member since 2007-10-05)

system · November 19, 2009, 3:57am

If you want to show just 2009-Nov, then you can use Substr() function like this.

=SubStr(DrillFilters(""),1,8)

Or you can just concatenate like this.

=Concatenate(DrillFilters([Year],DrillFilters([Month]))

Else if you want to have just only two drill filter objects, you have to work on your universe to get Year and Month together.

Jansi (BOB member since 2008-05-12)