| Analysis for Microsoft Office , Analytics , SAP Analytics Cloud ,
SAP has announced the BI Convergence Strategy in their latest roadmap and it looks like SAP Analytics Cloud is going to be the primary solution for data discovery. With SAP focusing on their new data discovery investments with SAP Analytics Cloud, down the road we would have a one-stop solution that integrates with both on premise and cloud-based data sources. Their main aim is to combine SAP Analytics Cloud and SAP BusinessObjects Enterprise into a single hybrid solution so that we can get best of both the worlds.
We at Nine Boards wanted to create an Analysis for Office report by consuming models from SAP Analytics Cloud and here’s how we went about it.
Please make sure you follow this exact format so that you don’t run into connection issues.
Limitations (as of SAP Analysis for Office 2.6) :
Currently there are a few limitations with this feature and I have listed them below :
Apart from the above scenario we have tried (where we use SAP Analytics Cloud models as a data source in SAP Analysis Office) we can also store AO workbooks on SAP Analytics Cloud. We can open the AO workbooks in SAC and refresh the document without having to login to Analysis for Office. This kind of interoperability makes way to a whole new round of possibilities in the near future.
Setting up High availability for SAP Cloud Connector – 2.12
Dynamically Switching Dimensions in Power BI using DAX
Tableau vs. Power BI vs. Looker – Which tool is better for your Business?
Creating Certificate Using OpenSSL and Importing it into SAP HANA Web Dispatcher