Skip to Content
0
Former Member
Mar 12, 2009 at 05:20 PM

Disable drill on null value

46 Views

Hi everyone,

this is my first so I'll try to respect all the rules of the community, but if not please tell me.

I'm building a report and I've a problem drilling a dimension: my dimension is based on a unbalanced hierarchy, the following should be an example:

Lev1 Lev2 Lev3

A B C

A B D

A E NULL

My problem is that, when I drill on the first level (A), I can see the values B and E, then if I drill on B I can see the correct value of C and D, while drilling E I have a single column with no header and with the same values of E. Do you think is it possible to avoid drilling on a NULL value?

Another problem is that when I reach the NULL level, in the header I have no up arrow to come back to the prevoius level. Can you help me?

Thank you very much