SAP Knowledge Base Article - Public

2433770 - Error when opening the Value Help of a HANA view's variable in AO


One of the following errors are occurring in Analysis for Office:

  • 42522 - No values set for mandatory variable : <XYZ>
  • 42471 - The variable can't be read : <XYZ>
  • Error while fetching members of characteristic <XYZ>


SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Execute HANA view in Analysis for Office;
  2. Open the Value Help of a variable;
  3. Confirm one of the errors mentioned in this document.


The issue might occur because the parameter mapping of the Value Help used in the HANA view is missing.


Enhance the calculation view and provide information about the parameter mapping for the value help.

Check if a variable mapping for the affected variable exists for the external variable view. See example below:


See Also

2270353 - Different Behavior of Value Help Views with BICS InA Access compared to BICS SQL Access


value help, variable, parameter, input, f4, lov, list of values, exception, map, external, failing, fails, variant, invalid, empty, required, mandatory, V_SAPClient, return, returning, selection, var , KBA , BI-RA-AO-XLA , Excel Addin , HAN-DB , SAP HANA Database , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , Problem


SAP Analysis for Microsoft Office all versions