I have added four variables in the query.
But when I execute the query , I dont see one variable out of 4. Only 3 variables I get in the selection screen
And for the fourth variable it takes some default value while executing the query.
I see all 4 variables in the query properties.
Any suggestions why the fourth one is not displaying in the selection screen.
Phaneendra Mudunuri replied
This can be due to personilization of variables. Check the entries for that variable in ODS 0PERS_VAR. Check the value exists for the variable/user entry in DSO if yes then in the query delete the personalization value
Hope this helps