Data Flow

The Extractor Framework (EFWK) is used to transfer data from the CCMS monitoring infrastructure to the associated BI of the SAP Solution Manager.

Depending on the settings that you made when setting up IT Performance Reporting, the performance data is either transferred from the administered systems themselves or from the central monitoring system. In either case, the data is transferred using the EFWK. No process chains and DataSources are used in this process; the data is writtend directly to a number DSOs by jobs.

This graphic is explained in the accompanying text.

First, the performance data is written to the following DSOs using the Extractor Framework:

DSO	Description
`0CCMTHRS`	Threshold Values for Performance Data (Direct Write)
`0CCMAGGR`	Threshold Values for Performance Data (Direct Write)
`0CCMBUFF`	Buffer for CCMS Performance Data (Direct Write)
`0CCMCURR`	New Performance Data (Direct Write)
`0CCMAVD`	Planned Non-Availability (Direct Write)

To allow further use of the performance data, it must be written to a number of InfoCubes. This is done by the following two jobs:

The job CCMS_CPH_RAW_DATA_UPDATE writes the original data from the DSO 0CCMBUFF to the InfoCubes. It is executed once an hour.
The job CCMS_CPH_AGGR_DATA_UPDATE writes the aggregated data from the DSO 0CCMAGGR to the InfoCubes. It is executed once a day.

There are two InfoCubes with identical structures (twin Cubes) for each time resolution of the performance data. The data is iitially written to the first InfoCube in each case, until the end of retention period for the relevant resolution, as specified in the IT Performance Reporting setup. More data is then written to the second Cube in each case, until the end of the set retention period is reached there, too. The first Cube is then deleted, and the cycle starts again.

Note Note

The IT Performance Reporting setup is described in the Implementation Guide for the SAP Solution Manager under Scenario-Specific Settings System Monitoring Reporting .

End of the note.

Depending on the granularity, the performance data is stored in the following InfoCubes:

Granularity	Twin Cubes
Values in Minute Resoution	0CCMMIN1, 0CCMMIN2
Values in Quarter-Hourly Resolution	0CCMQTR1, 0CCMQTR2
Values in Hourly Resoution	0CCMDAY1, 0CCMDAY2
Weekly Aggregates in Hourly Resolution	0CCMWEEK1, 0CCMWEEK2
Monthly Aggregates in Hourly Resolution	0CCMMNTH1, 0CCMMNTH2

Note Note

More information about the concept of the different aggregates: Aggregation.

End of the note.

Since it is undetermined at any particular time which of the twin cubes contains the desired performance data, use the MultiCube 0CCMPDATA (Performance Data) for your own queries.