Forum Discussion
Multi-Dimensional Planning Cube: "Pivot error: Hierarchy error: Input row hierarchy has no root node
Hi folks,
I’m seeking for help to create a Multi-Dimensional Planning Cube. This is my setup:
- Adventure Works sample data storge in a Direct Lake Semantic Model
- Rows: 2 Dimensions from the Customer table
- Columns: Year, Quarter, Month column from the Calendar table
- Valus >measure „Gross Profit“
Please, take a look at my submitted screenshots to get a better idea of my setup.
Anyway, I follow the instructions provided on https://learn.microsoft.com/en-us/fabric/iq/plan/planning-how-to-create-cube .
Thus, I click:
- Insert Column > Number >Insert a new empty series
- Submit the title „Plan 2027“
- Inserted as „Visual Measure“
- Add a breakdown >make sure all dimensions are added >in this case market_en_name as well as product_en
- Click Create
In every case I tried I also get the error "Pivot error: Hierarchy error: Input row hierarchy has no root node".
Even though the message seems clear I don’t understand what I need to do with the row hierarchy.
I tested:
- several dimensions
- a mix of dimensions
- Added [Driver Measure] !== BLANK in the Formular field >[Gross Profit] !== BLANK
However, I always hit the same error.
What’s wrong here? Can you help me?
Thank you in advanced.
Cheers,
Dom
Added fields
my breakdownMy Planning TableMy new column
1 Reply
- Nabha-Ahmed
Super User
Hi DomPower
The error “Hierarchy has no root node” usually happens when the row hierarchy is not fully connected or contains gaps (missing parent level / broken hierarchy path).
Try this:
Ensure all hierarchy levels have valid relationships (no nulls between levels),Start with a single simple hierarchy ,,,Verify Calendar hierarchy is strictly continuous (Year → Quarter → Month),,,Remove any empty members in dimension. And Rebuild the cube after simplifying breakdowns
If it still fails, it’s a current Fabric IQ limitation with complex multi-dimension breakdowns in Direct Lake, and you may need to reduce hierarchy complexity or split the mode.
hope this help you !
best regards!
Nabha Ahmed