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:
Create the query
Wrap the query in a Web Template
Include the new Web Template in IT Performance Reporting
Step 1: Creating the Query
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.
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.
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):
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
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.
Drag the desired key figures, which you want to display in the query, into the Columns area.
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:
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.
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).
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
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.
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
To create the connection between the query and the Web Template, proceed as follows (refer to the screenshots):
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.
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
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).
In the navigation bar, choose the InfoProvider entry from the Modeling area.
In the displayed InfoProviders, expand the path Computing Center Management System --> Report, and right-click the Report entry to display the context menu.
Choose Maintain Master Data, and execute the selection on the selection screen without entering additional data on the screen.
A list of the elements of a dropdown list box appears. This dropdown list box is displayed when you call the IT Performance Reports.
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.
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:
18 Comments