SAP S/4HANA Public Cloud for Solution Business reporting with SAP Analysis for Office

[Sujith_S]

SAP Analysis for Microsoft Office can be connected to your SAP S/4HANA Cloud system.

Following are the pre-requisites:

• Analysis for Office license  
• SAP Analysis for Microsoft Office is installed (2.8.15 and Higher).It can be downloaded from: Software Downloads – SAP ONE Support Launchpad. SAP Analysis for Microsoft Office is included with the license for SAP BusinessObjects Enterprise, SAP BusinessObjects Planning & Consolidation or SAP Analytics Cloud (Edition for SAP Analytics Cloud).  An additional logon to SAP Analytics Cloud is required before creating the SAP S/4HANA Cloud connection When using the Edition for SAP Analytics Cloud.
• SAP S/4HANA Cloud tenant.
• Business roles - SAP_BR_SOLN_ORDER_SPCLST ,SAP_BR_BUSINESS_ANALYST_GRP and SAP_BR_EMPLOYEE need to be assigned to the user.

Please follow the Section ‘What are the steps to connect to SAP Analysis for Microsoft Office?’ in the blog SAP S/4HANA Public Cloud for group reporting with SAP Analysis for Microsoft Office | SAP Blogs for the steps to connect SAP cloud system with Microsoft Office.

For example, to open Upcoming service contracts report, please search for the query in the search box and click on it and Select ‘ok’.

The initial query is shown, only the columns are displayed.  Using the analysis options on the right hand side it is possible to slice and dice the data as required.

Drag and drop the fields from the Data source area in the Measures and Rows for the intended analysis and reporting.  For example, in the rows the service contracts are displayed for specific sold-to-parties and only for sales organization US, which has been added as a filter.

You can create your own queries as required.