Query url filter choice

[Former Member]

Hi experts,

My need :

1) I launch the query <QUERYNAME>, I got

url=http://companysite.com:8006/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&

INFOCUBE=<CUBENAME>&

QUERY=<QUERYNAME>&

VARIABLE_SCREEN=X&

DUMMY=16

and query expected result

CHARAC1---- KF1

123----

---

12,00

234----

---

15,00

OK

2) I want to directly modify the url (so no use of rsbbs and no hard filter in the query design), to set the filter CHARAC1=234 and get:

CHARAC1---- KF1

234----

---

15,00

How to modify the url in order to have this ?

Thanks in advance,

Julien DELSOL

[Former Member]

Many thanks guys, you provide very helpful answers.

I reached the solution with web report

-assign the query to web report and check in template properties->Force variable screen display is disabled

In query designer:

-create a variable <VAR1> user entry, single value and restrict CHARAC1 with it.

The url to use is:

url=http://companysite.com:8006/sap/bw/BEx?sap-

language=EN&bsplanguage=EN&CMD=PROCESS_VARIABLES&subcmd=VAR_SUBMIT&TEMPLATE_ID=<TEMPLATE>&var_name_1=<VAR1> &var_value_ext_1=<Filter value>

[Former Member]

Hi,

I you URL, after the DataProvider (Query Name) try to add the below code:

FILTER_IOBJNM_1%3dxxxxx%26FILTER_VALUE_1%3dyyyyy%26

%3d stands for ' = '

%26 stands for ' & '

xx - Characteritic of which you want to restrict the value

yy - Value which you want to restrict with

Just try playing around with this. What this code does is put a filter for the particular characteristic with the value that you specify and this restriction is not done in he query, but directly in he URL.

I hope this helps you out.

[Former Member]

Remember to use "FILTER_COLLAPSE=" at the end of above command otherwise it will remove the characteristics from the rows / drilldowns.

Refer this documentation:

http://help.sap.com/saphelp_nw04/helpdata/en/8d/07863be3047e19e10000000a114084/frameset.htm

Alternatively you can use VAR_NAME_1 and VAR_VALUE_1 to filter using variables as follows:

http://help.sap.com/saphelp_nw04/helpdata/en/07/ff413a3ace7022e10000000a11402f/content.htm

Refer my weblog for tips and tricks:

Abhijeet