Symptom
In the Group Financial Statements Review Booklet app, the Profit & Loss (Function of Expense) section does not display any reporting items or amounts.
The Profit & Loss (Nature of Expense) section may display data correctly.
Relevant consolidation data can be found in the regular Group Data Analysis app.
When executing Group Data Analysis – With Reporting Rules, the following message may be displayed: "Result set for query 2CCSRPT40Q is empty"
The reporting item hierarchy and reporting rule variant are available and can be selected.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the Group Financial Statements Review Booklet app.
- Enter consolidation details (group, fiscal year, period, version) and start the query.
- Select Profit & Loss (Function of Expense).
- Enter filter and value details (for example, via Page Filters).
- Observe that the result is empty or that no data can be seen.
Cause
The reporting rules maintained for the selected combination of:
- Consolidation chart of accounts
- Reporting item hierarchy
- Reporting rule variant
have not been replicated, or their runtime replication is no longer current.
Although the rules are visible in the Define Reporting Rules app, the analytical applications do not consume the latest rule definition until the reporting rules are replicated.
Resolution
To resolve this issue, please follow the steps below:
- Open Define Reporting Rules app.
- Select the relevant:
- Consolidation chart of accounts
- Reporting item hierarchy
- Reporting rule variant
- Confirm that the reporting rules include FS items and other selection criteria for which consolidation data exists.
- Choose Replicate Reporting Rules button.
- Confirm that replication completes successfully.
- Close and reopen Group Data Analysis – With Reporting Rules.
- Execute the query again.
- Retest the Profit & Loss (Function of Expense) section in the Group Financial Statements Review Booklet.
After successful replication, the analytical query and the Review Booklet should return the reporting-rule results.
Additional Information
Before replication, verify that:
- The reporting item hierarchy is active.
- The reporting rule variant contains the relevant FS-item selections.
- The source data satisfies all rule criteria, including any subitem, document type, consolidation unit, or other restrictions.
- The reporting rule version is correctly assigned to the consolidation version for the relevant fiscal year and period.
See Also
KBA 3443298 - Group Data Analysis with Reporting Rules - "Execution of operation REPRULE failed"
SAP Community - Warning "Result set for query 2CCSRPT40Q is empty" in app Group Data Analysis - Reporting Rules
- SAP Help Portal - How to Create Reporting Rules
- SAP Help Portal - Example: Create Reporting Rules and Use Them in Reports
Keywords
group financial statements review booklet, profit and loss function of expense, no data, reporting rules, replicate reporting rules, group data analysis with reporting rules, 2CCSRPT40Q, empty result set, consolidation, reporting item hierarchy, reporting rule variant, coa, embedded analytics, group reporting, booklet runtime , KBA , FIN-CS-EA-2CL , Embedded Analytics for S/4Hana Finance for Group Reporting , Problem
SAP Knowledge Base Article - Public