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

KB32148: How is the column IS_REP_EXEC_TM_MS of the MicroStrategt Enterprise Manager warehouse table IS_REP_FACT calculated ?


Community Admin

• Strategy


MicroStrategy Enterprise Manager warehouse table IS_REP_FACT contains information about report job executions. 

Strategy Enterprise Manager warehouse table IS_REP_FACT contains information about report job executions. 
 
Some of the columns of this table are the following: 

  • IS_REP_EXEC_ST_TS - Timestamp of the execution start.
  • IS_REP_EXEC_FN_TS - Timestamp of the execution finish.
  • IS_REP_QU_TM_MS - Queue duration in milliseconds.
  • IS_REP_EXEC_TM_MS - Execution duration in milliseconds.
  • IS_REP_ELAPS_TM_MS - Difference between start time and finish time; includes time for prompt responses.

IS_REP_EXEC_TM_MS column is the difference between IS_REP_ELAPS_TM_MS (elapsed time) and IS_REP_QU_TM_MS (queue time).
 
And, IS_REP_ELAPS_TM_MS column is the difference between IS_REP_EXEC_ST_TS and IS_REP_EXEC_FN_TS.


Comment

0 comments

Details

Knowledge Article

Published:

April 25, 2017

Last Updated:

April 25, 2017