Hi all,
We have used hierarchies in our model using the document https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/4155b345-0a01-0010-ac9f-b3b2c34e993c : How To Model SAP BI System Hierarchies in Visual Composer
Formula for Drill down
'FILTER_NODE_IOBJNM=0MATERIAL;FILTER_VALUE='&#ID[ACCQK]@Material_key&';FILTER_COLLAPSE= ;FILTER_IOBJNM=0MATERIAL;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%3D0MATERIAL%26DATA_PROVIDER%3DDP;'
Formula for Drill up
'CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D'&NSTR(#ID[ACCQK]@Material_node_level,'B')&'%26IOBJNM%3D0MATERIAL%26DATA_PROVIDER%3DDP;'
But in the result we cannot drill down the nodes.
Only root node is getting drilled down but not the nodes under it
i.e node1 is getting drill down and drill up but if we click(+)node2 its not getting drill down,
So can anyone of us give us suggestions in this issue
Thank you
Arun