How to Change BI variable parameters

Once a variable has been created, the definition of some parameters (Processing By, Variable Represents and some others) can't be modified within Bex Query Designer.
 
There is a variable represented by single value, but according to some business process, we need this variable to be represented by multiply single value instead of single value.

In details TAB  the Variable represents - single value. need to change it to Multiple single values.

SAP recommended way to solve this issue is to delete this variable and create a new one with suitable parameter.
But what should we do if this variable already has been used within 100 queries ?
In this case we can use not recommended, but proper way - change these parameters directly via RSZGLOBV table.

Go to TC SE16 -> Table RSZGLOBV and enter variable's technical name in Variable Name (VNAM) field and select Vesrion : A. click on Execute button.

It will display the Record with our Variable name. select the variable and click on change button (F6)

In the next screen it is possible to change any parameter of variable. In our case we want to change Variable Represents (Select parameters in RSZGLOBV table) parameter.
Change the content of Select parameters (VPARSEL) field from P to M and save the changes.



Do the same for M version entry in RSZGLOBV table.
Now we need to generate all the queries that use this variable.
Go to TC RSRT - > Environment - > Gen. Queries Directly.


Type info provider technical name with the queries to be generated and press Execute (F8).