Show TOC

Procedure documentationDisplaying Table Statistics Locate this document in the navigation structure

 

To gain an overview of which tables in your system landscape are called and used, you can generate table statistics.

Prerequisites

Note the prerequisites described under Statistics and Trends.

Procedure

To gain an overview of the table usage or call frequency in your system landscape, proceed as follows:

  1. Under Statistics and Trends, select a scenario or system in the table and choose Table Statistics.

  2. Specify the period you want to analyze and whether you want to analyze the information per week or per month.

  3. Specify for which entities in your system landscape you want to carry out the analysis. You can use the following tab pages:

    • Products

    • System

    • Application Area

    • Document Type

    • Table

  4. Select the information you want to display:

    • For the Product tab page, you can display table statistics with respect to the following information:

      • Summary

      • History

    • For the other tab pages, you can also select the Top Accessed information.

  5. Depending on which information you want to display, proceed with one of the following steps:

    1. If, on the Products or System tab page, you choose the Summary option, the system loads the data from the Business Warehouse and generates table statistics.

    2. If you choose a different option, you can refine the analysis, for example, by specifying the system ID of a specific system that you want to analyze.

      When you have made your entries, you have the following options:

      • You can check that your entries are correct.

      • You can display the statistics. The system loads the data from the Business Warehouse and creates the table statistics according to your input parameters.

Result

The system displays a detailed overview of the table statistics, consisting of the following information:

  • Graphical overview of the results

  • Key figures

    You can filter the results by the following key figures:

    • All Key Figures

    • Total Requests

    • Changes

    • Direct Reads

    • Sequential Reads

    • Invalidations

    • Calls

    • Rows affected

  • Conditions

    You can define additional conditions that reduce the overall results to specific information. To do so, choose Create and make the following entries:

    1. Enter a name for the condition and specify whether the condition is to be active by selecting the relevant radio button.

    2. Define which characteristics are to apply for the condition.

    3. You can also refine the condition by specifying additional conditions with operators and the values you require.

    4. Confirm your entries.

      The condition appears as a new row in the table.

    5. You can activate or deactivate existing conditions within the table by choosing the status pushbutton.

  • Navigation block

    You can filter the overall results by specific characteristics and display the results in a table.

  • Tabular overview of the results