KB6266: How to Programmatically Create Job Priority Mappings Using MicroStrategy SDK 10.x

• Strategy

A job priority mapping is associated with a particular Database Instance. In MicroStrategy Desktop, job priority mappings can be created in the Database Instance editor, in the 'Job Prioritization' tab. Using the MicroStrategy SDK 10.x, job prioritization mappings can be created to map job priorities (High/Med/Low) to job cost, user group, or project, request type or client application type.

A job priority mapping is associated with a particular Database Instance. In Strategy Desktop, job priority mappings can be created in the Database Instance editor, in the 'Job Prioritization' tab.

From this interface, job prioritization mappings can be created to map job priorities (High/Med/Low) to job cost, user group, or project, request type or client application type.

In Strategy SDK 10.x, IDSSJobPriorityMapEntry is the interface used to create new job priority mappings. Job priorities can be mapped to any combination of job cost, user (or user group), project, client application type (e.g., Strategy Desktop, Strategy Web), or request type (e.g., Report request, Element request). The following is a code example showing how to map element requests to high priority.


'High priority requests correspond to any integer from 1 to 332.
'Medium priority requests correspond to an integer from 333 to 666.
'Low priority requests correspond to an integer from 667 to 999.
Private Const m_intPriorityNumHigh As Integer = 332
Private Const m_intPriorityNumMedium As Integer = 333
Private Const m_intPriorityNumLow As Integer = 667

Dim oDBRole as IDSSDBRole
Dim oQueue As IDSSQueue
Dim oJobPriorityMap As IDSSJobPriorityMap
Dim oJobPriorityMapEntry As IDSSJobPriorityMapEntry

Dim oRootFolder as IDSSFolder
Dim oTempFolder as IDSSFolder
Dim oDBRoleFolder as IDSSFolder
Dim oTempDBRole as IDSSDBRole

Dim oServerAdmin as DSSServerAdmin

'For purposes of this example, suppose that we wish
' to modify the Warehouse database instance called
' "Warehouse_VMall".

'Get root of Server configuration object
Set m_objConfiguration = _
 mobjObjectSource.FindObject(m_objSession.DataSource.ConfigurationID, _
 DssTypeConfiguration)
Set oRootFolder = m_objConfiguration.Root

'Get DBRole folder
For Each oTempFolder In oRootFolder
   If oTempFolder.Info.Name = "DBRoles" Then
      Set oDBRoleFolder = oTempFolder
      Exit For
   End If
Next oTempFolder

'Get DBRole called "Warehouse_VMall"
For Each oTempDBRole In oDBRoleFolder
   If oTempDBRole.Info.Name = "Warehouse_VMall" Then
      Set oDBRole = oTempDBRole
      Exit For
   End If
Next oTempDBRole

'Get queue
Set oQueue = oDBRole.Queue

'Get job priority map
Set oJobPriorityMap = oQueue.JobPriorityMap

'Create a new job priority mapping
Set oJobPriorityMapEntry = oJobPriorityMap.Add
oJobPriorityMapEntry.Name = "MyNewMapping"

'Define criteria for new job priority mapping
oJobPriorityMapEntry.RequestType = DssJobRequestTypeElement

'Set priority for jobs meeting criteria
oJobPriorityMapEntry.Priority = m_intPriorityNumHigh

'Save Job Priority Map to Metadata
oDBRole.Info.Save

'Apply new priority mappings without having to restart
' Intelligence Server
Set oServerAdmin = m_objSession.ServerAdmin
oServerAdmin.ApplyRunTimeSettings

In a priority map entry, a single group of multiple criteria can be mapped to a job priority. For example, a job priority map entry can map report requests coming from Strategy Desktop from user 'Administrator' to High priority. Only when all criteria within a job priority map entry are met, is a priority assigned according to that priority map entry. Possible job priority mapping criteria are outlined below:

Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication
Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication
Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication
Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication
Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication
Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication	Rotation is supported now. If the system setting for rotation is on, in annotation mode, users can also rotate the device and the screenshot. Teradata V13.1032-bit Teradata ODBC Driver 13.10.00.09CertifiedFont informationProperty SetsPropertyFont Style: Bold ResultPropertiesFontBoldColorFontColorFont Style: ItalicFontItalicSizeFontSizeFont NameFontNameStrikeoutFontStrikeoutUnderlineFontUnderlineCriterionIDSSJobPriorityMapEntry propertyPossible valuesDatatypeProjectProjectProject IDstringReport CostReportCostLowerLimit ReportCostUpperLimit0-999longUserUserID of user or user groupstringRequest TypeRequestTypeDssJobRequestAnyType DssJobRequestBatchRequest DssJobRequestLastType DssJobRequestTypeDocument DssJobRequestTypeElement DssJobRequestTypeObject DssJobRequestTypeReportEnumDSSJobRequestTypeClient ApplicationApplicationDssApplicationAgent DssApplicationCustom DssApplicationScheduler DssApplicationWebEnumDSSApplication

