Problems with hierarchy display of functional locations

[Former Member]

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

[Former Member]

Lutz,

for drilldown ur webapi cm is incorrect, it shud read as follows:

'FILTER_NODE_IOBJNM=<b>0PM_ORDER__0FUNCT_LOC</b>;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;'

drill up lks ok, does that not wrk either? also wat sp vs are you on?

prachi

[Former Member]

Hello Prachi,

thanks for your tip, but that does not work either.

Drilling down either does not show anything (empty result on some lines) and some only show one line of the same Functional location I have selected.

Drill up only works when the previous drill down resulted in a empty list. If the result has one entry you are locked and you cannot jump back.

I have collected some screenshots to demonstrate my problem which I would like to provide to you, but I do not have your mail address.

My Visual composer Version is 700.10.0027.

I guess SP is 0027, if not please advise how to find out.

Thanks again. Kind regards

Lutz Knabel

E-Mail: Lutz.Knabel@atosorigin.com