https://userapps.support.sap.com/sap/support/knowledge/en/2468979
2468979 - Hierarchy Node variable appearing as Flat instead of tree structure in Webi 4.2 SP2 | SAP...
Hierarchy node variable appearing as Flat instead of tree structure in webi. Changing the order of hierarchy variable in query designer works in webi.