Κύβος στοιχείων εργασίας του Service Manager

SystemCenterWorkItemsCube (SystemCenterCube)

Element properties:

CustomMDXSystemCenterWorkItemsCubeMDX

Cube Localization:

SLAInstanceInformationΠληροφορίες παρουσίας SLAΠληροφορίες παρουσίας SLA
SLAConfigurationHasMetricΗ ρύθμιση παραμέτρων SLA έχει μετρικήΗ ρύθμιση παραμέτρων SLA έχει μετρική
SLAConfigurationHasCalendarΗ ρύθμιση παραμέτρων SLA έχει ημερολόγιοΗ ρύθμιση παραμέτρων SLA έχει ημερολόγιο
WorkItemGroupContainsWorkItemΗ ομάδα στοιχείων εργασίας περιέχει στοιχείο εργασίαςΗ ομάδα στοιχείων εργασίας περιέχει στοιχείο εργασίας
WorkItemIsAboutConfigItemWorkItem Is About ConfigItemWorkItem Is About ConfigItem
WorkItemCreatedByUserΤο στοιχείο εργασίας δημιουργήθηκε από το χρήστηΤο στοιχείο εργασίας δημιουργήθηκε από το χρήστη
WorkItemAssignedToUserΤο στοιχείο εργασίας ανατέθηκε στο χρήστηΤο στοιχείο εργασίας ανατέθηκε στο χρήστη
WorkItemAffectedByUserΤο στοιχείο εργασίας επηρεάζεται από το χρήστηΤο στοιχείο εργασίας επηρεάζεται από το χρήστη
WorkItemRelatesToConfigItemΤο στοιχείο εργασίας σχετίζεται με στοιχείο ρύθμισης παραμέτρωνΤο στοιχείο εργασίας σχετίζεται με στοιχείο ρύθμισης παραμέτρων
WorkItemRelatesToWorkItemΤο στοιχείο εργασίας σχετίζεται με στοιχείο εργασίαςΤο στοιχείο εργασίας σχετίζεται με στοιχείο εργασίας
WorkItemHasBillableTimeΤο στοιχείο εργασίας έχει χρεώσιμο χρόνοΤο στοιχείο εργασίας έχει χρεώσιμο χρόνο
BillableTimeBilledByUserΟ χρεώσιμος χρόνος χρεώθηκε από το χρήστηΟ χρεώσιμος χρόνος χρεώθηκε από το χρήστη
IncidentStatusDurationΔιάρκεια κατάστασης περιστατικούΔιάρκεια κατάστασης περιστατικού
IncidentResolutionByUserΕπίλυση περιστατικού από το χρήστηΕπίλυση περιστατικού από το χρήστη
IncidentPrimaryUserΠρωτεύων χρήστης περιστατικούΠρωτεύων χρήστης περιστατικού
IncidentIsAboutConfigItemIncident Is About Config ItemIncident Is About Config Item
IncidentCreatedByUserΤο περιστατικό δημιουργήθηκε από το χρήστηΤο περιστατικό δημιουργήθηκε από το χρήστη
IncidentAssignedToUserΤο περιστατικό ανατέθηκε στο χρήστηΤο περιστατικό ανατέθηκε στο χρήστη
IncidentAffectedByUserΤο περιστατικό επηρεάζεται από το χρήστηΤο περιστατικό επηρεάζεται από το χρήστη
IncidentRelatesToConfigItemΤο περιστατικό σχετίζεται με στοιχείο ρύθμισης παραμέτρωνΤο περιστατικό σχετίζεται με στοιχείο ρύθμισης παραμέτρων
IncidentRelatesToWorkItemΤο περιστατικό σχετίζεται με στοιχείο εργασίαςΤο περιστατικό σχετίζεται με στοιχείο εργασίας
IncidentHasBillableTimeΤο περιστατικό έχει χρεώσιμο χρόνοΤο περιστατικό έχει χρεώσιμο χρόνο
IncidentRelatesToProblemΤο περιστατικό σχετίζεται με πρόβλημαΤο περιστατικό σχετίζεται με πρόβλημα
IncidentSLAInstanceInformationΠληροφορίες παρουσίας SLA περιστατικούΠληροφορίες παρουσίας SLA περιστατικού
IncidentIsAboutServiceΤο περιστατικό αφορά σε υπηρεσίαΤο περιστατικό αφορά σε υπηρεσία
ProblemResolutionByUserΕπίλυση προβλήματος από το χρήστηΕπίλυση προβλήματος από το χρήστη
ProblemIsAboutConfigItemProblem Is About Config ItemProblem Is About Config Item
ProblemCreatedByUserΤο πρόβλημα δημιουργήθηκε από το χρήστηΤο πρόβλημα δημιουργήθηκε από το χρήστη
ProblemAssignedToUserΤο πρόβλημα ανατέθηκε στο χρήστηΤο πρόβλημα ανατέθηκε στο χρήστη
ProblemAffectedByUserΤο πρόβλημα επηρεάζεται από το χρήστηΤο πρόβλημα επηρεάζεται από το χρήστη
ProblemRelatesToConfigItemΤο πρόβλημα σχετίζεται με στοιχείο ρύθμισης παραμέτρωνΤο πρόβλημα σχετίζεται με στοιχείο ρύθμισης παραμέτρων
ProblemRelatesToWorkItemΤο πρόβλημα σχετίζεται με στοιχείο εργασίαςΤο πρόβλημα σχετίζεται με στοιχείο εργασίας
ProblemHasBillableTimeΤο πρόβλημα έχει χρεώσιμο χρόνοΤο πρόβλημα έχει χρεώσιμο χρόνο
ProblemSLAInstanceInformationΠληροφορίες παρουσίας SLA προβλήματοςΠληροφορίες παρουσίας SLA προβλήματος
ReleaseIsAboutConfigItemRelease Is About Config ItemRelease Is About Config Item
ReleaseCreatedByUserΗ έκδοση δημιουργήθηκε από το χρήστηΗ έκδοση δημιουργήθηκε από το χρήστη
ReleaseAssignedToUserΗ έκδοση ανατέθηκε στο χρήστηΗ έκδοση ανατέθηκε στο χρήστη
ReleaseSLAInstanceInformationΠληροφορίες παρουσίας SLA έκδοσηςΠληροφορίες παρουσίας SLA έκδοσης
WorkItemIsAboutComputerWorkItem Is About ComputerWorkItem Is About Computer
WorkItemIsAboutServiceWorkItem Is About ServiceWorkItem Is About Service
ServiceContainsConfigItemΗ υπηρεσία περιέχει στοιχείο ρύθμισης παραμέτρωνΗ υπηρεσία περιέχει στοιχείο ρύθμισης παραμέτρων
ServiceContainsComputerΗ υπηρεσία περιέχει υπολογιστήΗ υπηρεσία περιέχει υπολογιστή
IncidentsResolvedCountΠλήθος περιστατικών που επιλύθηκανΠλήθος περιστατικών που επιλύθηκαν
IncidentsResolvedWithinTargetResolutionTimeCountΠλήθος περιστατικών που επιλύθηκαν εντός του χρόνου-στόχου επίλυσηςΠλήθος περιστατικών που επιλύθηκαν εντός του χρόνου-στόχου επίλυσης
IncidentsResolutionTimeInHoursSumΆθροισμα χρόνου επίλυσης περιστατικών σε ώρεςΆθροισμα χρόνου επίλυσης περιστατικών σε ώρες
IncidentsPastTargetResolutionTimeCountΠλήθος περιστατικών που έχουν υπερβεί το χρόνο-στόχο επίλυσηςΠλήθος περιστατικών που έχουν υπερβεί το χρόνο-στόχο επίλυσης
ReleasesImplementedOnScheduleCountΠλήθος εκδόσεων που υλοποιήθηκαν όπως είχε προγραμματιστείΠλήθος εκδόσεων που υλοποιήθηκαν όπως είχε προγραμματιστεί
TimeWorkedSumΆθροισμα χρόνου εργασίαςΆθροισμα χρόνου εργασίας

