The filter isn't shown in the Bex Analyzer

[Former Member]

I have made a Query in the Query Designer and i run it in the Bex Analyzer but when i do that i have the result inmediatly and i don´t have the possibility to fill the filter values....i need to fill the filter ....i made the query using the company as filter...

I hope somebody coukld help me

Regards

[Former Member · Accepted solution]

Hi Oscar.

Did you use any variables as restrictions for the characteristics on which you want to filter the query result?

br,

jacob

[Former Member · Accepted solution]

On the menu BUsiness Explorer->Change Query->change Variable value. the variable screen will be prompted again.

Remember:the variable has "ready of input" option. if is not checked then you will not see the variable screen when you execute the report, but can prompt it from the option I mentioned above.

I hope this helps.

[Former Member · Accepted solution]

Hi Oscar,

One other thing to check ... if the local query properties are set to "save and reuse variable values", the variable refresh screen will not be seen. To check this, call OLAP (either right-click or use OLAP button on Business Explorer toolbar), select Properties, look at the Interaction tab. Be sure that check box next to "save and reuse variable values" is NOT checked.

- Pete

[former_member188325]

HI Oscar,

also check that variable on Company is not personalized.

regards

Message was edited by: c c