Skip to Content
0
Former Member
Apr 09, 2009 at 12:48 PM

Drill down and drill up in Hierarchies not functioning properly

35 Views

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