Each database instance has a priority map. Multiple priority map entries can be created within that priority map. When a job is submitted to a particular database instance, the Strategy Intelligence Server kernel will examine all priority map entries for that database instance. If a job priority map entry is found with criteria that match the properties of the incoming job, then the job is assigned a priority according to that priority map entry. If multiple matching priority map entries are found, then multiple possible job priorities may be mapped to the job. In this case, the highest of all possible priorities are assigned to the job. If no matching priority map entries are found, then the job is assigned the priority specified by the IDSSJobPriorityMap::DefaultPriority property.

The .zip file attached below contains sample code in VB that can be compiled as is. When compiled, the executable can be called from a command line to create job priority mappings for element requests. Please see the readme included in the .zip file for an explanation on how this executable can be used.

ADDITIONAL INFORMATION:
The Strategy SDK allows you to customize several Strategy products and extend and integrate the Strategy business intelligence functionality into other applications. However, before changing the way Strategy products look or behave, it is helpful to understand how the application is built. For more information regarding the Strategy products or the process of customizing Strategy products, please refer to Strategy Developer Zone (https://developer.microstrategy.com).
To access the Strategy Developer Zone, you must have access to the Strategy Knowledge Base, you must have purchased the Strategy SDK, and you must be current on your Strategy maintenance agreement. If you are a US-based business and believe that you satisfy all three of these conditions but you do not have access to the Strategy Developer Zone, please contact Strategy Technical Support at support@microstrategy.com or at (703) 848-8700. If you are an international business, please contact Strategy Technical Support at the appropriate email address or phone number found at https://www.microstrategy.com/us/services/support/contact.
CUSTOMIZATION WARNING:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.

Comment

0 comments

Details

Knowledge Article

Published:

February 6, 2018

Last Updated:

February 6, 2018

'High priority requests correspond to any integer from 1 to 332. 'Medium priority requests correspond to an integer from 333 to 666. 'Low priority requests correspond to an integer from 667 to 999. Private Const m_intPriorityNumHigh As Integer = 332 Private Const m_intPriorityNumMedium As Integer = 333 Private Const m_intPriorityNumLow As Integer = 667 Dim oDBRole as IDSSDBRole Dim oQueue As IDSSQueue Dim oJobPriorityMap As IDSSJobPriorityMap Dim oJobPriorityMapEntry As IDSSJobPriorityMapEntry Dim oRootFolder as IDSSFolder Dim oTempFolder as IDSSFolder Dim oDBRoleFolder as IDSSFolder Dim oTempDBRole as IDSSDBRole Dim oServerAdmin as DSSServerAdmin 'For purposes of this example, suppose that we wish ' to modify the Warehouse database instance called ' "Warehouse_VMall". 'Get root of Server configuration object Set m_objConfiguration = _ mobjObjectSource.FindObject(m_objSession.DataSource.ConfigurationID, _ DssTypeConfiguration) Set oRootFolder = m_objConfiguration.Root 'Get DBRole folder For Each oTempFolder In oRootFolder If oTempFolder.Info.Name = "DBRoles" Then Set oDBRoleFolder = oTempFolder Exit For End If Next oTempFolder 'Get DBRole called "Warehouse_VMall" For Each oTempDBRole In oDBRoleFolder If oTempDBRole.Info.Name = "Warehouse_VMall" Then Set oDBRole = oTempDBRole Exit For End If Next oTempDBRole 'Get queue Set oQueue = oDBRole.Queue 'Get job priority map Set oJobPriorityMap = oQueue.JobPriorityMap 'Create a new job priority mapping Set oJobPriorityMapEntry = oJobPriorityMap.Add oJobPriorityMapEntry.Name = "MyNewMapping" 'Define criteria for new job priority mapping oJobPriorityMapEntry.RequestType = DssJobRequestTypeElement 'Set priority for jobs meeting criteria oJobPriorityMapEntry.Priority = m_intPriorityNumHigh 'Save Job Priority Map to Metadata oDBRole.Info.Save 'Apply new priority mappings without having to restart ' Intelligence Server Set oServerAdmin = m_objSession.ServerAdmin oServerAdmin.ApplyRunTimeSettings