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