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
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.
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.