Creating Your Own Queries for Interactive Reporting

You can use Interactive Reporting (in the SAP Solution Manager Technical Monitoring work center) to display the development of the most important monitoring data in your monitored systems, over time, centrally. You can identify potential problems early, and get an overview of the load and performance of your systems. SAP provides a set of pre-defined reports.

You can also put your own reports into interactive reporting, to specify which data is to be displayed, in which format. This procedure explains how you can create queries of this type.

Prerequisites

To create your own reports, you need the applications:

BEx Query Designer
BEx Web Applications Designer

Procedure

To enter your own queries:

Create query
Put query in a web template
Put the new web template in interactive reporting

This procedure describes the first two steps, the creation of the query and the web template.

Step 1: Create Query

Start the BEx Query Designer (release 7.x) and log on to your BW system that is associated with the system of your SAP Solution Manager.
Create a new query. Choose the following MultiCube, depending on the data source:
- For a monitoring data query, choose Computing Center Management System Monitoring Performance Data Performance Data (technical name 0CCMPDATA).
- For an ABAP statistics data query, choose Computing Center Management System Statistics Data Time Profile Time Profile (All Resolutions) (technical name 0CCMAW)
  
  Note
  The time profile is only one of the possible MultiCubes on the basis of which you can create your own queries for ABAP statistics records. Under Computing Center Management System Statistics Data , there are other InfoAreas, all of which have the prefix 0CCMS_ASR for their technical names. In these InfoAreas, there is one MultiCube in each area with the suffix (All Resolutions). Use the appropriate InfoArea for the topic for which you want to create a query, and choose the MultiCube with the suffix (All Resolutions).
  
  End of the note.

Depending on whether your query refers to one or more systems (such as overview reports, see Interactive Reports for Systems - Overview), you must copy attribute variables for certain dimensions in the Attribute Restrictions of your Filter Value Range to ensure that the interactive reporting infrastructure passes correct values to your query:

System Query

Dimension	Technical Name
System and Landscape System ID Characteristic Variables E2E SID Variable	`0SMD_V_SID`
System and Landscape Installation Number Characteristic Variables E2E Installation Number Variable	`0SMD_V_INSNO`
Virtual Attributes Virtual Timestamp Attribute Variables Virtual Timestamp	`0SMDVTST`
Virtual Attributes Virtual Timestamp Attribute Variables Virtual Timestamp Exit	`0SMDVTSTE`

Overview Query

Dimension	Technical Name
System and Landscape System ID Attribute Variables E2E SID Variable (several values)	`0SMD_V_SID_M`
System and Landscape System ID Attribute Variables Pass E2E SID Context	`0SMD_V_SID_CONTEXT`
System and Landscape System ID Attribute Variables E2E SID Context GUID	`0SMD_V_SID_INT`
Virtual Attributes Virtual Timestamp Attribute Variables Virtual Timestamp	`0SMDVTST`
Virtual Attributes Virtual Timestamp Attribute Variables Virtual Timestamp Exit	`0SMDVTSTE`

Note Note

You also need to restrict the characteristic restriction Virt. Time Stamp to the single value '#'. To do this, right-click this characteristic restriction, choose the Restrict... entry, and move the single value '#' to the selection by selecting the single value and choosing the button .

End of the note.

Copy the following dimensions to the Free Chars of your query:

Dimension	Technical Name
Time CalYear/Month	`0CALMONTH`
Time CalYear/Week	`0CALWEEK`
Time Calendar day	`0CALDAY`
Time Time	`0TIME`
Resolution Date Resolution (or Period Type Date Granularity for queries for ABAP statistics data)	`0SMD_GRDA`
Resolution Time Resolution (or Period Type Time Granularity for queries for ABAP statistics data)	`0SMD_GRTI`
Time Stamp Time (YYYYMMDDSSMM)	`0SMD_TIHM`

Note Note

For queries for ABAP statistics data, also copy the dimension Start of the navigation path Period Type Next navigation step Period Type End of the navigation path (technical name 0CCMTYP) to the Free Chars for your query.

End of the note.

Next, define which data you actually want to display.
- For monitoring data, proceed as follows:
  Copy the dimension Metric Type Type of Key Figure (technical name 0SMD_METY) to the Characteristic Restrictions of your Area for Filter Values. Now select the metric to be displayed by right-clicking this characteristic restriction and choosing the Restrict... entry. Under the individual values, there is a list with technical names of the metrics for which data is available. Move the desired single value to the selection by selecting the single value and choosing .
  
  Different values are stored for each metric; the most important of these is the mean measured value. To define that you want to display this, move the key figure Calculated Key Figures Mean Value to the Columns area.
- For ABAP statistics data, the available metrics of the InfoProvider are listed in its Key Figures. Simply select the metric to be displayed here, and move this to the Columns area.
You have created your own query. Note that the display of the query directly in the BEx Query Designer has nothing to do with the ultimate display in the infrastructure of the interactive reports. To test your query and optimize the report display, you should therefore first include it in interactive reporting in accordance with Displaying Your Own Queries in Interactive Reporting.
Save your query, enter a description and the technical name. The technical name should start with Z, to put the query in the customer namespace.

Note Note

If you have already created your own queries for IT Performance Reporting in the context of SAP Solution Manager 7.0 EhP 1, you can also use these for interactive reporting, if you make the following changes in the query:

Extend the query with the dimension 0SMD_TIHM specified above, and remove the dimension 0SMD_LSID from your query.
Copy the characteristic variables for the specified dimension (as described in point 3 of the above procedure) to the Characteristic Restrictions of your Area for Filter Values.
Save the query with a new name. Note that you can no longer edit a query that you have saved with the BEx Query Designer (release 7.x) with the Query Designer (release 3.5).
To include your changed query in the interactive reporting display, proceed as described in Displaying Your Own Queries in Interactive Reporting.

End of the note.

Step 2: Put query in a web template

Start the BEx Web Application Designer (Release 3.5), and logon to your BW system.
There are few restrictions on the creation of your web templates. Here, for example, is a simple outline query. Drag the following Standard Items into the template, from the Web Items:
- Chart
- Generic navigation block
To connect the query to the web template:
- Enter the query in the (General) Attributes of your Chart. Leave the name of the Data Provider unchanged (DATAPROVIDER_1).
- Choose this data provider, in the (Web Item) attributes of your Generic Navigation Block in Data Provider Influenced.
Save your web template. Its technical name should begin with Z, to put it in customer namespace.

Result

You have created a web template that is suitable for display in interactive reports. To include it in the infrastructure and display of interactive reporting, proceed as described in Adjust Report Display in Interactive Reporting.

Note Note

Note that this procedure only describes the creation of your own query for interactive reporting as an example using a simple query. To optimize a query of this type, your require extensive knowledge of the operation of the BEx Query Designer.

End of the note.