Forum Discussion

DomPower's avatar
DomPower
New Member
3 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

1 Reply

  • 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