Symptom
You use a HANA database either as Suite on SAP HANA or as a side-by-side scenario.
The performance of Report Painter and Report Writer reports could still be improved upon.
The performance of Report Painter and Report Writer reports could still be improved upon.
Other Terms
REPORTWRITER, HANA, SGRW_PERFORMANCE, T804E-GEN_SQL
Reason and Prerequisites
This is due to a Customizing setting which is not ideal for SAP HANA.
The type of the selection (field T804E-GEN_SQL) which, by default, is
set to '2' for totals tables (with projection and aggregation) is not
ideal for a selection for a SAP HANA database. The setting '1' (with
projection without aggregation) offers a better performance.
Solution
As a result of the attached correction, the system uses the selection
type '1' for the selection for SAP HANA when the SAP HANA database is
active for totals tables with selection type '2'.
After you implement the correction instructions, all report groups must be regenerated (see also SAP Note 78109).
After you implement the correction instructions, all report groups must be regenerated (see also SAP Note 78109).
No comments:
Post a Comment