Query filter dosn't work with input variable

[former_member344415]

Hi all,

I have a query and in a filter i have value ( FV270, FV270) for characteristic (ZINVESTYP).

And i have manual input variable (VAR_INVESTYP_S1) for this characteristic.

When user opened the query and selected value from list, filter in the query is work fine.

But when a user sets the out filter value manually then filter doesn't work

and template opens for input - it's not correct.

Why the filter does't work and template opens for input? How to make the filter worked?

Please help to solve the problem.

P.S. we have BW 7.0

[Former Member · Accepted solution]

I think below document will be helpful for you

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ecb78c-374a-2d10-c6af-f024f19b7...

[former_member344415 · Accepted solution]

Hi Sucheta Babar,

Thank you for the reply.

it doc helped me. I have decided to move the choice of characteristic in the form using WAD dropdown item.

[Former Member]

You should remove static filters and substitute them with custom variable

or

Do a viceversa valorization of filter...

I mean custom variable on the left and dafault filters on the right

[sapna_jgurudutt]

Hi,

Can you please refer the following SAP Note and check whether it helps you:

1062214 - Errors with direct input in web variable screen

Thanks & Regards,

Sapna

[former_member344415]

Hi Sapna J Kini ,

1062214 - old Note. And it the description does not fit for my problem. We have sp29 on our system.

Thanks & Regards,

Rafil

[Former Member]

Hi,

you are filtering  the  info-object ZINVESTYP with these two FV270, FV270 values already, that is why you can't see other values in the characteristic variable.

instead ,  remove these static filters and just use variable.

[former_member344415]

Hi,

Thank you for the reply.

I need only two values. If I remove the filter, users will be able to display all values. How to limit variable with two values?

Thanks & Regards,

Rafil

[Former Member]

you can create authorization analysis and role for info-object ZINVESTYP, then apply it to users profile, in this way they are only allowed to two values.

[Loed]

Hi,

What values you wanted to show? Then just filter it in your query, replace the FV270 and FV280 with your DESIRED VALUES..

Regards,

Loed

[former_member344415]

Hi Loed Despuig,

The problem is that the users write a value in a field that is not in the filter. And the form is opened with the wrong value.

Best Regards,

Rafil

[former_member344415]

I think this is a difficult decision.

[Loed]

Hi,

Huh? Why do they want to write values not included in the "query filter"? Aren't the users gave you the specs of the report? So they should know what values are present in the query..

Regards,

Loed

[former_member344415]

unfortunately not everyone reads the specification. so I need a foolproof system.

[swati_gawade]

Hi Rafil,

If you don't want the users to see data for other values why are you making a provision for users to enter values at all?

I suppose you want to display the report only for 2 values and that too only one value at a time. and users get to choose which one. right?

What tool are you using at front end? Is use of Radio button possible in your case?

Using Radio buttons or drop down kind of menu you will be able to restrict the report to display only these 2 values and users wont be able to enter other values but still be able to choose between these 2 values.

Hope this helps.

-Swati.

[Loed]

Hi,

So you should made a DEDICATED query for the users not using the FV270 and FV280..Else, you may try the ANALYSIS AUTHORIZATION (tcode RSECADMIN)..Just search here how to use it..

Regards,

Loed