Symptom
AO workbook or Folder is not visible under the respective role. But if go to backend PFCG, under "Menu" of this Role, this workbook or Folder is visible.
“Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.“
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
1.Open AO.
2.Open a workbook from the SAP Business Warehouse Platform.
3.Go to Role tab.
4.Expand a specific Role.
5.The workbook or Folder is not listed.
Cause
- Redundancy avoidance is activated, in other words, CONDENSE_MENU and DELETE_DOUBLE_TCODES are set to YES.
- The property 'Hide Menu from SAP Easy Access' of 'Menu Options' is checked on for the affected role in transaction PFCG.
Resolution
- Deactivate Redundancy avoidance by setting NO for the parameter CONDENSE_MENU and DELETE_DOUBLE_TCODES in table SSM_CUST.
- Open the affected role in transaction PFCG. Unmark the property 'Hide Menu from SAP Easy Access' of 'Menu Options' and save the role.
See Also
- 357693 - Redundancy avoidance in Easy Access
This note is mainly about Easy Access, but the configuration in table SSM_CUST influences the role behavior of AO as well. - https://community.sap.com/t5/technology-blogs-by-members/analysis-office-role-folder-in-sap-netweaver-platform/ba-p/13362776
- Authorizations for the SAP NetWeaver platform
Keywords
AO, Analysis for Excel, Analysis for Office, A4O, AFO, visible, not seen, report, invisible, blank, cannot see, not available , KBA , BI-RA-AO-XLA , Excel Addin , Problem