Function module RRW3_GET_QUERY_VIEW_DATA

[former_member721852]

Hi guys,

I need your help!

Is it possible to assign a display hierarchy to a characteristic and the filter on the respective nodes?

I tried the following command sequence:

&CMD_1=CMD%3DSet_Hierarchy%26DATA_PROVIDER%3DDP%26IOBJNM%3D0COMPANY%26HIERARCHY_NAME%3DCOMP_HIER%26ACTIVE%3DX
&FILTER_IOBJNM=0COMPANY
&FILTER_NODE_IOBJNM=/MRG/COMPCODE
&FILTER_VALUE=001&FILTER_SIGN=I&FILTER_COLLAPSE=

Unfortunately, this doesn't work. The hierarchy will be changed, but the filter won't be applied.

Putting everything in the same cmd works:

&CMD_1=CMD%3DSet_Hierarchy%26DATA_PROVIDER%3DDP%26IOBJNM%3D0COMPANY%26HIERARCHY_NAME%3DCOMP_HIER%26ACTIVE%3DX%26FILTER_IOBJNM%3D0COMPANY
%26FILTER_NODE_IOBJNM%3D/MRG/COMPCODE
%26FILTER_VALUE%3D001
%26FILTER_SIGN%3DI
%26FILTER_COLLAPSE%3D=

The problem here is the limitation of 250 characters per subsequent command, especially if I want to apply multiple filter values.

Thank you!

Konstantin

[VijayetaSharma]

Hello,

Check if below blogs and wiki helps. I don't think you can overcome the length limit of 265 characters though.

Expose BI Query as RESTful Service

Execute BW query using ABAP Part III

Execute BW query using ABAP Part II

Appreciate if you up-vote/ accept, if this helped.

Thanks,

Vijayeta

[former_member721852]

Hi Vijayeta,

Thank you, but unfortunately this does not help fixing my issue...

I just don't see why Filter (as generic command) and DRILL_TO_LEVEL command subsequently works perfectly but SET_HIERARCHY command and Filter (as generic command) subsequently does not work?

Is this a bug? Is the filtering process always carried out at the beginning? Am I missing anything else?

Btw I use this documentation: https://help.sap.com/doc/saphelp_dm40/4.0/en-US/59/edfe395dd76846e10000000a114084/frameset.htm

Any help is highly appreciated!

Thank you,

Konstantin