on 09-03-2009 5:32 PM
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.