Symptom
The check box "Use Currency Translation from Query Definition" is missing in Analysis Office.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
- Select a crosstab cell.
- Choose Measures -> Currency Translation.
- In the Currency Conversion dialog, confirm that the check box "Use Currency Translation from Query Definition" is missing.
Cause
The option "Enhance Currency Conversion by Query Definition" is not selected in Analysis Office.
Resolution
The check box "Use Currency Translation from Query Definition" is only available in the "Currency Conversion" dialog if the option "Enhance Currency Conversion by Query Definition" is selected in the Options of Analysis Office as shown below:
The options are available via File -> Analysis -> Customize Analysis -> Options.
Refer to documentation below in the User Guide:
Keywords
missing, not available, BexAdvancedMode, conversion, translation, checkbox , KBA , BI-RA-AO-XLA , Excel Addin , Problem