BEx: How to change a Query Variable that is not visible in Filters List?

[Former Member]

Hello Experts,

Good day, I'm currently editing an old query, I am changing the Query Variables with new ones, but I found one variable that I cannot replace.

Please see the screenshot below, in the Query Properties Window [Variable Sequence Tab (right side of picture)] the Variable that I am trying to replace (Unit) is visible. But when I look for the variable in the "Filter Tab" (left side of picture) under Characteristic Restrictions, it doesn't exist in the list.

How can I find this Variable and replace it with a new one?

Other reports are still using this variable so it will impact the other reports if I simply edit the variable. So I need to replace it with a new variable instead.

Thank you for your time.

[Former Member · Accepted solution]

Thank you Anshu and Umashankar.

I found the correct Variable, and yes it is assigned inside a Key Figure (under Conversions Tab).

How can I create new Conversion variables for the KeyFigure?

and where are existing Conversion Type variables being maintained?

I checked the InfoProvider window inside BEx and checked all Dimensions in the list

but I cannot find the ZUOM variable.

[umashankar_poojar · Accepted solution]

Hi,

        SInce you are searching for a variable for Unit, look into below screenshot and navigate to the variables.

First click on drop down and select 'Entry for variable' then you will get lisl (after you click on drop down in 'Target Unit' drop down option.

Normally these type of variable called 'Formula Variable' try editing any of the formula and locate the option as shown below,

Hope it helps! don't forget to update the final solution and mark the correct/helpful answers.

Remember it will help others to find the solution and motivate the members to answer your question.

Thanks,

Umashankar

[Former Member · Accepted solution]

Hi Umashankar,

thank you but what I am looking for is the "Conversion Type Variable" not the "Target Unit" variable.

please see my screenshot. the variable is under "Conversion Type".

I checked the variables available for Target Unit and even Formula Variables but there was no "ZUOM" variable.

[anshu_lilhori · Accepted solution]

Quantity conversion type variable you can check in RSUOM transaction.

You will find it there.

Regards,

AL

[Former Member · Accepted solution]

Thank you Anshu! I was finally able to create a new Quantity Conversion Type Variable

[umashankar_poojar]

Hi,

         I agree with Anshu Lilhori it might be used in any of KeyFigures, goto RSRTQ t-code and give your query technical name. View/download the data and search for 'Unit'  variable. you will get where used list, based on that take decision.

Hope it helps!

Thanks,

Umashankar

[anshu_lilhori]

Check if this variable has been restricted locally in some RKF or selection.

Regards,

AL