1 Reply Latest reply on Oct 16, 2019 4:29 AM by Joel Acha

    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.