It appears that you want to build a hierarchy using a parent-child relationship across rows. For example, company org charts (manager -> employee) or bill of materials product hierarchies.

This is NOT how analytic view hierarchies work!

These are defined across columns within a row. The classic example is date components, e.g.

Day -> week -> month -> year (e.g. Day 10 -> Week 24 -> June -> 2025)

Which could be based on a table like

create table dates ( day int, week int, month varchar2(10), year int )

So to use analytic views, you need to pivot the data into a table with a column for each level in the hierarchy.

Post more details about your use case and provide examples (create table, insert into), and we'll do our best to help.