Source Code:

<SystemCenterCube ID="SystemCenterWorkItemsCube">
<MeasureGroups>
<!--SLA Related facts-->
<MeasureGroup ID="SLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="SLAInstanceInformationDateDim"/>
<MeasureGroup ID="SLAConfigurationHasMetric" Fact="SLADWLibrary!SLAConfigurationHasMetricFact" DateDimAlias="SLAConfigurationHasMetricDateDim"/>
<MeasureGroup ID="SLAConfigurationHasCalendar" Fact="SLADWLibrary!SLAConfigurationHasCalendarFact" DateDimAlias="SLAConfigurationHasCalendarDateDim"/>
<!--Workitem Related facts-->
<MeasureGroup ID="WorkItemGroupContainsWorkItem" Fact="DWBase!WorkItemGroupContainsWorkItemFact" DateDimAlias="WorkItemGroupContainsWorkItemDateDim"/>
<MeasureGroup ID="WorkItemIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="WorkItemIsAboutConfigItemDateDim"/>
<MeasureGroup ID="WorkItemCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="WorkItemCreatedByUserDateDim"/>
<MeasureGroup ID="WorkItemAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="WorkItemAssignedToUserDateDim"/>
<MeasureGroup ID="WorkItemAffectedByUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="WorkItemAffectedByUserDateDim"/>
<MeasureGroup ID="WorkItemRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="WorkItemRelatesToConfigItemDateDim"/>
<MeasureGroup ID="WorkItemRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="WorkItemRelatesToWorkItemDateDim"/>
<MeasureGroup ID="WorkItemHasBillableTime" Fact="DWBase!WorkItemHasBillableTimeFact" DateDimAlias="WorkItemHasBillableTimeDateDim"/>
<MeasureGroup ID="BillableTimeBilledByUser" Fact="DWBase!BillableTimeHasWorkingUserFact" DateDimAlias="BillableTimeBilledByUserDateDim"/>
<!--Incident Related facts-->
<MeasureGroup ID="IncidentStatusDuration" Fact="IncidentDW!IncidentStatusDurationFact" DateDimAlias="IncidentStatusDurationDateDim"/>
<MeasureGroup ID="IncidentResolutionByUser" Fact="IncidentDW!IncidentResolvedByUserFact" DateDimAlias="IncidentResolutionByUserDateDim"/>
<MeasureGroup ID="IncidentPrimaryUser" Fact="IncidentDW!IncidentHasPrimaryOwnerFact" DateDimAlias="IncidentPrimaryUserDateDim"/>
<MeasureGroup ID="IncidentIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="IncidentIsAboutConfigItemDateDim"/>
<MeasureGroup ID="IncidentCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="IncidentCreatedByUserDateDim"/>
<MeasureGroup ID="IncidentAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="IncidentAssignedToUserDateDim"/>
<MeasureGroup ID="IncidentAffectedByUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="IncidentAffectedByUserDateDim"/>
<MeasureGroup ID="IncidentRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="IncidentRelatesToConfigItemDateDim"/>
<MeasureGroup ID="IncidentRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="IncidentRelatesToWorkItemDateDim"/>
<MeasureGroup ID="IncidentHasBillableTime" Fact="DWBase!WorkItemHasBillableTimeFact" DateDimAlias="IncidentHasBillableTimeDateDim"/>
<MeasureGroup ID="IncidentRelatesToProblem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="IncidentRelatesToProblemDateDim"/>
<MeasureGroup ID="IncidentSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="IncidentSLAInstanceInformationDateDim"/>
<MeasureGroup ID="WorkItemGroupContainsIncident" Fact="DWBase!WorkItemGroupContainsWorkItemFact" DateDimAlias="WorkItemGroupContainsIncidentDim"/>
<MeasureGroup ID="IncidentIsAboutService" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="IncidentIsAboutServiceDim"/>
<!--Problem Related facts-->
<MeasureGroup ID="ProblemResolutionByUser" Fact="ProblemDW!ProblemResolvedByUserFact" DateDimAlias="ProblemResolutionByUserDateDim"/>
<MeasureGroup ID="ProblemIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ProblemIsAboutConfigItemDateDim"/>
<MeasureGroup ID="ProblemCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ProblemCreatedByUserDateDim"/>
<MeasureGroup ID="ProblemAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ProblemAssignedToUserDateDim"/>
<MeasureGroup ID="ProblemAffectedByUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="ProblemAffectedByUserDateDim"/>
<MeasureGroup ID="ProblemRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="ProblemRelatesToConfigItemDateDim"/>
<MeasureGroup ID="ProblemRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="ProblemRelatesToWorkItemDateDim"/>
<MeasureGroup ID="ProblemHasBillableTime" Fact="DWBase!WorkItemHasBillableTimeFact" DateDimAlias="ProblemHasBillableTimeDateDim"/>
<MeasureGroup ID="ProblemSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="ProblemSLAInstanceInformationDateDim"/>
<!-- Releases-->
<MeasureGroup ID="ReleaseIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ReleaseIsAboutConfigItemDateDim"/>
<MeasureGroup ID="ReleaseCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ReleaseCreatedByUserDateDim"/>
<MeasureGroup ID="ReleaseAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ReleaseAssignedToUserDateDim"/>
<MeasureGroup ID="ReleaseSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="ReleaseSLAInstanceInformationDateDim"/>
<MeasureGroup ID="WorkItemIsAboutComputer" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="WorkItemIsAboutComputerDateDim"/>
<MeasureGroup ID="WorkItemIsAboutService" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="WorkItemIsAboutServiceDateDim"/>
<MeasureGroup ID="ServiceContainsConfigItem" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsConfigItemDateDim"/>
<MeasureGroup ID="ServiceContainsComputer" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsComputerDateDim"/>
</MeasureGroups>
<Substitutions>
<!--Substitions for SLA-->
<Substitution MeasureGroupName="SLAConfigurationHasMetric" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim" Relationship="SLACore!System.SLA.ConfigurationRefersToMetric" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="SLAConfigurationHasMetric" TargetDimension="SLADWLibrary!SLAMetricDim" AliasReplacementDimensionAs="SLATimeMetricDim" ReplacementDimension="SLADWLibrary!SLADatePropertyTimeMetricDim" Relationship="SLACore!System.SLA.ConfigurationRefersToMetric" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="SLAConfigurationHasCalendar" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim" Relationship="SLACore!System.SLA.ConfigurationRefersToCalendar" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="SLAConfigurationHasCalendar" TargetDimension="SLADWLibrary!CalendarDim" AliasTargetDimensionAs="SLACalendarDim" Relationship="SLACore!System.SLA.ConfigurationRefersToCalendar" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="SLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim"/>
<Substitution MeasureGroupName="SLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>
<!--Substitions for Workitem-->
<Substitution MeasureGroupName="WorkItemGroupContainsWorkItem" TargetDimension="DWBase!WorkItemGroupDim" AliasTargetDimensionAs="WorkItemGroupDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemGroupContainsWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemCreatedByUser" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemAssignedToUser" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemAffectedByUser" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemAffectedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AffectedUserDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemRelatesToConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="RelatedWorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemHasBillableTime" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemHasBillableTime" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="BillableTimeBilledByUser" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItem.BillableTimeHasWorkingUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="BillableTimeBilledByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="UserDim" Relationship="WorkItem!System.WorkItem.BillableTimeHasWorkingUser" RelationshipEndPoint="Target"/>
<!--Substitutions for Incident-->
<Substitution MeasureGroupName="IncidentResolutionByUser" TargetDimension="IncidentDW!IncidentDim" AliasTargetDimensionAs="IncidentDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentResolutionByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ResolvedByUserDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentPrimaryUser" TargetDimension="IncidentDW!IncidentDim" AliasTargetDimensionAs="IncidentDim" Relationship="Incident!System.WorkItem.IncidentPrimaryOwner" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentPrimaryUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="IncidentPrimaryUserDim" Relationship="Incident!System.WorkItem.IncidentPrimaryOwner" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentAffectedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentAffectedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AffectedUserDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentRelatesToConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="RelatedWorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentHasBillableTime" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentHasBillableTime" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentRelatesToProblem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" AliasReplacementDimensionAs="IncidentDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentRelatesToProblem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" AliasReplacementDimensionAs="ProblemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" AliasReplacementDimensionAs="IncidentDim"/>
<Substitution MeasureGroupName="IncidentSLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>
<Substitution MeasureGroupName="WorkItemGroupContainsIncident" TargetDimension="DWBase!WorkItemGroupDim" AliasTargetDimensionAs="WorkItemGroupDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemGroupContainsIncident" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" AliasReplacementDimensionAs="IncidentDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Target"/>
<!--Substitutions for Problem-->
<Substitution MeasureGroupName="ProblemResolutionByUser" TargetDimension="ProblemDW!ProblemDim" AliasTargetDimensionAs="ProblemDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemResolutionByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ResolvedByUserDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemAffectedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemAffectedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AffectedUserDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemRelatesToConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="RelatedWorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemHasBillableTime" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ProblemHasBillableTime" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ProblemSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" AliasReplacementDimensionAs="ProblemDim"/>
<Substitution MeasureGroupName="ProblemSLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>
<!--Substitutions for Releases-->
<Substitution MeasureGroupName="ReleaseIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ReleaseIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ReleaseCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ReleaseCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ReleaseAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ReleaseAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ReleaseSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim"/>
<Substitution MeasureGroupName="ReleaseSLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>
<Substitution MeasureGroupName="WorkItemIsAboutComputer" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemIsAboutComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="WorkItemIsAboutService" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="WorkItemIsAboutService" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ServiceDim" AliasReplacementDimensionAs="ServiceDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="IncidentIsAboutService" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="IncidentIsAboutService" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ServiceDim" AliasReplacementDimensionAs="ServiceDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ServiceContainsComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim"/>
<Substitution MeasureGroupName="ServiceContainsConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim"/>
</Substitutions>
<CustomMDX>SystemCenterWorkItemsCubeMDX</CustomMDX>
<NamedCalculations>
<NamedCalculation ID="IncidentsResolved" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>case when (Status = 'IncidentStatusEnum.Resolved' OR Status = 'IncidentStatusEnum.Closed' ) then 1 else 0 end</Calculation>
</NamedCalculation>
<NamedCalculation ID="IncidentsResolvedWithinTargetResolutionTime" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>(case when ( (Status= 'IncidentStatusEnum.Resolved' OR Status = 'IncidentStatusEnum.Closed') AND ResolvedDate &lt;= TargetResolutionTime ) then 1 else 0 end )</Calculation>
</NamedCalculation>
<NamedCalculation ID="IncidentsResolutionTimeInHours" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>(case when (Status = 'IncidentStatusEnum.Resolved' OR Status = 'IncidentStatusEnum.Closed') then DATEDIFF(HOUR, CreatedDate, ResolvedDate) else 0 end )</Calculation>
</NamedCalculation>
<NamedCalculation ID="IncidentsPastTargetResolutionTime" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>(case when ( (([Status] = 'IncidentStatusEnum.Resolved' OR [Status] = 'IncidentStatusEnum.Closed') AND ResolvedDate &gt; TargetResolutionTime) OR (([Status] != 'IncidentStatusEnum.Resolved' AND [Status] != 'IncidentStatusEnum.Closed') AND GETUTCDATE() &gt; TargetResolutionTime)) then 1 else 0 end )</Calculation>
</NamedCalculation>
<NamedCalculation ID="ReleasesImplementedOnSchedule" Target="ReleaseDW!ReleaseRecordDim" ColumnType="Int">
<Calculation>( case when ( ActualEndDate &lt;= ScheduledEndDate ) then 1 else 0 end )</Calculation>
</NamedCalculation>
<NamedCalculation ID="Incident_CreatedDate__DateKey" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>isNull(CONVERT(nvarchar(8), CreatedDate, 112),'20000101')</Calculation>
</NamedCalculation>
<NamedCalculation ID="Incident_ResolvedDate__DateKey" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>isNull(CONVERT(nvarchar(8), ResolvedDate, 112),'20000101')</Calculation>
</NamedCalculation>
<NamedCalculation ID="Incident_ClosedDate__DateKey" Target="IncidentDW!IncidentDim" ColumnType="Int">
<Calculation>isNull(CONVERT(nvarchar(8), ClosedDate, 112),'20000101')</Calculation>
</NamedCalculation>
<NamedCalculation ID="Problem_CreatedDate__DateKey" Target="ProblemDW!ProblemDim" ColumnType="Int">
<Calculation>isNull(CONVERT(nvarchar(8), CreatedDate, 112),'20000101')</Calculation>
</NamedCalculation>
<NamedCalculation ID="Problem_ResolvedDate__DateKey" Target="ProblemDW!ProblemDim" ColumnType="Int">
<Calculation>isNull(CONVERT(nvarchar(8), ResolvedDate, 112),'20000101')</Calculation>
</NamedCalculation>
<NamedCalculation ID="Problem_ClosedDate__DateKey" Target="ProblemDW!ProblemDim" ColumnType="Int">
<Calculation>isNull(CONVERT(nvarchar(8), ClosedDate, 112),'20000101')</Calculation>
</NamedCalculation>
</NamedCalculations>
<Measures>
<Measure ID="IncidentsResolvedCount" Target="IncidentDW!IncidentDim" Type="Sum" Property="IncidentsResolved"/>
<Measure ID="IncidentsResolvedWithinTargetResolutionTimeCount" Target="IncidentDW!IncidentDim" Type="Sum" Property="IncidentsResolvedWithinTargetResolutionTime"/>
<Measure ID="IncidentsResolutionTimeInHoursSum" Target="IncidentDW!IncidentDim" Type="Sum" Property="IncidentsResolutionTimeInHours"/>
<Measure ID="IncidentsPastTargetResolutionTimeCount" Target="IncidentDW!IncidentDim" Type="Sum" Property="IncidentsPastTargetResolutionTime"/>
<Measure ID="ReleasesImplementedOnScheduleCount" Target="ReleaseDW!ReleaseRecordDim" Type="Sum" Property="ReleasesImplementedOnSchedule"/>
<Measure ID="TimeWorkedSum" Target="DWBase!BillableTimeDim" Type="Sum" Property="TimeInMinutes"/>
</Measures>
<ManyToManyRelationships>
<ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="IncidentIsAboutConfigItem" IntermediateMeasureGroup="ServiceContainsConfigItem"/>
<ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="IncidentDim" IntermediateMeasureGroup="IncidentIsAboutService"/>
<ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ProblemIsAboutConfigItem" IntermediateMeasureGroup="ServiceContainsConfigItem"/>
<ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ProblemDim" IntermediateMeasureGroup="ProblemIsAboutConfigItem"/>
<ManyToManyRelationship CubeDimension="IncidentDim" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="IncidentIsAboutConfigItem"/>
<ManyToManyRelationship CubeDimension="IncidentDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>
<ManyToManyRelationship CubeDimension="ProblemDim" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="ProblemIsAboutConfigItem"/>
<ManyToManyRelationship CubeDimension="ProblemDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>
<ManyToManyRelationship CubeDimension="AssignedToUserDim" TargetMeasureGroup="WorkItemIsAboutConfigItem" IntermediateMeasureGroup="WorkItemAssignedToUser"/>
<ManyToManyRelationship CubeDimension="AssignedToUserDim" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="WorkItemIsAboutConfigItem"/>
<ManyToManyRelationship CubeDimension="AssignedToUserDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>
<ManyToManyRelationship CubeDimension="CreatedByUserDim" TargetMeasureGroup="WorkItemIsAboutConfigItem" IntermediateMeasureGroup="WorkItemCreatedByUser"/>
<ManyToManyRelationship CubeDimension="CreatedByUserDim" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="WorkItemIsAboutConfigItem"/>
<ManyToManyRelationship CubeDimension="CreatedByUserDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>
<ManyToManyRelationship CubeDimension="WorkItemGroupDim" TargetMeasureGroup="IncidentDim" IntermediateMeasureGroup="WorkItemGroupContainsIncident"/>
</ManyToManyRelationships>
</SystemCenterCube>