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:
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