Forum Discussion

DomPower's avatar
DomPower
New Member
4 months ago

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

Need Help

2 Replies

  • Nabha-Ahmed's avatar
    Nabha-Ahmed
    Icon for Super User rankSuper User
    4 months ago

    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

  • jubinsoni's avatar
    jubinsoni
    Icon for Continued Contributor rankContinued Contributor
    11 days ago

    Hi DomPower,

    The docs do not mention this exact error, so take this as a likely cause rather than a confirmed one. The row hierarchy comes from the row dimensions on your planning sheet, and the cube breakdown has to include those same row dimensions. Per the cube guide, the sheet's row dimensions are added to the first breakdown automatically and any extra dimensions are added on top of them. Your post lists market_en_name and product_en as breakdown dimensions while the sheet rows are market_name_en and branch_name_en, so it is worth checking that the names line up.

    I would delete the breakdown and recreate it, keeping the auto-added row dimensions and only adding extras after them. Testing with a single row dimension first can also help isolate which one has no root. If it still fails, a support ticket with the sheet and breakdown screenshots is the best next step since this is still in preview.

    AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.