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
- Create a datasource in AFO without the Administrator business role (ZTALBR_ADMINISTRATOR).
- Observe that only a limited list of CDS queries are available and queries 2CCCSMATRIXRPT10Q or 2CCCSMATRIXRPT30Q are not available.
Resolution
- Ensure that the user is assigned to Business Catalog SAP_FIN_BC_CCON_MNGT_RPT_PC.
- 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