Improve Your CO-PA Report Response Speeds by Summarizing Your Users' Data

  • by Tony Rogan, Consultant, SAP America
  • April 15, 2002
When executing your ABAP reports, "summarization levels" - an additional set of tables defined in the CO-PA configuration and stored separately from segment level tables and that have their own subset of data - offer you a chance to add one or more layers to the data retrieval pyramid that will be used by COP-PA's report program. The idea is that the higher up the pyramid, the faster the data can be retrieved. After an explanation of what summarization levels are, this article points out the impact (both pro and con) they could have on your end users and gives you some advisory tips on how to develop a sound summarization level strategy for your organization by analyzing the reports you plan to create, the allocations you expect to develop, and any planning functions you might want to use to access your summarization levels.

Summarization levels are special summary tables that contain only the specific characteristics that are needed by your report(s). The concept behind summarization levels is to offer you a chance to increase performance by adding one or more layers onto the data retrieval pyramid that CO-PA’s report program is going to use when executing your reports.

As you see in Figure 1, one tradeoff of this increased reporting performance is the level of detail available to the report reader — the higher up the pyramid, the faster the data retrieval … but the smaller the amount of detail.

Better response time is the obvious benefit of using summarization levels. But are there any other tradeoffs that would impact users and therefore need to be taken into consideration? I’ll answer that question here, and then show you five quick tips on how you should approach the task of designing summarization levels for your organization.

Tony Rogan

Tony Rogan is a certified FI/CO consultant at SAP with eight years of SAP consulting experience. He began his SAP career with a Big 5 consulting firm and over the years has worked in various industries, including utilities, non-profit, high-tech, consumer goods, and process manufacturing. Tony’s expertise lies in the Financial and Controlling modules, with emphasis on Cost Center Accounting, Profitability Analysis, Internal Orders, Profit Center Accounting, Special Purpose Ledger, Project Systems, and Product Costing. He also has experience working with Enterprise Consolidations, LIS, and Business Information Warehouse.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.