SAP S/4HANA Cloud for Finance: Balance Reporting – Part 4: Custom Report Consumption
Welcome to part 4 of this blog series that covers the custom report consumption. To understand the different balance types and standard reports as well as standard API please look into the first two blog of this series.
- Blog 1: Introducing balance types and consumption types covered by this blog series
- Blog 2: SAP S/4HANA Cloud: Standard reports and standard API for balance reporting
- Blog 3: SAP S/4HANA Cloud: Custom report creation for balance reporting
- This Blog: SAP S/4HANA Cloud: Custom Report consumption
- Blog 5: Summary
In this blog we explain the possibilities to consume your custom balance reports in:
- SAP Fiori Launchpad
- Microsoft Excel
- OData Clients (SAP Analytics Cloud, …)
Consumption via SAP Fiori Launchpad
Every custom query can be consumed via a generic Fiori UI. You can define a separate tile for it in the SAP Fiori Launchpad. Here you have two options.
Option 1: Local Tile
For the local tile you call the app ‘Custom Analytical Queries’ and go to the details of your defined query. Here you click on ‘Preview’.
Fig. 1: Preview Custom Analytical Query
You fill the selection parameter and trigger the selection. Now you can save the report as a separate tile via ‘Save as Tile’.
Fig. 2: Save as a Tile
You can provide a title, subtitle and assign it to a group.
Fig. 3: Personalize Tile
The tile is then available in the group ‘My Home’.
Fig. 4: Fiori Launchpad with the New Report
Option 2: Custom Tile
If the tile should be available for other users as well, you can use the app ‘Custom Tile’. First you copy the link from the query preview of the app ‘Custom Analytical Queries’. Then you open the app ‘Custom Tiles’. You maintain a tile title and enter the URL that was copied from the preview. As URL parameter you enter the query name and the system alias.
Fig. 5: ‘Custom Tile’ app
You can already preview the result by clicking on the tile. With ‘Assign Catalogs’ button you can assign it to an existing catalog and publish the tile.
Fig. 6: Assign the report to a business catalog
The tile is then available in the corresponding business catalog.
Fig. 7: Fiori Launchpad with the New Report
Consumption via Microsoft Excel
Every custom query can also be consumed in Microsoft Excel. Therefor you can either use SAP Analysis for Microsoft Office or you can download the result of the generic Fiori app into Microsoft Excel.
Fig. 8: Export to Microsoft Excel
Consumption via OData
Custom CDS views can also be consumed with OData. All you need to do is to check the flag ‘External API’
Fig. 9: Check the flag ‘External API’
You can then activate the OData service with the app ‘Custom Communication Scenarios’ by creating a scenario ID, adding the CDS View and publishing the service.
Fig. 10: Activate the OData Service
You can then use the OData service in SAP Analytics Cloud, other Fiori Apps or consumer.
For more information on SAP S/4HANA Cloud, check out the following links:
- SAP S/4HANA Cloud release info: http://www.sap.com/s4-cloudrelease
- Sven Denecken’s 1902 blog on SAP News here
- Best practices for SAP S/4HANA Cloud here
- SAP S/4HANA Cloud Customer Community: here
- Feature Scope Description here
- What’s New here
- Help Portal Product Page here
Follow us via @SAP and #S4HANA, or myself via @HaukeUlrich and LinkedIn.