Show TOC

Background documentationGetting ABAP Statistics Data for Reporting Applications

 

The Extractor Framework (EFWK) gets the interactive reporting and other BW-based reporting application 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) and for the central determination of the ABAP statistics data.

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.

    Note Note

    The extractors all run in the SAP Solution Manager system to determine ABAP statistics data. These extractors call an API in each managed system.

    End of the note.
  • 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).

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.

The main extractor E2E_LUW_ME_CORE_SSR gets the ABAP statistics data. The following calls are made:

  • The main extractor, which calls the primary extractor E2E_LUW_PRIMARY_EXTRACTOR_SSR, is started for each managed system. This calls the API (function module /SDF/ASR_READ_AGGR) for determining the statistics data, in the managed system.

    Note Note

    You can see the RFC destination used, in the table E2E_ACTIVE_WLI, in transaction SE16, with the following filter settings:

    Column

    Filter value

    MAINEXTRACTOR

    E2E_LUW_ME_CORE_SSR

    SID

    <managed system ID>

    SYSTEM_TYPE

    ABAP

    The RFC destination is output in the column SOURCERFCDEST. Set this destination in the SAP Solution Manager Configuration (transaction SOLMAN_SETUP) in Start of the navigation path Managed System Configuration Next navigation step Connect Managed System End of the navigation path, under RFC Read Access.

    Because of the high data volume, only aggregates of statistics records are read, not individual records.

    End of the note.
  • Various secondary extractors are then called per main extractor. They have the naming convention E2E_LUW_ECL_<Profil>. The profile is a statistics data subject area, which are oriented mainly on the system load monitor analysis views (transaction ST03), e.g. Time Profile (Extended) (0CCMSATPH).

The SAP Solution Manager Administration work center contains the Extractor Framework, a tool to monitor EFWK. Proceed as follows:

  1. Start the extractor framwork in the SAP Solution Manager Administration work center, by choosing Start of the navigation path Infrastructure Next navigation step Framework Next navigation step Extractor Framwork End of the navigation path.

  2. To display the extractors for getting the ABAP statistics data, filter in the Extractor Overview for extractors with the name WORKLOAD ANALYSIS (Statistical Records LUW).

  3. There is one entry per managed ABAP system. Choose one of them.

  4. The extractor runs are output in the group box Selected Extractor, in the Extractor Log tab. Choose an extractor run.

  5. In the table Extractor Phases, status, runtime and number of data records processed for the primary extractor (E2E_LUW_PRIMARY_EXTRACTOR_SSR) and the various secondary extractors (E2E_LUW_SECONDAR_EXTRACTOR_SSR) are output.

Note Note

The EFWK administration tool displays the information of the table E2E_ACTIVE_WLI, enriched with further information. Depending on the query, and technical knowledge, it can be better to use transaction se16.

End of the note.

Passing ABAP Statistics Data in Business Warehouse contains a description of the further processing of the ABAP statistics data in BW.