SAP Knowledge Base Article - Public

3280050 - Check box "Use Currency Translation from Query Definition" is missing

Symptom

The check box "Use Currency Translation from Query Definition" is missing in Analysis Office.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Select a crosstab cell.
  2. Choose Measures -> Currency Translation.
  3. 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:

Option in AO.png

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

Product

SAP Analysis for Microsoft Office all versions