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

KB30315: How does the MicroStrategy Intelligence Server determine the priority of a report or document job when multiple job priorities are specified?


Community Admin

• Strategy


How does the MicroStrategy Intelligence Server determine the priority of a report or document job when multiple job priorities are specified?

Users may consider an example where the Job prioritization map for a specific project has the following prioritization map entries:

  1. Priority:HIGH         cost:ALL,  group:X,      project:ALL,  request type:ALL,             application type:ALL
  2. Priority:MEDIUM,  cost:ALL,  group:ALL,   project:ALL,  request type:REPORTS,   application type:SCHEDULER

Users may expect that all reports (whether scheduled or regular interactive execution) for group "X" would be executed with a HIGH job priority against the warehouse, and all other scheduled report executions would execute with a MEDIUM priority.
 
The Intelligence Server behavior however is slightly different from the expected behavior detailed above. To determine job priorities, the Intelligence Server reads the project job prioritization map and determines how many "factors" to match each map entry contains (the ALL value does not count as a specific match factor). When a job is run, the job parameters are matched against the priority factors, and the priority associated with the prioritization entry matching the maximum number of factors is used for the job.
 
For the example above, a scheduled report run by the user of group "X" would run with a priority MEDIUM and not HIGH. This is because the job would match two factors - request type:REPORTS and application type:SCHEDULER.
 
This behavior of the Intelligence Server is designed to be a similar implementation to other Strategy settings, where report level settings can override project level settings. In this implementation, the priority associated with job prioritization map entries for detailed matching factors will override the more generic (less specific) map entries.
 
To make all scheduled and interactive jobs for group "X" run with a high priority, the following priority map entries would need to be defined. This will cause the scheduled report jobs for group "X" to also run with a HIGH priority.

  1. Priority:HIGH,        cost:ALL,   group:X,       project:ALL,  request type:ALL,             application type:ALL
  2. Priority:HIGH,        cost:ALL,   group:X,       project:ALL,  request type:REPORTS,   application type:SCHEDULER
  3. Priority:MEDIUM,   cost:ALL,   group:ALL,   project:ALL,  request type:REPORTS,   application type:SCHEDULER

Comment

0 comments

Details

Knowledge Article

Published:

April 11, 2017

Last Updated:

April 11, 2017