Show TOC

Procedure documentationCreating Your Own Queries for Interactive Reporting Locate this document in the navigation structure

 

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:

  1. Create query

  2. Put query in a web template

  3. 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

  1. 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.

  2. 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 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.
  3. 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 certein dimensions, in the Attribute Restrictions of yourFilter 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 Characteristics   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.
  4. 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   Period Type   Period Type   (technical name 0CCMTYP) to the Free Chars for your query.

    End of the note.
  5. 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 hte 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   Calcualted 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.

  6. 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.

  7. 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:

  1. Extend the query with the dimension 0SMD_TIHM specified above, and remove the dimension 0SMD_LSID from your query.

  2. 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.

  3. 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).

  4. 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

  1. Start the BEx Web Application Designer (Release 3.5), and logon to your BW system.

  2. 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

  3. 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.

  4. 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.