In BI-based reporting in System and Application Monitoring reporting, history data of monitored metrics is written into the SAP Solution Manager Business Warehouse. The data flow in BW is that the data is first aggregated and written into DataStore objects (DSOs), and then moved from the DSOs into InfoCubes, by jobs. For further information, see Passing and Saving MAI Data in Business Warehouse.
Monitoring and Alerting Infrastructure (MAI) metrics are first written into the two following DSOs:
The DSOs should contain the latest aggregate for each metri. The above jobs delete obsolete aggregates from the DSOs, as well as providing data to the InfoCubes. The agorithms are optimized for performance, not the complete deletion of obsolete data records under all conditions. It is possible, under certain conditions, that obsolete data records could build up in the DSOs, leading to poorer performance and greater memory usage. Such a build-up of obsolete data records could occur, for example, for the following reasons:
The jobs to copy the aggregates from the DSOs and the InfoCubes do not run reliably.
The data provision of the metrics is unreliable.
A lot of once-only metrics are copied into BW, i.e. measured values which are incorrectly interpreted as independent metrics, not as the chronological development of a metric.
In such cases, use this program to reorganize the DSOs, i.e. to delete obsolete data records. The program can calculate how many obsolte data records the DSOs contain, to decide whether they should be reorganized.
If you perform a reorganization for some or all aggregates in this program, the data records for all metrics, up to the latest aggregate, are written into the InfoCubes, and all aggregates in the DSOs whose configured lifetime has been exceeded, are deleted.
To reorganize reporting DSOs, call the transaction MAI_TOOLS. Go to expert mode, and, in the Analysis
tab, choose Reorganization of Reporting DSOs
.
When you call the program, a selection screen appears. If you choose (Execute
) in this screen, without making any other entries, the DSOs for all saved aggregates are reorganized. This is usually the appropriate setting.
You can restrict the aggregates which are reorganized. See the basic principles of aggregation, under Aggregation.
Note
Aggregation
is part of the Central Performance History documentation, one of the predecessor products of interactive reporting. The principles of aggregation, especially its methods (reduction of resolution and combination of intervals) have not changed.
To do so, proceed as follows:
In the field Date Granularity
specify whether to reorganize daily, weekly or monthly values.
In the field Time Granularity
specify whether to reorganize values in daily, weekly or monthly resolution.
The program outputs a DSO reorganization log (see DSO Reorganization Log
below). If you want to check the DSOs for obsolete data records, but not perform the reorganization, set the Only Analyze
flag.
The following data is output for each granularity:
Display | Note |
---|---|
Number of Metrics | There cannot be less data records than metrics in the DSOs, but this difference should be as small as possible. Ideally, all data records except the latest one are deleted for all metrics, every time this job runs, and the number of metrics is the same as the number of data records. In practice, there are usually more data records than metrics, depending on when the analysis is performed; a factor of 2 is unproblematic, but 4 clearly indicates problems. |
Number of data records | |
Metrics with the timestamp of the last measurement in the current period | Obsolete metrics arise in the DSOs mainly in two situations:
Set the lifetime of the aggregates in the SAP Solution Manager Configuration (transaction SOLMAN_SETUP) in the step . |
Metrics with the timestamp of the last measurement in a previous period (not obsolete, still within the lifetime of the aggregate) | |
Obsolete metrics, which are older than the lifetime of the aggregate | |
Obsolete metrics, which are considerably older than the lifetime of the aggregate | |
Number of metrics with at least 50 data records | These values determine whether metrics with more than one or two data records in the DSOs occur often or seldom. |
Number of metrics with at least 10 data records | |
Number of metrics with at least 5 data records | |
Number of metrics with at least 2 data records | |
Number of metrics with at least one data record | |
Number of metrics and data records deleted, or to be deleted (in | |
Number of metrics and data records moved into InfoCubes or to be moved (in | |
Number of invalid metrics or data records, with duplicate keys | If there are metrics with duplicate keys, there is a technical problem. In this case, create a message in component |