SAP Note 21773 - Performance in Reporting (Summarization data)

Symptom:

Long runtimes in CO PA Reporting. Reports terminate when they are run online because runtime is exceeded. In some cases, reports can no longer be executed in the background in an acceptable time, either.

Cause and prerequisites

The new techniques for improving performance in Release 2.2 are not being used to full effect.

Solution

In Release 2.2E, the documentation was substantially improved.

Users of Releases 2.2C and 2.2D currently do not have access to this information, and therefore cannot exhaust all the activity reserves of Reporting in CO-PA.

A detailed note has been written to serve as an interim solution. The note deals with the following subjects:

• Database access in CO-PA

• Summarization data

• Description of the delta read method

• Possible settings in the report definition

In addition, a detailed case study demonstrates how to use the new techniques.

The target groups for the note are consultants, application managers and advanced users who want to define their own reports.
The note is available exclusively as a Word for Windows 6.0 document because of the graphics contained in it.

Customers can download the note by X.25 and FTP from the server sapserv3 (binary transfer mode!). The German and English versions are stored under the paths
/dist/permanent/Note.0021773/h21773dt.doc (German)
and /dist/permanent/Note.0021773/n21773en.doc (English).

Internally at SAP, the note can also be accessed as an attachment to the document COPAPERFBW in the shared folders
INFOS R/3 --> CO --> D:NEWS:R3/RK
and PROJECTS --> RW-DEV --> D:PROJ:CO-DS

in MLP. The main document contains information on the current changes to the Word documents.
Warning! You should integrate the following notes in your R/3 System (up to and including Release 2.2D):
12505 CO-PA: Extent overflow in the cluster table COIX
18759 Deleting report data --> COIX overflows
18976 Drill-down reporting: RKEBATCH delta read method
22027 Performance: delta read method under ORACLE
22034 Performance: delta read method under ADABAS

Additional key words

Drill-down reporting, Executing reports, KE30, Report definition, KE31, Summarization data, Data buffering, Delta read method, Frozen data, Report data, RKEBATCH, COIX