Disable level based hierarchy for null values

user12863665

Hi, my dimension table is not balanced. Some of the rows has 7 levels and some has only 3 levels.

when I create level based hierarchy, hierarchy is drilling to lowest level even though there are null values some some of the rows.

anyone suggest me how can I avoid drilling to lowest level even though that row has only 3 levels.

Joel

Have you set your logical dimension up as unbalanced/ragged?

https://docs.oracle.com/middleware/bi12214/biee/BIEMG/GUID-DB4D9819-BF7D-4750-9C71-DDFA2ACE1CDB.htm#GUID-EDB3A514-3100-4…