Skip to Content
Technical Articles

Connecting SAC to AO (Analysis Office)

Use case

You would like to use Analysis Office (AO) as a user interface for SAP Analytics Cloud (SAC) but unsure how to configure the connection.

Perhaps you opened AO and went directly to “Insert data source” but a blank screen just popped up.

 

Useful links

User guide: https://help.sap.com/viewer/ca9c58444d64420d99d6c136a3207632/2.8.2.0/en-US

AO help pages, blogs and more: https://help.sap.com/viewer/product/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE/2.8.2.0/en-US

 

Steps

1. Use an AO version which supports SAC connection. At the time of writing this was 2.8. Notice the file name AOFFICESAC… This version is for 64-bit but select the correct version for your landscape.

 

2. Open AO, select “Insert Data Source” and Right-click in the open area

 

3. The pop-up for adding an SAC connection appears and you can select it

 

Note: If the option for selecting an SAC Connection does not appear then goto the FILE menu option and select ANALYSIS –> CUSTOMIZE ANALYSIS –> OPTIONS. Under the PLATFORM tab select SAC as your preferred platform.

 

4. Follow the screens and capture a connection description and the SAC URL. You can also select the check-box to enable connections to LIVE DATA CONNECTIONS. (So that answers that question if you were wondering – yes, live data connections are supported)

 

5. As you might have expected you need to logon to SAC.

 

6. After logging on your SAC acquired data models as well as live data connections are exposed and you can select any of them as a data source for AO.

 

7. On opening the data source an initial screen is presented with source data if available

 

8. If you select the COMPONENT tab and then the PLANNING tab under properties you will see the write-back system link to the SAC model

12 Comments
You must be Logged on to comment or reply to a post.
    • Hi Karan,

      The two connections are slightly different scenarios because the BW connection to SAC is a live connection using an oData data source which is typically a BW Query so wherever the BW Query is transported it can be used as a source for SAC i.e. you can stay on a single SAC tenant and point to any BW system where this query has been transported. So SAC is the front-end and BW is the backend.

      In the case of AO connection to an SAC model as described above, AO is the front-end and SAC is the backend so if the SAC model id does not change you can change the SAC connection id which is what you will do when you migrate the SAC model between SAC tenants e.g. going from a private test tenant to a public production tenant. You can't copy the model because this creates a new model id even if you keep the name of the model the same as the original but you could migrate the model to different SAC tenants and hence change the AO SAC connection.

      Regards,

      Noel.

  • When I go to Customize Analysis>>Options, I do not have a platform tab.  It was suggested by one of our partners that I go to technical configuration and check the box EnablePreferredPlatform, but when I do, that setting will not save.  Any suggestions to get the platform tab to appear?

    Thank You,

    Kody