Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i tried to make an hiearchy in my edit script, by reading some of the examples in here, but i cant seem to get it right.
So i hope someone can help me:
I have this Table:
QUALIFY*;
UNQUALIFY SalesPhasesKey;
DimSalesPhases:
LOAD SalesPhasesKey,
FieldID,
OptionText,
OptionID,
OptionID as ParentOptionID,
Milestone,
Phase;
SQL SELECT *
FROM Hej.dbo.DimSalesPhases;
UNQUALIFY*;
Hiearcgy:
Hierarchy(HiaerOp,HiearParent,HiearMilestone,',HiearPhase, TreeView)
Load OptionID as HiaerOp, OptionID as HiearParent, DimSalesPhases.OptionID as HiearParent,DimSalesPhases.Milestone as HiearMilestone,DimSalesPhases.Phase as HiearPhase
Resident DimSalesPhases;
My OptionID is my ID for OptionText - How ever i have substringed my OptionText into to- Milestone and Phase
Thank you! I tried that link but could not get it to work.
But the document you posted helped me alot:
HierarchyTable:
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;
Hiearchy_Table:
Hierarchy(NODE_ID_H,PARENT_NODE_ID_H,ID,PARENT_NAME,NAME,Treeview) Load
NODE_ID,
NODE_ID as NODE_ID_H,
PARENT_NODE_ID as PARENT_NODE_ID_H,
VALUE as ID,
VALUE as NAME
Resident HierarchyTable;
This is what i finished with and then it worked - Thanks alot!