EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB8902: How to create a report in MicroStrategy Enterprise Manager that will display each execution step of a job request along with the execution length of each step.

Community Admin

• Strategy

How to create a report in MicroStrategy Enterprise Manager that will display each execution step of a job request along with the execution length of each step.

Perform the following steps to create a report in Strategy Enterprise Manager that will allow the ability to view each step of a job and it's corresponding metrics:
 

  1. Open a new report editor.
  2. Go to the attribute folder for 'Report Job'.
  3. Add the 'Report Job' attribute.
  4. Go to the attribute folder for 'Indicators & Flags' and add the 'Report Job Step Type' attribute instead.
  5. Add the metrics 'RP Queue Duration', 'RP Exec Duration' and 'RP Elapsed Duration'.
     
    Note: Other metrics may be added as needed for specific types of analysis. The metrics chosen above will provide a calculation of the queue duration for each step, the execution duration for each step and the elapsed duration (queue duration + execution duration).
     
  6. Add a time filter as needed. The 'Choose a Time Filter' prompt is used in similar report analysis reports and would be useful in this report.
     
  7. Follow these steps to enable subtotaling which will enhance the analysis of these jobs:
    1. Go to the Data menu and choose 'Subtotals'.
    2. Click on the 'Advanced' tab.
    3. Choose the 'Group by' radio button.
    4. Select 'Report Job'.
    5. Check the 'Grand Total' box.
    6. Click 'OK'.

The final report in design view should appear as follows:
 

ka04W000000Oc4yQAC_0EM440000002BtY.gif

 
The results of the executed report should appear as follows:
 

ka04W000000Oc4yQAC_0EM440000002Bth.jpeg

 
The attribute 'Report Job Step' or 'Report Job Step Type' is based on the statistics logged into the IS_REP_STEP_STATS table and the column StepType. This table is mapped in the data load process to the view IS_REP_STEP_FACT and column IS_REP_STEP_TYP_ID. The lookup table that stores each reference to a job step is IS_REP_STEP_TYPE.
 
The steps and their descriptions from the IS_REP_STEP_TYPE table are as follows:
 
 


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE


This report returns the top 50th percentile of call centers by profit. In other words, the top 50 percent call centers (~8 out of 15)IS_REP_STEP_TYP_IDIS_REP_STEP_TYP_DSC0UNKNOWN1MD OBJECT REQUEST2CLOSE JOB3SQL GENERATION4SQL EXECUTION5ANALYTICAL ENGINE6RESOLUTION SERVER7REPORT NET SERVER8ELEMENT REQUEST9GET REPORT INSTANCE10ERROR MESSAGE SEND11OUTPUT MESSAGE SEND12FIND REPORT CACHE13DOCUMENT EXECUTION14DOCUMENT SEND15UPDATE REPORT CACHE16REQUEST EXECUTE17DATAMART EXECUTE

Note: In order to relate the report job ID for the 'Report Job' attribute to an actual report name, another report will need to be created with the 'Report' attribute and the 'Report Job' attribute. This is because the facts used in this report do not have data at the level to relate 'Report' attribute and 'Report Job Step' attribute.
 
 

Comment

0 comments

Details

Knowledge Article

Published:

May 29, 2017

Last Updated:

May 29, 2017