Filtering via URL change

[Former Member]

Hi SDN,

I run a query from the Web App Designer and it runs fine. In the resulting URL I add the following line:

&FILTER_IOBJNM=ZK_ACCT&FILTER_VALUE=3100

The URL thus becomes:

http://fbwdev.dcs.eis.lmco.com:1080/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=T...

The query is correctly filtered but at the same time the filtered column (ZK_ACCT) also disappears from the output. It is a test query with just one characteristic (ZK_ACCT) and one key figure.

What's wrong with my approach? Thanks for your help.

Saf.

[former_member195980 · Accepted solution]

By default, the collapse parameter is set to X. To keep the drilldown, you would hav to set it to empty:

&FILTER_IOBJNM=ZK_ACCT&FILTER_VALUE=3100&FILTER_COLLAPSE=

(maybe &FILTER_COLLAPSE='')

Regards,

Beat

[Former Member · Accepted solution]

Thanks Beat. That solved it and I assigned the points.