I have created a Scripted Calcualtion View for cost center reporting based on the Hierarchy in SETLEAF table in SAP. I am able to get the output in Var Out as follows:
Company Level1 level2 level3 Costcenter Amount
AA DEPT1 CC1 1000
AA DEPT1 CC11 1000
AA DEPT1 DEPT2 DEPT3 CC2 1000
AA DEPT1 DEPT2 DEPT3 CC3 1000
AA DEPT1 DEPT2 DEPT4 CC1 1000
AA DEPT1 DEPT2 DEPT4 CC1 1000
AA DEPT1 DEPT2 CC3 1000
I have created the Hierarchy in Sematic--> Hierarchy tab and specified the level based type and columns as Level1/level2/level3/Cost Center ...( the same way we do in Graphical Calculation view) I have created the model and Story in SAC and when I select the Hierarchy dimension it shows as Blank without any values. This doesn't happened in Graphical calculation view .
Is there any other way in Scripted Calculation view for creating Hierarchy and using the same in SAC.
Kindly let me know the way to do the Hierarchy in Scripted Calculation view and how to use it in SAC.
Thanks in advance and appreciate the response.
Regards,
Khaja.