SAP Knowledge Base Article - Public

3323393 - "No RFC authorization for function module RFCPING" error in Analysis for Office

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Try to connect to SAP S/4HANA Cloud via "SAP S/4HANA Cloud Connection" in Analysis for Office client tool but ended with "No RFC authorization for function module RFCPING" error.

Environment

SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

1.Try to connect via "SAP S/4HANA Cloud Connection" as below. 

2.Error "No RFC authorization for function module RFCPING" will pop up.

Cause

Missing business catalog SAP_BW_BC_AOF_PC (business role template SAP_BR_EMPLOYEE). 

Resolution

Make sure that your user has the business catalog SAP_BW_BC_AOF_PC (business role template SAP_BR_EMPLOYEE) assigned in SAP S/4HANA Cloud.

See Also

About how to create "SAP S/4HANA Cloud Connection", please refer online help:

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE/df90d3701aba42b9a4351caa387bd672/e8d9c0a197e341279c6db450da43996c.html?q=HANA%20CLOUD%20CONNECTION&locale=en-US

Keywords

AO, Analysis for Excel, Analysis for Office, A4O, AFO, SAP_BR_BUSINESS_ANALYST_GRP, SAP_FIN_BC_CCON_MNGT_RPT_PC, Analysis for Microsoft Excel , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8 ; SAP S/4HANA Cloud 2302