Symptom
Error in AO trace when trying to access BW system from Analysis Office:
-----------------------------------------------------------------
"User does not have the authorization to call the necessary functions of group RFC_METADATA in system XYZ"
-----------------------------------------------------------------
The error can be a little different in some older AO versions:
------------------
"User does not have the autorization to call the neccessary functions of group RFC_METADATA in System XYZ"
-----------------
The dev_nco_rfc.log trace (see SAP Note 1830850) contain the following entries:
-----------------------------------------------------------------
error when retrieving metadata from XYZ via destination
...
attempting to select an alternate destination
SAP.Middleware.Connector.RfcInvalidParameterException: Element EX_FUNCTIONS of container metadata RFC_METADATA_GET unknown
at SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, RFCID rid)
...
-----------------------------------------------------------------
Environment
SAP Analysis for Microsoft Office
Cause
The issue might be related to the usage of an old NET Connector version (3.0.x) when trying to connect to a newer BW system which requires a higher NET Connector version (e.g. 3.1.x).
The version of the NET Connector used to connect to the BW system can be found in dev_nco_rfc.log trace (see SAP Note 1830850).
Resolution
Install a higher version of SAP Analysis for Office which contains a higher version of NET Connector. The latest version of the tool can be downloaded by visiting the Support Content page Analysis Office Installation and Update and following instructions in section #2.
Keywords
Element EX_FUNCTIONS of container metadata RFC_METADATA_GET unknown, attempting to select an alternate destination, NCo, .net , KBA , BI-RA-AO-XLA , Excel Addin , Problem