In the below video I give a quick run-through of how the use SAP Analysis Office in combination with SAP Analytics Cloud. Not only can we use SAP Analytics Cloud models as a data source in SAP Analysis Office, we can also store the workbooks on SAP Analytics Cloud. Even better, we can open them from there, and make SAP Analysis Office refresh them for us without having to enter user credentials again! As you’ll see, the current integration is still very basic, but hey, we’re getting there. In the video I’m using SAP Analysis Office 2.6, but it should also work with version 2.5.
- Create Analysis Office Workbook with SAP Analytics Cloud Model as a data source.
- Store Analysis Office Workbook on SAP Analytics Cloud.
- Open Analysis Office Workbook from SAP Analytics Cloud.