Symptom
BW or S/4HANA system is asking for a transport request while saving an Analysis for Office (AO) workbook.
In Analysis Office, the following error is displayed:
------------------------------------------
Choose an existing request
BEx transport request '' is not available or not suitable
------------------------------------------
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
Try to save an AO workbook on a system with standard transport switched on.
Cause
If the standard transport system is switched on, the BEx transport requests are not used.
Resolution
Check the standard behavior on SAP Help. Basically, AO relies on $TMP (local) package and no change on this behavior can be influenced from AO side.
See Also
992965 - Query Designer: messages related to transport system
2394841 - BEx Transport request xxxxxxx is not available or not suitable
Keywords
$TMP, transport request, BEX, transport package , KBA , BI-RA-AO-XLA , Excel Addin , How To