SAP Note 1748700 - SAP HANA: Report Writer connection

Symptom
This SAP Note enhances the database selection during the execution of Report Painter and Report Writer reports in such a way that the SAP HANA database can be accessed.
There are two different scenarios here:
  • Side-side scenario (accelerator), where a selection from the outsourced SAP HANA database was enabled: The prerequisite for this is activating the required Customizing in transaction HDBC for the applications that support the accelerator and regenerating all reports of the reporting table of these applications.
  • Suite on SAP HANA, where an optimization of the field list was required only for CO reports (for the reporting table CCSS): Here, it is ensured that only the fields that are defined in the executed report are used in the field list for the selection. For report groups with several reports, all fields from all reports are used in the field list.
    In other areas, no optimization of the field list was required because only the fields from the defined report were used for the field list.
Other terms
REPORTWRITER, SGRW_PERFORMANCE, SAP HANA
Reason and Prerequisites
You want to improve the system performance.
Note that an improved performance depends on the general configuration, data volume and data configuration. For small data volumes, for which the Report Painter reports and Report Writer reports only require seconds for the execution anyway, you may not notice a big difference with SAP HANA.
The strength of SAP HANA can be seen with larger data volumes.
Solution
Implement this SAP Note in your system.
Note that you have to regenerate the reports each time after you activate or deactivate the Report Writer accelerator.
Proceed as described in the attached instructions for the manual post-implementation steps.




------------------------------------------------------------------------
|Manual Post-Implement.                                                |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   SAP_APPL                      SAP Application   |
| Release 600          SAPKH60001 - SAPKH60022                         |
| Release 602          Until SAPKH60212                                |
| Release 603          Until SAPKH60311                                |
| Release 604          SAPKH60401 - SAPKH60412                         |
| Release 605          Until SAPKH60509                                |
| Release 606          SAPKH60601 - SAPKH60605                         |
------------------------------------------------------------------------

Caution: You have to perform this manual post-implementation step manually and separately in each system after you have imported the Note to implement.
    1. Regenerate all report groups:
      a) Call transaction GR55. In the menu, choose "Utilities -> Mass generator".
      b) To prevent the program from running too long, you can restrict the selection of the report groups to be regenerated using the "Table" field.
                       For example, select CCSS from the list in the "Table" field and set the "Generate w/o selection list" indicator.
      c) In the menu, choose "Program -> Execute in Background".
      d) Repeat steps b) and c) for other tables.
              Alternative:
      a) Call transaction SA38 and enter the program RGRJBG00.
      b) in the "Table" field, select CCSS from the list and set the "Generate w/o selection list" indicator.
      c) In the menu, choose "Program -> Execute in Background".
      d) Repeat steps b) and c) for other tables.
Tags: SAP Note 1748700 - SAP HANA: Report Writer connection,
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved