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
How can admin set the SAC connection in the setup file?
Hi
I am also struggling to find the same? Did you get something around this?
Thanks
Nope! But we added it to the software installation setup.
Hi,
could you explain in a few words how you "added it to the software installation setup"?
regards.
Oliver
Hi
Could you please let us know where you added it in the software installation setup?
The connection is located in
C:\Users\[user]\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\BocSystems.xml
Thanks!
you can save the https url in User roaming file - BocSystems.xml placed at location:
C:\Users\*******\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis
How can we roll it out for all users, so that every user need not to do it manually?
Thanks,
Arpan
Hi,
Currently there is no other way to perform this connection other than each user entering the URL.
Regards,
Noel.
Hi Noel Munday
I have a question, will it possible to replace the system in case of SAC connection as we do for the BW connection.
Thanks in Advance.
Karan
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
Your AO version? No issues with AO 2.8.5...
2.8.401.94659
Test the latest AO before...
We for the first time trying to connect to SAC, users without admin access to their computers getting stock a message that
" log on was successful
Fetching data from server"
However, after giving admin access to user this issue gets resolved and even admin access revoked there is no more issues. It seems data gets cached somewhere in user profile. Unfortunately, for a very large end users community we have, this temp admin access is not a affordable solution.
What could be a solution?
We use AO with the SAC via SSO.
Now I would like to log in not with SSO but for testing with another SAP user.
How to do this?
Hi Noel,
I am facing a weird issue while consuming SAC in AO.
When I am consuming SAC planning model I am able to see all the data in AO.
But when I am consuming SAC analytic model in AO, I am seeing NOT_EXIST in measure value, but could see the master data for all dimensions, Could not figure out what would be the issue. please help me by resolving the issue.