Show TOC

Procedure documentationChange ASR Aggregate Extraction Settings

 

Use this procedure if you have problems with BW-based reports which are based on ABAP statistics data (ASRs) because of high data volume (see Troubleshooting for BW-Based Reporting of ABAP Statistics Data). This procedure tells you how to change configuration settings to reduce the data volume.

Note Note

The Extractor Framework (EFWK) loads ASRs from managed systems. A set of extractors is scheduled for each system:

  • Primary extractor (Extractor ID E2E_LUW_PRIMARY_EXTRACTOR_SSR, WORKLOAD ANALYSIS (Statistical Records Primary Extractor)).

    This extractor reads all (already aggregated) data from a managed system. The data is buffered in the main memory of the SAP Solution Manager system.

  • Secondary extractor (Extractor ID E2E_LUW_SECONDAR_EXTRACTOR_SSR, WA (STATISTICAL RECORDS SECONDARY ...))

    This extractor, which exists once per aggregate, reads the aggregate from the buffer and forwards it to the data destination in BW.

  • CORE Extractor (MAIN Extractor ID E2E_LUW_ME_CORE_SSR, WORKLOAD ANALYSIS (Statistical Records LUW))

    This extractor controls the primary and secondary extractors.

The ASR data collected by these extractors depends on their settings. The settings are saved in the system as an XML string. The settings can be managed-system-specific.

End of the note.

Prerequisites

You have checked the tables in which the ASRs are stored in BW (see Check Table Size and Structure of ASR Aggregates), and have determined, with the program SMBI_ASR_BW_ANALYZE, which profiles, dimensions and managed ABAP systems have the largest data volume.

Note Note

ASR reports are not reliable if aggregation information which is in the default configuration, is discarded. Check whether you need affected reports, before you change the extraction parameters.

End of the note.

Procedure

If you know which profile, dimension and managed system data you do not need, to reduce the data volume of stored ASRs, check the profile in the table ASR Profiles, by following the link in the profile.

The settings to save the aggregates for the profile for each dimension tell you how to activate and deactivate saving this dimension. They also tell you which info objects (which information) is no longer saved, and is no longer available for reports, if you disactivate this dimension.

There are two tool to make configuration settings:

  • BI Diagnostic Center

    To call this application, in the navigation bar of the SAP Solution Manager Administration work center, choose Infrastructure, and BI Reporting.

    SAP recommends making configuration settings with this application, to activate or deactivate data collection for a profile dimension. In the documentation of the memory settings for aggregates of ASR profiles, these are the configuration settings for which the column BI Diagnostic Center Setting is filled.

  • Extractor Framework Management

    Use Extractor Framework manager to change configuration settings if the BI Diagnostic Center Setting column is not filled in the dimension documentation.

    To call this application, in the navigation bar of the SAP Solution Manager Administration work center, choose Infrastructure, and Start of the navigation path Framework Next navigation step Extractor Framework End of the navigation path.

    Configuration settings are technically extractor settings whose configuration is determined by the contents of an XML string. You change the contents of this XML string for the extractor of the profile directly in Extractor Framework management.

    Note Note

    You need the extractor and parameter names, to change extractor settings in Extractor Framework management. They are in the table ASR Profiles

    End of the note.

Make Configuration Settings in BI Diagnostic Center

To make settings in the BI Diagnostic Center, proceed as follows:

  1. In the navigation bar of the SAP Solution Manager Administration work center, choose Infrastructure, and BI Reporting.

  2. In the table Analysis Scenarios, select the scenario System Analyses, and Scenario Setup.

  3. Go to change mode by choosing Disply/Change.

  4. The settings are in the Data Collection Settings tab. In the Hierarchy drop-down list, select the default setting System/Category/File Name.

  5. To change the settings for a managed system, expand the ABAP system in the list, and in the Statistical Data Records (ABAP) row, choose Expert Settings.

  6. A selection of ASR profiles is displayed below the selected row. Expand the profile. You can set selection boxes for each profile, to prevent data collection for this dimension for this system.

  7. Repeat the last two steps until you have made all changes, and save them with Save and Execute.

    Note Note

    Deactivating hourly granularity (Activate/Deactivate Hourly Resolution) reduces the data volume for this granularity by a factor of up to 24, but BW reports can then no longer show a short-term history (e.g. data for today or yesterday). Daily, weekly and monthly aggregate data can still be displayed.

    End of the note.

Configuration Settings in Extractor Framework Management

If you can only make the settings in the Extractor Framework Management, ensure that you have the following values:

  • You already know for which profile you want to make changes. Open the documentation for the storage settings of its aggregate, in the table ASR Profiles. You need the name of the extractor (e.g. WA (STATISTICAL RECORDS SECONDARY EXTRACTOR-0CCMARSDH)) for the profile RFC Server Destination. Use the technical ID after the hyphen (e.g. 0CCMARSDH).

  • You also need the system ID of the managed ABAP system.

  • You already know for which dimension of the profile you want to make changes. You can determine the Parameter Name whose value you must change to activate or deactivate this Dimension in the aggregates, in the documentation.

Proceed as follows:

  1. In the SAP Solution Manager Administration work center navigation bar, choose Infrastructure, and Start of the navigation path Framework Next navigation step Extractor Framework End of the navigation path.

  2. The Extractor Overview table lists the extractors. To show the extractor whose settings you want to change, filter by its technical ID (e.g. *0CCMARSDH*).

  3. The extractors for all managed ABAP systems for which data of the ASR profile are collected, are shown. Select the extractor of the system.

  4. In the Selected Extractorsubscreen under Extractor Overview, choose the Extractor Detail and Configuration tabs.

  5. Go to change mode by choosing Display <-> Change (Display <-> Change).

  6. The XML string is output in the Additional Configuration group box. The extractor settings are in the <Configuration> tag, as XML tags. These tags have the following format:

    <ConfigItem Parameter="*param*" Value="*val*"/>

    *param* is the parameter name, and *val* its value. The value is ‘ ’ (space) or X, depending on whether data is to be collected for the parameter dimension.

    Example Example

    • To deactivate hourly resolution for an RFC profile, set the the tag <ConfigItem Parameter="RFC_WITH_HOURS" Value=" "/>.

    • To deactivate saving users for an RFC server profile, set the the tag <ConfigItem Parameter="RFC_SRV_NO_USER" Value="X"/>.

    Set the parameter values by adding or changing tags.

    End of the example.
  7. Set the parameters for the configuration settings, and save your changes with Save.

    Note Note

    Deactivating application component information (Activate/Deactivate Component Data) does not reduce the data volume, but it can speed up the extractor considerably (see SAP Note 1755296)

    End of the note.