Skip to Content

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

To report this post you need to login first.

18 Comments

You must be Logged on to comment or reply to a post.

  1. Chabier Sanvicente Navarro
    Hi Dirk,
    This blogs was the light to the darkness of this new feature of Solution Manager.

    However, you talk about CPH infocubes that as of EHP1 are not used anymore.

    Do you know the new infocubes that we need to use to create our own reports?

    Thanks a lot!

    (0) 
  2. Anonymous
    Hi,

    I want to get the names of users and the transactions they used in the last month/year. As ST03N data is loaded to cubes, can you please let me know which cube will have this specific data?

    (0) 
    1. Dirk Jenrich Post author
      Hi Mehfil,

      in 0CCMSATPH, you’ll find all the necessary data – tcode, program name, user and client. The cube is included in the multi provider 0CCMSMTPH, which is mentioned in my blog.

      Hope that helps

      Regards
      Dirk

      (0) 
  3. Darwin T. Paglingayen
    Hi,

    Thanks for this blog we were able to adapt the functionality in our system. I have some questions though.

    We have used 0CCMSMTPH as infoprovider to query transaction statistics. When I compare the query results (# of dialog steps, response time etc.)to the values in ST03N, the values are exactly the same for systems with only 1 instance. However, for those systems with application servers, the results in the query is way different from ST03N. When we drill down on it, the results of 1 instance is duplicated in other application servers. Do you have an idea what could be causing this?

    Thank you very much.

    (0) 
    1. Dirk Jenrich Post author
      Hi Darwin,

      thanks for the compliments.

      I asked the responsible developer, and he suggested that you should read SAP note 1368401.

      Hope that helps – kind regards
      Dirk

      (0) 
    1. Dirk Jenrich Post author
      Hi Charly,

      the Query I set up in the blog is just an example how to include your own queries into the IT Performance Reports. This special query contains some performance metrics from ABAP Statistics Records, whereas most of the queries shipped by SAP contains metrics of the CCMS Monitoring Infrastructure.

      Kind regards
      Dirk

      (0) 
  4. Bernd Zucker
    Hello,
    actually we are switching from CCMSBISUITE to EFWK. I thought that the multicube 0CCMSMTPH is filled from old ccmsbisuite.
    We want to define own queries and now i don´t know if the included cubes are filled by EFWK. Where i can find the st03n data delivered by EFWK in BI Content?

    best regards
    Bernd

    (0) 
    1. Dirk Jenrich Post author
      Hi Bernd,

      I just talked to our developers – if you do the setup of the Root Cause Analysis, you’ll receive the data automatically via the EFWK. The multicube 0CCMSMTPH remains the same.

      So it’s even possible you’ll already get the data via the EFWK without noticing.

      Kind regards
      Dirk

      (0) 
  5. Darwin T. Paglingayen
    We have activated IT performance reporting in all our systems Production and Non-production. Is there a way of filtering the display like for example the System Availability to display only Production systems?

    Can we modify the standard template and will it not be overwritten if we apply patches?

    Thanks again for this wonderful blog.

    Regards,
    Darwin

    (0) 
    1. Dirk Jenrich Post author
      Hi Darwin,

      in IT performance reporting, we don’t have a flag whether a system is productive or not. So such a filter is unfortunately not possible.

      About modifying the standard templates – you can do it, and after installing a patch it will not be overwritten.

      BUT… it will be overwritten after activating the Content again, which is recommended after an update. So I think adding your own queries to the list is better than replacing the standard templates.

      Hope that helps
      Dirk

      (0) 
    2. Dirk Jenrich Post author
      Hi Darwin,

      another remark about displaying only your productive systems. As said, in IT Performance Reporting, we don’t has such a flag. But as a workaround, you could edit the query “0SMDRSSYSTEMS”, which is responsible for the content of the dropdown listbox when you choose a system. By default, all systems with reporting data in the BW are displayed, but you can restrict this list.

      To do so, open the context menu for the InfoObject “0SMD_LSID” in the Query Designer, choose “restrict” and move the designated systems into the list in the right-hand side of the window. If your productive systems follow a naming convention (e.g. Pxx), you can even  use wildcards (e.g. P*) in the “Direct Input” field (and then just ignore the warning 🙂 ). Your changes will be valid until a new content activation.

      Kind regards
      Dirk

      (0) 
      1. Darwin T. Paglingayen
        Hi Dirk,

        Thank you very much for the workaround. It is very helpful.

        I do have another issue. When we used 0CCMSATPH and 0CCMSMTPH cubes in our query, it is very very slow and IT Performance Reporting eventually times out. I even used the SAP standard query 0CCMSMTPH/0CCMSRSABAPUSERACTVTY to test it in tcode RSRT and it is also very slow. I checked that the number of entries in the Fact table of 0CCMSATPH (part of the 0CCMSMTPH multi cube)is 251 million records.

        How can we improve performance on this cubes?

        Thank you very much for the help.

        Kind regards,
        Darwin

        (0) 
        1. Dirk Jenrich Post author
          Hi Darwin,

          we know about the problem, but possible solutions or workarounds depend on your usage of the reports and the release of your SAP Solution Manager. I’d suggest that you create a customer message using copmonent BW-BCT-CMS so development can document the problem and possible solutions.

          Kind regards
          Dirk

          (0) 
  6. Fermin Alvarez
    Hi Dirk,
    Thanks for this very useful blog!
    I’ve a question, In the availability query, there is a ‘planned system downtime’ chart; but I’m not sure where is looking for this info: DTM, CCMSPing pauses? So far, I’ve been checking in different places, but it not clear (to me).

    On the other side, just as a feedback, i think it would be very useful to organize the systems with further criteria (as a previous post was asking), in cases where you have dozens of systems it would be nice to select just a solution or something like that.

    Kind regards,
    Fermín

    (0) 
    1. Dirk Jenrich Post author
      Hi Fermin,

      thanks for the feedback and your suggestion, which I’m forwarding to development. If you scroll down, you’ll see at least a workaround for your problem…

      About your question: The “planned system downtime” is coming from Downtime Management. See the following documentation:

      http://help.sap.com/saphelp_sm40/helpdata/en/45/51fbdbd4941803e10000000a1553f7/frameset.htm (SAP Solution Manager 7.0 SP15)

      http://help.sap.com/saphelp_smehp1/helpdata/en/bf/5a62721652477592bf3441cc5ab6ec/frameset.htm (SAP Solution Manager 7.0 EhP1)

      Kind regards
      Dirk

      (0) 

Leave a Reply