3630247 - AO workbooks are not visible in role after transport

In transport source system, AO workbooks are assigned to a role. However, after transporting the role and its assigned AO workbooks separately, in transport target system, the transported AO workbooks are not visible in the role.

"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. 1. In transport source system, one or some AO workbooks are assigned to a role.
   2. Transport the role in T-code PFCG.
   3. Transport the AO workbooks in T-code RSA1.
   4. In transport target system, import the transport request.
   5. Confirm the transported AO workbooks are however not assigned to the role.

To transport AO workbooks together with role, ensure the AO workbooks and the corresponding role are in the same transport request, otherwise the mapping relationship between AO workbooks and role will be missing after the transport.

1. In transport source system, run T-code RSA1.
2. In Transport Connection-> Object Types-> Role, click 'Select Objects' button to select the role, confirm the role displays in 'Collected Objects' area.
3. Right click on the corresponding role, select 'Transport All Below' option, ensure the AO workbooks of the role are also selected.
   
4. Select the corresponding role and click the 'Transport Objects' button.
5. In the 'Prompt for transportable workbench request' dialogue, assign or create a transport request, and then click 'Continue' button.
     
6. In T-code SE01, confirm the AO workbooks and the role are in the same transport request.
   
7. Release the transport request.
8. In target system, import the the transport request.
9. Confirm the AO workbooks are assigned to the role.

Analysis Office, Analysis for Office, A4O, Analysis for Excel, A4O, role mapping, role assignment, AO report , KBA , BI-RA-AO-XLA , Excel Addin , Problem