cancel
Showing results for 
Search instead for 
Did you mean: 

variables not seen in query properties

Former Member
0 Kudos

Dear friends,

I have a question as below,

I have 10 variables in a report and i have to change the order of this variables. for this when i go to query properties I dont see 2 variables of currency conversion.

Is there any other place where i can find these two missing variables in the report or any other alternate to fix my issue.

Cheers

Nitu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Nithya

The currency conversion variable might be defined in the key figures. i.e. Go to the conversion tab of all tje key figure definitions and check if the currency translation type is chosen and the target currency defined as a variable.

Thanks,

Former Member
0 Kudos

Hello Radha,

Thanks for replying my query.

I see the variables in the key figures.But i am not getting how to change the order of this currency varibles in variable screen.

Cheers

Nitu

Former Member
0 Kudos

Hi,

Check the properties of those two currency variables.

Former Member
0 Kudos

Hi Nitu

Since you have confirmed that you are able to see the variable in your key figures, if you go to Query properties, variable sequence tab, it should be available. If it is not check the variable's properties to see if the "Variable is Ready for input "check box is checked or not.

Thanks.

hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

The display order of the variables in variable screen for a query is based on alphabetical order.

If you have a workbook which had multiple queries,and then the order of variables for each query in variable screen will be based on the assignment of query under Workbook Settings->Data Provider tab of BEx Analyzer.

Rgds,

Murali

Former Member
0 Kudos

Hello -

I believe I am having the same issue. I am using a currency conversion type that is set up with variables for currency unit, exchange rate type and date. The 3 variables show up on the variable screen but they seem to be inserted amongst my regular characteristic variables with no apparent logical order. It does not appear to be alphabetical by technical name or description.

In Query Properties -> Variable Sequence Tab, they are not listed with the regular variables which I can reorder using this tab.

I would like to be able to sequence all of the variables -- including those displayed on the variable screen because of the currency conversion type.

Thank you -

Ann

Answers (0)