Alert Management Reporting in SAP Solution Manager

This dashboard shows the occurrence of alerts in your managed systems. The Alert Management (ALM) dashboard displays metrics such as the number and distribution of alerts, support messages, and the processing times of alerts. You can specify the data display period. The occurrence, distribution, and processing time of alerts tell you about the status and functioning of your managed systems.

You can call the ALM Dashboard from the work center Technical Monitoring, by choosing the Reporting button in the Alert Inbox area.

Note Note

For detailed information about the ALM Dashboard, see Dashboard for Alert Management Reporting.

End of the note.

This BI Content documentation for alert management reporting is intended for users who want to create their own queries or Web templates based on this data.

Data Flow

The Extractor Framework (EFWK) transfers the data from the monitoring and alerting infrastructure to the associated BI of the SAP Solution Manager. Data is written by EFWK jobs directly to the following DSOs:

DSO	Description
`0SMALMDS1`	DSO for Alert Counters (Direct Writes)
`0SMALMDS2`	DSO for Messages Created from Alerts (Direct Writes)
`0SMALMDS3`	DSO for Alerts on Timescale (Direct Writes)

To allow further use of the ALM data, it must be written to a number of InfoCubes. This is done by the job ALM_AGGR_DATA_UPDATE, which runs once a day.

There are two InfoCubes with identical structures (twin Cubes) for each time resolution of the alert data. The data is first written to the first InfoCube of each pair, until the retention period for the relevant resolution is reached. 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. The alert data is stored in the following InfoCubes:

Data	Twin Cubes
Alert Counter for Each Day	0SMALM1D1, 0SMALM1D2
Alert Counter for Each Month	0SMALM1M1, 0SMALM1M2
Alerts on a Timescale per Hour	0SMALM3H1, 0SMALM3H2
Alerts on a Timescale per Day	0SMALM3D1, 0SMALM3D2
Alerts on a Timescale per Month	0SMALM3M1, 0SMALM3M2

Note Note

The data about support messages is not written to twin Cubes, but rather to an InfoCube called Messages Created for Alerts [0SMALM2].

End of the note.

The difference between Alert Counter and Alerts on a Timescale is that with Alert Counter, an alert group is always assigned to the day or month on which the alert group occurred for the first time (even if it stretches over a longer time period), while with Alerts on a Timescale, if an alert group stretches over a longer time period it is assigned to all hours, days, or months of the validity of the alert group.

Since it is undetermined at any particular time which of the twin cubes contains the desired performance data, use the following MultiCubes for your own queries:

MultiCube	Description
`0SMALMMP1`	Alert Counter
`0SMALMMP2`	Messages Created for Alerts
`0SMALMMP3`	Alerts on a Timescale