Analyzing Financial Data Using SAP S/4HANA Embedded Analytics Reports

Objectives

After completing this lesson, you will be able to:

  • Outline the different views of consolidated data using the SAP Fiori tiles for group reporting
  • Discuss the main features of a group reporting report
  • Get an idea of the concept of Rule-based Reporting Item

Standard Reporting – Key Points

  • Standard reporting in SAP S/4HANA Cloud for group reporting is done with the help of SAP S/4HANA embedded analytics reports, that is standard reporting using SAP Fiori tiles at consolidation unit or group level.

  • SAP S/4HANA embedded analytics is available by default and allows drill-down to document level.

With the help of the Group Data Analysis app, you can display different views of consolidated data.

  • Group View: The group view is based on the group structure that includes consolidation groups and units.

  • Hierarchy View: The hierarchy view is based on hierarchies of profit centers, segments, and consolidation units. By selecting different FS item hierarchies within the app, you can generate consolidated financial statements such as balance sheets and profit and loss statements.

Before you use this app, make sure that you’ve selected values for the parameters in the Set Global Parameters app. Once these values are saved in the global parameters, they are then derived for the corresponding variables in this app.

Main Features in the Standard Reporting Apps for SAP S/4HANA Finance for Group Reporting

As the corporate accountants are performing the close, the Group Data Analysis app can be used to quickly access the financial data. The app contains the following features:

  • Drag and drop navigation

  • Every dimension in ACDOCU is available for navigation in the standard app

  • Filter on any dimension

  • Report on multiple periods and versions

  • Report on period or year-to-date data

  • Save report filtering and navigation with bookmarks and report variants

  • Create user-specific tiles based on personal report design

  • Email reports

  • Download into Microsoft Excel

  • Collapsible filter and navigation areas

  • Use group reporting time-independent hierarchies

  • Use group reporting time-dependent hierarchies

  • Display sign adjusted data

  • Swap axis

  • Defer layout update

  • Sorting

  • Grid and axis properties

Concept of Rule-Based Reporting Items

Reporting Item - key points

  • A reporting item is technically an FS item whose FS item type is REPT (Reporting Item).

  • A reporting item can be enhanced by assigning it a set of selection criteria of specific data such as:

    • FS items
    • Consolidation units
    • Document types
    • Subitems
  • The assignments of data selection criteria to reporting items are called reporting rules. These reporting rules determine how the values for a reporting item are derived in a report.

  • With the reporting rules in place, when you use a reporting item in a report, its values are calculated by aggregating the data from the selection criteria defined in the reporting rules.

  • Reporting items are arranged into reporting item hierarchies which are used in reports to display the reporting items in a hierarchical structure.

  • You can use reporting items as additional analytical dimensions in reports such as:

    • Statement of cash flow
    • Statement of changes in equity
    • Statement of comprehensive income
    • Profit and loss (P&L) statement by function of expense

The following figure shows how this comes together in a report. It also shows the relationship between an FS item, reporting item, reporting rules, and reporting item hierarchy.

In the figure above, you can see that:

  • The system calculates an aggregated amount for Reporting Item 1 based on the selection criteria that are assigned in the reporting rules.

  • The amount for Reporting Item 1 aggregates all the amounts from the range of FS items from FS Item 1 to FS Item 5.

  • The reporting item acts as one entity, but actually represents a set of data defined by these selection criteria in the reporting rules.

There are five delivered reporting item hierarchies:

  • X1: Statement of changes in equity

  • X2: Statement of cash flow

  • X3: Statement of comprehensive income.

  • X4: P&L by function of expense

  • X5: IC reconciliation

The figure shows the rule-based cash flow statement as an example:

Log in to track your progress & complete quizzes