How to Create Band as a Filter

HELP Me HELP Me HELP Me !!!

I want to create the drill filter onto summary report based on the Bands.
I was able to create the drill filter, but as im selecting any of the value which is there in Drill Filter; Im not able to see any report output.

Please find attached detailed steps which im following while creating drill filter

Please help
Band Filter.doc (93.0 KB)


ananddl (BOB member since 2009-01-31)

It’s probably the format of the object and how it’s dealing with percentages, where 0.5 is representative of 50%.


dessa :madagascar: (BOB member since 2004-01-29)

I double checked the formatting of object, when im adding the object into the calculational table, im getting all the Bands specified as per the conditions. When im dragging the same object into drill area its showing the same range values but not doing filtering if i select any one of the values within Band object. :hb: :hb:

Please help me with solution.


ananddl (BOB member since 2009-01-31)

Maybe I wasn’t clear enough. The figures displayed to you may be formatted as you expect and you see nn.nn% but the data returned in the cube isn’t of this format though.
It may be something entirley different, but it’s where I would start looking.


dessa :madagascar: (BOB member since 2004-01-29)