Displaying Your Own Queries in the IT Performance Reporting

You can use IT Performance Reporting (part of the System Monitoring Work Center in SAP Solution Manager, available as of SAP Solution Manager 7.0 SP15) to centrally display the development over time of the most important monitoring data for your monitored systems. This means that you can identify potential problems early, and obtain an overview of the utilization and performance of your systems. We provide a set of predefined reports for this purpose (more information: http://help.sap.com/saphelp_sm40/helpdata/en/47/6595864609500de10000000a421937/frameset.htm). Of course, you already know all of this. What could be new to you, however, is that you can also integrate your own reports into IT Performance Reporting to determine yourself which data is to be displayed, and how it is to be displayed. This is the topic of this blog post.

To do this, you only need to be a little familiar with the operation of BEx Query Designer and BEx Web Applications Designer to be able to perform all of the steps quickly and easily You integrate your own queries in three steps:

1.

Create the query
2.

Wrap the query in a Web Template
3.

Include the new Web Template in IT Performance Reporting

Step 1: Creating the Query

1.

Start BEx Query Designer (Release 3.5), and log on to your SAP Solution Manager system; documentation for operating the Query Designer is available at: http://help.sap.com/saphelp_nw04/helpdata/en/9d/76563cc368b60fe10000000a114084/frameset.htm.
2.

Create a new query. Choose the appropriate MultiCube from the following, depending on your desired data source:
*

If you want to create a query for CCMS monitoring data, choose Computing Center Management System --> Monitoring Performance Data --> CPH Performance Data (All Resolutions without Online Data) (technical name 0CPH_NALL).
*

If you want to create a query for ABAP statistics data, choose Computing Center Management System --> Statistics Data --> WebAS Kernel --> Aggregates --> Time Profiles (technical name 0CCMSMTPH); this MultiCube is used in the example screenshots below.

image
3.

Irrespective of the details of your query, use the following dimensions in the query and drag them into the specified area:
*

For queries for CCMS monitoring data:

Dimension


Technical Name


Area

Time --> Calendar Year/Month


0CALMONTH


Rows

Time --> Calendar Year/Week


0CALWEEK


Rows

Time --> Calendar Day


0CALDAY


Rows

Time, Time Slots, and Time Zone --> Time


0TIME


Rows

Aggregation Type and Resolution --> Aggre. Type


0CCM_ATYP


Free Characteristics

Aggregation Type and Resolution --> Time Resolution


0CCM_RES


Free Characteristics

MTE --> System Name


0CCM_SYS


Rows, Columns, or Free Characteristics
*

For queries for ABAP statistics data (refer to screenshot):

image

Dimension


Technical Name


Area

Time --> Calendar Year/Month


0CALMONTH


Rows

Time --> Calendar Year/Week


0CALWEEK


Rows

Time --> Calendar Day


0CALDAY


Rows

Time --> Time Range


0CCMMATIRA


Rows

Instance --> Server


0CCMAPSRV


Free Characteristics

Period Type --> Period Type


0CCMPTYP


Free Characteristics

System and Landscape --> System ID


0SMD_LSID


Rows, Columns, or Free Characteristics
4.

Restrict the dimension System ID to the systems that you want to have displayed in SAP Solution Manager. To do this, choose Restrict from the context menu, and drag the entry Systems with Solution Manager Authorizations from the Variables tab page into the selection on the right.

image
5.

Drag the desired key figures, which you want to display in the query, into the Columns area.

image

For queries that are to display CCMS monitoring data, you need to think outside the box a little. This is because the CCMS represents a semantic-free data model; the meaning of the key figures is defined by the attributes of the characteristics:
1.

From the key figures, select the type of values that you want to display, such as the average value from the Calculated Key Figures. However, by doing so, you have not yet decided which MTE classes you want to display.
2.

To define the MTE class, select the entry MTE --> Attribute MTE Class --> Values from the dimensions, and drag the desired MTE class into the Filter area, or (for example, if you want to display multiple MTE classes in a query) into the Columns area (for an example, refer to the screenshot).

image
6.

Save your query, entering a description and the technical name. The technical name should start with Z, so that the query is in the customer namespace.

Step 2: Wrapping the Query in a Web Template

1.

Start BEx Web Application Designer (Release 3.5), and log on to your SAP Solution Manager system; documentation for the operation of the Web Application Designer is available at: http://help.sap.com/saphelp_nw04/helpdata/en/a9/71563c3f65b318e10000000a114084/frameset.htm.
2.

When creating your own Web template, you are largely unrestricted. In this case, we are creating only a simple wrapper of the query created above, as an example. From the Web Items, drag the following Standard Items into the template:
* Chart
* Generic Navigation Block

image
3.

To create the connection between the query and the Web Template, proceed as follows (refer to the screenshots):

image
*

In the properties (General) of your Chart, specify the query you created above. You can leave the name of the DataProvider unchanged (DATAPROVIDER_1).
*

In the properties (Web Item) of your Generic Navigation Block in the Affected Data Provider, select the data provider that you specified in the previous step.
4.

Save your Web template; the technical name should start with Z, so that the template is in the customer namespace.

Step 3: Including the New Web Template in IT Performance Reporting

1.

You now need to include the new Web Template in the list of IT Performance Reports to be displayed. To do this, start transaction RSA1 in the BI system that is associated with the SAP Solution Manager (usually the Solution Manager system itself).
2.

In the navigation bar, choose the InfoProvider entry from the Modeling area.
3.

In the displayed InfoProviders, expand the path Computing Center Management System --> Report, and right-click the Report entry to display the context menu.

image
4.

Choose Maintain Master Data, and execute the selection on the selection screen without entering additional data on the screen.
5.

A list of the elements of a dropdown list box appears. This dropdown list box is displayed when you call the IT Performance Reports.

image
6.

Generate two new entries in this list, in the following order:

Report


Long Description

[Letter]_00_TITLE


[desired title in dropdown list box]

[Letter]_01_[Web Template]


[desired title in dropdown list box]

Explanation:
*

[Letter] is any letter; the entries created by SAP in this list have a number as a prefix, for differentiation, your entries must start with a letter.
*

[Web Template] is the technical name of the Web template that you created in the second step. This Web template is called if the user chooses the corresponding entry in the dropdown list box.
*

The texts in the Long Description determine the corresponding entries in the dropdown list box.
7.

Save your changes and return to the initial screen of transaction RSA1. Now choose Activate Master Data, and ignore the message that the master data is already active.

You have now performed all steps; the next time that you call the IT Performance Reports, the Web template that you created yourself will appear in the list of available reports:

image