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