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.
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:
First, the data is read by the extractor and stored in the PSA tables in BI (execution of an InfoPackage).
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).
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 |
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 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 |