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