3375951 - Standard Transport Behavior for AO Workbooks

1. 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
------------------------------------------

OR

2. When saving an AO workbook to BW there is no transport message, only "The MS document XXX was successfully saved".

• SAP Analysis for Microsoft Office

1. Open an Analysis for Office workbook
2. Go to File > Analysis > Save Workbook > Save Workbook on the SAP Business Warehouse Platform
3. Select the BW system
4. Save
5. Confirm the message

• The "Standard BEx Transport Request" is blank.

...AND...

• The standard transport is switched ON

...OR...

• The standard transport is switched OFF, but the user is trying to save an already transported (existing) AO workbook.
• In this case AO requires the Standard BEx Transport Request.

(Find instructions on how to check these fields on the resolution section of this KBA)

Check the standard behavior on SAP Help and consider the points below:

• Analysis Office is not able to influence the transport request behavior;
• The standard transport ON requires a SAP GUI session as it will prompt for a transport request dialog. Since AO only establishes a RFC connection to the BW system and not a SAP GUI session, the prompted dialog is not supported by AO;
• When having the standard transport set to OFF, it is necessary to differentiate between the two scenarios below:
• Newly created AO objects/reports:
  Those objects/reports will be saved as local objects and can be found under $TMP package without a transport request assigned.
• Existing objects assigned to a package OR already transported AO objects/reports:
  Those objects require the standard BEx transport request.

If the standard transport is switched ON or if the user is trying to save an already transported AO report, make sure the "Standard BEx Transport Request" is not blank.

Basically, AO relies on $TMP (local) package and no change on this behavior can be influenced from AO side.

--------------------------------------------------------------

How to check if the Standard BEx transport Request is blank:

1. Go to transaction RSA1
2. Click on "Transport Connection"
3. Click on [  BEx]
4. Confirm Standard BEx Transport Request field is blank

--------------------------------------------------------------

How to check if Standard Transport is ON or OFF

1. Go to transaction RSA1
2. Click on Edit > Transport

• If "Switch-On Standard" button is enabled, it means that the current state is 'OFF'

• If "Switch-Off Standard" button is enabled, it means that the current state is 'ON'

992965 - Query Designer: messages related to transport system

2394841 - BEx Transport request xxxxxxx is not available or not suitable

SAP BW/4HANA Help - Transporting Objects Using a BEx Transport Request

$TMP, transport request, BEX, transport package, AAOE , KBA , BI-RA-AO-XLA , Excel Addin , How To