Getting MAI Data for Interactive Reporting

The Extractor Framework (EFWK) gets the Interactive Reporting data. The EFWK is the central SAP Solution Manager data collection and distribution infrastructure, and is also used for the End-to-End Monitoring and Alerting Infrastructure (MAI).

The EFWK runs in the SAP Solution Manager system. The Resource Manager, which is called every minute by the job EFWK RESOURCE MANAGER, gets the data. The Resource Manager calls main extractors, which call extractors and the Data Loader. The following values apply:

An extractor is a function module which the main extractor calls by RFC. It can run in the SAP Solution Manager system or the managed systems. The extractor gets the data. The data obtained is often automatically enhanced after the main extractor call.
A data loader is a function module in the BW system associated with the SAP Solution Manager. It writes the data found into the data destination in BW, such as InfoCubes or DataStore objects (DSOs).

This graphic is explained in the accompanying text.

Which main extractors call which extractors and data loaders, how often, is in the table E2E_ACTIVE_WLI. The suffix WLI stands for „Worklist Item“. It contains the Resource Manager worklist, and each row in the table contains an instance of an extractor.

MAI uses a special set of extractors, the Data Provider Connector (DPC). The DPC uses mainly the following two main extractors:

E2E_DPC_PULL_CORE
E2E_DPC_PUSH_CORE

In E2E_DPC_PULL_CORE the extractor framework queries the values of the extractors, actively, regularly. In E2E_DPC_PUSH_CORE agents pass the data to the SAP Solution Manager system, and this main extractor is not called by the resource manager. The extractors belong to the following extractor classes:

Main extractor	Extractor class	Call frequency	Meaning
E2E_DPC_PULL_CORE	ST_PI	5 minutes	These extractors get metrics from the managed systems; depending on how up-to-date the metric must be, it is collected by exactly one of the extractors.
	ST_PI_15	15 minutes
	ST_PI_60	60 minutes
	ST_PI_CLNT<xxx>	5 minutes	These extractors collect metrics of the corresponding client.
	ST	5 minutes	These extractors collect metrics from the SAP Solution Manager system. They are SAP Solution Manager functions or measurement values. Depending on how up-to-date the metric must be, it is collected by exactly one of the extractors.
	ST_15	15 minutes
	ST_60	60 minutes
	ST_BW	5 minutes	These extractors collect aggregate and mean values of Monitoring and Alerting Infrastructure metrics from the BW system; depending on how up-to-date the metric must be, it is collected by exactly one of the extractors.
	ST_BW_15	15 minutes
	ST__BW_60	60 minutes
	ST_DBMS<System-ID>	5 minutes	These extractors collect database metrics.
E2E_DPC_PUSH_CORE	<Hostname>		The data is returned by a diagnostics agent
E2E_DPC_PUSH_CORE	IS_<Hostname>		The data is returned by an Introscope agent

The SAP Solution Manager Administration work center contains two tools to monitor the EFWK function:

Extractor Framework to monitor extractors which do not belong to the DPC
Alerting Framework to monitor extractors which belong to the DPC

Passing and Saving MAI Data in Business Warehouse contains a description of the further processing of the monitoring data in BW.