SAP Knowledge Base Article - Public

2958413 - File to store local SAC connections created by Analysis office

Symptom

  • You have created a system in the Select Data Source dialog box by clicking "Create New SAC Connection".
  • After that, you want to find the file which stores local SAC connections so that you can distribute it to all users' PC instead of creating the connections on each PC.

Environment

SAP Analysis for Microsoft Office 2.8

Resolution

  • The connections are stored in: C:\Users\<UserID>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\BocSystems.xml

    Example:

    <?xml version="1.0" encoding="utf-8"?>
    <BocSystems>
    <SystemInfo>
    <SystemDescription>test sac</SystemDescription>
    <LogonUrl>https://test.sapbusinessobjects.cloud</LogonUrl>
    <EnabledForLiveDataConnections>True</EnabledForLiveDataConnections>
    <BicsProvider>Poly</BicsProvider>
    <SystemType>BOC</SystemType>
    </SystemInfo>
    </BocSystems>

Keywords

AO, Analysis for Excel, Analysis for Office, A4O, AFO, Select Date Source, SystemInfo, SystemDescription, connections, connection, defined, defining, maintain, information, configuration, system, parameter, SAP Analytics Cloud, SAP Analytic Cloud , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office 2.8