Show TOC

CCMS: DataSource for ABAP Statistics Locate this document in the navigation structure

: 0CCMS_ASR_DATA

 

Note Note

This DataSource is the successor of CCMS: DataSource for ABAP Statistics (Alternative) and should always be used if aggregated statistics data but no individual statistics records are to be stored in BI. Even if you use this DataSource, you can continue to access individual statistics records by RemoteCube using the DataSource 0CCMS_WEBAS_STATREC_DATA.

End of the note.

This DataSource transfers the ABAP statistics data from the source systems that are defined in the monitoring infrastructure.

The statistics data is read directly from the STAT statistics files in the file system of the instance host. The data is aggregated in the extractor, which is significantly more efficient than aggregation during the transformations in BI, as is done in the DataSource 0CCMS_WEBAS_STATREC_DATA.

Background

The DataSource is based on a DataSource type that was newly-developed for SAP NetWeaver 7.0. This type allows the transfer of segmented data, that is, the rows of the data table transferred to the BI interface contain subtables themselves. On the BI side, there is a separate PSA table for each subtable.

The data is loaded in two steps:

  1. First, the data is read by the extractor and stored in the PSA tables in BI (execution of an InfoPackage).

  2. Then the data is written to the target InfoProvider by starting a data transfer process (DTP) for each target. A DTP uses transformation routines (these are part of the BI_CONT delivery) that format the data from the PSA tables for storage in the target InfoProviders.

It is useful to combine the data load steps (that is, an InfoPackage for each DataSource and a DTP for each data target) into process chains. These process chains should also contain a step for the reorganization of the PSA tables, which deletes successfully processes requests from the PSA tables. The ABAP transaction CCMSBISETUP exists for this purpose. This transaction must be started in the BI system. It installs and configures the DataSources, the most important InfoProviders, and the data flow largely automatically. Use this transaction for the initial setup, since a manual installation and configuration is very laborious and requires advanced expert knowledge (more information: Configuring the BI Integration of CPH and Statistics Data).

Technical Data

Application Component

System Performance and Statistics Reporting (BW-BCT-CMS)

Available as of Release

7.03 SPS 05

Shipment

2005.1 7.00 SPS11

Content Versions

There are no content versions.

RemoteCube-Capable

No

Delta-Capable

Yes

Extraction from Archives

No

Verifiable

No

Data Modeling

Delta Update

This DataSource does not use the delta queue, but instead has its own delta management. The assigned InfoPackage has the selection field UPDATE_MODE for this purpose. Only if this flag is set is a full update performed when loading the data from the source system. If the flag is not set, only a delta update is ever performed.

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

MAINREC_SEGM

Statistics main record segment

SWNCGLSTATREC

MAINREC

CLIENTINFO_SEGM

Client info statistics subrecord segment

SWNCGLSTATREC

CLIENTINFO

DB_SEGM

Database statistics subrecord segment

SWNCGLSTATREC

DBRECS

BATCH_SEGM

Background processing statistics subrecord segment

SWNCGLSTATREC

BATCHSTEP

RFCCLI_SEGM

RFC client statistics subrecord segment

SWNCGLSTATREC

RFCCLIENT

RFCCLIDST_SEGM

RFC client destination statistics subrecord segment

SWNCGLSTATREC

RFCCLIDEST

RFCSRV_SEGM

RFC server statistics subrecord segment

SWNCGLSTATREC

RFCSERVER

RFCSRVDST_SEGM

RFC server destination statistics subrecord segment

SWNCGLSTATREC

RFCSRVDEST

SPOOL_SEGM

Spool statistics subrecord segment

SWNCGLSTATREC

SPOOLPRINT

SPOOL_ACT_SEGM

Spool activity statistics subrecord segment

SWNCGLSTATREC

SPOOLACTIV

TAB_SEGM

Table statistics subrecord segment

SWNCGLSTATREC

TABLERECS

APPL_SEGM

Application statistics record segment

SWNCGLSTATREC

ASTATRECS

ADM_SEGM

Administration statistics subrecord segment

SWNCGLSTATREC

ADMMSG

DBPROC_SEGM

Database procedure statistics subrecord segment

SWNCGLSTATREC

DBPROCED

VMC_SEGM

VM Container statistics subrecord segment

SWNCGLSTATREC

VMC

HTTPCLI_SEGM

HTTP client statistics subrecord segment

SWNCGLSTATREC

HTTPCRECS

HTTPCLIDST_SEGM

HTTP client destination statistics subrecord segment

SWNCGLSTATREC

HTTPCDRECS

HTTPSRV_SEGM

HTTP server statistics subrecord segment

SWNCGLSTATREC

HTTPSRECS

HTTPSRVDST_SEGM

HTTP server destination statistics subrecord segment

SWNCGLSTATREC

HTTPSDRECS

SMTPCLI_SEGM

SMTP client statistics subrecord segment

SWNCGLSTATREC

SMTPCLIENT

SMTPCLIDST_SEGM

SMTP client destination statistics subrecord segment

SWNCGLSTATREC

SMTPCLIENTD

SMTPSRV_SEGM

SMTP server statistics subrecord segment

SWNCGLSTATREC

SMTPSERVER

SMTPSRVDST_SEGM

SMTP server destination statistics subrecord segment

SWNCGLSTATREC

SMTPSERVERD