SAP Knowledge Base Article - Public

3588311 - Scheduling Analysis for Office workbooks with SNC encryption

Symptom

  • The scheduling of Analysis Office Workbooks fails with Return Code 30 if SNC is configured for the respective OLAP connection.
  • Information about SNC BI Platform and BW system when scheduling Analysis Office workbooks is required.

Environment

SAP Analysis for Microsoft Office

Resolution

Having a working Single Sign-On (SSO) solution between the BI Server and BW system is a prerequisite to schedule Analysis Office workbooks in BI Platform.
This SSO solution is usually via a Logon Ticket that BI Platform retrieves from BW system and includes in the information used by AO to trigger the precalculation step of the scheduling process. When using a Logon Ticket, it is not necessary to encrypt the RFC connection established between BI server and the BW system. Until AO 2.8 SP25, only SSO (Single Sign On) without SNC is supported by Analysis Office BIP Addon.

From AO 2.8 SP26 onwards, however, a connection with SNC can be used to schedule AO workbooks.
More information to configure it can be found in SAP Note 3584361 - The Scheduling of Analysis Office Workbooks fails if SNC is used

See Also

SAP Note 3584361 - The Scheduling of Analysis Office Workbooks fails if SNC is used

Keywords

Return code: 30 , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem

Product

SAP Analysis for Microsoft Office all versions