Hi Experts,
We will be using SAP Analytics Cloud to report on CFIN data. As you know there are 3 different versions of Analysis for office.
o SAP Analysis for Microsoft Office, Edition for SAP Analytics Cloud – this version connects with SAP Analytics Cloud. Works for both Live and Import Data connection
o SAP Analysis for Microsoft Office (Formerly SAP BusinessObjects Analysis for Microsoft Office) – connects with SAP Business Objects. This is full version. Users need one license to use it. It can connect with BusinessObjects BI platform, HANA or BW or CFIN.
o SAP Analytics Cloud add-in for Microsoft Office – cloud-based version for Office 365. Mainly created to use with SAP analytics Cloud for planning. But still having limitation.
We are planning to go for 2nd option of AFO. Because we will be able to connect to data directly without extra layer of SAC Tenant. Is there any license related limitations here?
We also can use 1st option of AFO. On that case we have to create SAC models for each ABAP CDS views that we want to expose. That will be and extra task. Again, we will have extra layer of SAC between CFIN and Analysis for Office, which I believe will slow down data refresh compared to option 2.
Please suggest which one will be better option from performance and Licensing perspective.
Thanks in advance!!