Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Disable level based hierarchy for null values

Received Response
1
Views
1
Comments
user12863665
user12863665 Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

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.

Answers