3585536 - The role folder is not visible under the 'Role' tab of  the dialog 'Select Data Source -<system name>' in AO

A role was created via PFCG, but no query or workbook is assigned to the role.

The role folder is not visible under the tab of 'Role' of  the dialog 'Select Data Source -<system name>' in AO.    

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

SAP Analysis for Microsoft Office

1. Create a role via T-code: PFCG.
2. Assign the role to the user.
3. Open AO and click 'Insert Data Source', login the system with above user.
4. The role is not visible under the tab of 'Role' of  the dialog 'Select Data Source -<system name>'.

This is standard behavior in AO, the role will not be visible if no query or workbook is assigned to it. 
In other words, in case the role contains any query or workbook, the role will appear in the dialog 'Select Data Source -<system name>' of AO.

After publishing a query to the role through Query Designer or BW Modeling tool or publish a workbook to the role through AO, the role becomes visible under the 'Role' tab of  the dialog 'Select Data Source -<system name>' in AO.

AfO, Analysis for Office, role, empty, no query, workbook can not seen, not visible, folder, open Document screen,query is not visible, query or workbook is missing , KBA , BI-RA-AO-XLA , Excel Addin , Problem