Thank you! I tried that link but could not get it to work.
But the document you posted helped me alot:
Load distinct DimSalesPhases.Milestone as VALIE, DimSalesPhases.Milestone & '-Mile' as NODE_ID, DimSalesPhases.Phase & '-Phase' as PARENT_NODE_ID resident DimSalesPhases;
Load distinct DimSalesPhases.Phase as VALUE, DimSalesPhases.Phase & '-Phase' as NODE_ID, DimSalesPhases.Milestone & '-Mile' as PARENT_NODE_ID resident DimSalesPhases;
NODE_ID as NODE_ID_H,
PARENT_NODE_ID as PARENT_NODE_ID_H,
VALUE as ID,
VALUE as NAME
This is what i finished with and then it worked - Thanks alot!