Problems with hierarchy display of functional locations

34 Views

Hello Experts,

I tried to buid a model whch displays the hierarchy of functional locations and followe all steps of the How-To Model SAP BI System Hierarchies in Visual Composer paper but it does not work as described.

When I mark the Line I want to drill down and click the drill down button after the refresh it shows only the single value of this line and it does not show the functional locations below. Clicking Drill up nothing moves.

For Drill down I used the following coding:

'FILTER_NODE_IOBJNM=@Functional_Location_key;FILTER_VALUE='&#ID[ACCXVU]@Functional_Location_key&';FILTER_COLLAPSE= ;FILTER_IOBJNM=0PM_ORDER__0FUNCT_LOC;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%3D0PM_ORDER__0FUNCT_LOC%26DATA_PROVIDER%3DDP;'

For drill up I used the coding:

'CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D'&NSTR(#ID[ACCXVU]@Functional_Location_node_level,'B')&'%26IOBJNM%3D0PM_ORDER__0FUNCT_LOC%26DATA_PROVIDER%3DDP;'

Any suggestions?

Thanks a lot in advance

Kind regards

Lutz Knabel