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
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.
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
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.
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 .
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
You need the extractor and parameter names, to change extractor settings in Extractor Framework management. They are in the table ASR Profiles
Make Configuration Settings in BI Diagnostic Center
To make settings in the BI Diagnostic Center
, proceed as follows:
In the navigation bar of the SAP Solution Manager Administration
work center, choose Infrastructure
, and BI Reporting
.
In the table Analysis Scenarios
, select the scenario System Analyses
, and Scenario Setup
.
Go to change mode by choosing Disply/Change
.
The settings are in the Data Collection Settings
tab. In the Hierarchy
drop-down list, select the default setting System/Category/File Name
.
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
.
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.
Repeat the last two steps until you have made all changes, and save them with Save and Execute
.
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.
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:
In the SAP Solution Manager Administration
work center navigation bar, choose Infrastructure
, and .
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*
).
The extractors for all managed ABAP systems for which data of the ASR profile are collected, are shown. Select the extractor of the system.
In the Selected Extractor
subscreen under Extractor Overview
, choose the Extractor Detail
and Configuration
tabs.
Go to change mode by choosing (Display <-> Change
).
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
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.
Set the parameters for the configuration settings, and save your changes with Save
.
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)