Drill down and drill up in Hierarchies not functioning properly

[Former Member]

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-b3b... : 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

[Former Member]

Hi Arun

Find the above text - 3DDRILL_TO_LEVEL%26LEVEL%3D2 & replace it with text below

3DDRILL_TO_LEVEL%26LEVEL%3D3. this will unable you to drilldown to third node. Like wise you enter the number after "%3D_" to get required level of drill down.

I hope this will work,

regards

Sandeep