SAP Knowledge Base Article - Public

3569469 - Limited Access to CDS Queries in Analysis for Office without Administrator Role

Symptom

  • When creating a datasource in Analysis for Office (AFO) without the Administrator business role (ZTALBR_ADMINISTRATOR), only a limited list of CDS queries are available.
  • The CDS queries 2CCCSMATRIXRPT10Q or 2CCCSMATRIXRPT30Q are not available unless the user is defined with the Administrator Business role.
  • The issue persists even when the user has the role "Consolidation Specialist" and can see Applications Group Data Analysis, Group Data Insight, Group Reports in Group Reporting.

Environment

Excel Addin

Reproducing the Issue

  1. Create a datasource in AFO without the Administrator business role (ZTALBR_ADMINISTRATOR).
  2. Observe that only a limited list of CDS queries are available and queries 2CCCSMATRIXRPT10Q or 2CCCSMATRIXRPT30Q are not available.

Resolution

  1. Ensure that the user is assigned to Business Catalog SAP_FIN_BC_CCON_MNGT_RPT_PC.
  2. If the issue persists, provide two users: one for which all views are available and another for which not all views are available.

Keywords

Limited Access, CDS Queries, Analysis for Office, Administrator Role, ZTALBR_ADMINISTRATOR, SAP_FIN_BC_CCON_MNGT_RPT_PC, 2CCCSMATRIXRPT10Q, 2CCCSMATRIXRPT30Q, Consolidation Specialist. , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8