CustomMDX | SystemCenterWorkItemsCubeMDX |
SLAInstanceInformation | SLA-példány adatai | SLA-példány adatai |
SLAConfigurationHasMetric | SLA-konfigurációhoz metrika tartozik | SLA-konfigurációhoz metrika tartozik |
SLAConfigurationHasCalendar | SLA-konfigurációhoz naptár tartozik | SLA-konfigurációhoz naptár tartozik |
WorkItemGroupContainsWorkItem | WorkItem csoport munkaelemet tartalmaz | WorkItem csoport munkaelemet tartalmaz |
WorkItemIsAboutConfigItem | WorkItem tárgya ConfigItem | WorkItem tárgya ConfigItem |
WorkItemCreatedByUser | Felhasználó WorkItem elemet hozott létre | Felhasználó WorkItem elemet hozott létre |
WorkItemAssignedToUser | WorkItem hozzárendelve felhasználóhoz | WorkItem hozzárendelve felhasználóhoz |
WorkItemAffectedByUser | Felhasználó által érintett WorkItem elem | Felhasználó által érintett WorkItem elem |
WorkItemRelatesToConfigItem | WorkItem elem ConfigItem elemmel kapcsolatos | WorkItem elem ConfigItem elemmel kapcsolatos |
WorkItemRelatesToWorkItem | WorkItem elem WorkItem elemmel kapcsolatos | WorkItem elem WorkItem elemmel kapcsolatos |
WorkItemHasBillableTime | WorkItem elemhez számlázható idő tartozik | WorkItem elemhez számlázható idő tartozik |
BillableTimeBilledByUser | Felhasználó által kiszámlázott számlázható idő | Felhasználó által kiszámlázott számlázható idő |
IncidentStatusDuration | Incidensállapot időtartama | Incidensállapot időtartama |
IncidentResolutionByUser | Incidens felhasználó általi megoldása | Incidens felhasználó általi megoldása |
IncidentPrimaryUser | Incidens elsődleges felhasználója | Incidens elsődleges felhasználója |
IncidentIsAboutConfigItem | Incidens tárgya konfigurációelem | Incidens tárgya konfigurációelem |
IncidentCreatedByUser | Felhasználó incidenst hozott létre | Felhasználó incidenst hozott létre |
IncidentAssignedToUser | Incidens hozzárendelve felhasználóhoz | Incidens hozzárendelve felhasználóhoz |
IncidentAffectedByUser | Felhasználó által érintett incidens | Felhasználó által érintett incidens |
IncidentRelatesToConfigItem | Incidens konfigurációelemmel kapcsolatos | Incidens konfigurációelemmel kapcsolatos |
IncidentRelatesToWorkItem | Incidens munkaelemmel kapcsolatos | Incidens munkaelemmel kapcsolatos |
IncidentHasBillableTime | Incidenshez számlázható idő tartozik | Incidenshez számlázható idő tartozik |
IncidentRelatesToProblem | Incidens problémával kapcsolatos | Incidens problémával kapcsolatos |
IncidentSLAInstanceInformation | Incidens SLA-példányának adatai | Incidens SLA-példányának adatai |
IncidentIsAboutService | Incidens szolgáltatással kapcsolatos | Incidens szolgáltatással kapcsolatos |
ProblemResolutionByUser | Probléma felhasználó általi megoldása | Probléma felhasználó általi megoldása |
ProblemIsAboutConfigItem | Probléma tárgya konfigurációelem | Probléma tárgya konfigurációelem |
ProblemCreatedByUser | Felhasználó problémát hozott létre | Felhasználó problémát hozott létre |
ProblemAssignedToUser | Probléma hozzárendelve felhasználóhoz | Probléma hozzárendelve felhasználóhoz |
ProblemAffectedByUser | Felhasználó által érintett probléma | Felhasználó által érintett probléma |
ProblemRelatesToConfigItem | Probléma konfigurációelemmel kapcsolatos | Probléma konfigurációelemmel kapcsolatos |
ProblemRelatesToWorkItem | Probléma munkaelemmel kapcsolatos | Probléma munkaelemmel kapcsolatos |
ProblemHasBillableTime | Problémához számlázható idő tartozik | Problémához számlázható idő tartozik |
ProblemSLAInstanceInformation | Probléma SLA-példányának adatai | Probléma SLA-példányának adatai |
ReleaseIsAboutConfigItem | Kiadás tárgya konfigurációelem | Kiadás tárgya konfigurációelem |
ReleaseCreatedByUser | Felhasználó kiadást hozott létre | Felhasználó kiadást hozott létre |
ReleaseAssignedToUser | Kiadás hozzárendelve felhasználóhoz | Kiadás hozzárendelve felhasználóhoz |
ReleaseSLAInstanceInformation | Kiadás SLA-példányának adatai | Kiadás SLA-példányának adatai |
WorkItemIsAboutComputer | WorkItem tárgya számítógép | WorkItem tárgya számítógép |
WorkItemIsAboutService | WorkItem tárgya szolgáltatás | WorkItem tárgya szolgáltatás |
ServiceContainsConfigItem | Szolgáltatás ConfigItem elemet tartalmaz | Szolgáltatás ConfigItem elemet tartalmaz |
ServiceContainsComputer | Szolgáltatás számítógépet tartalmaz | Szolgáltatás számítógépet tartalmaz |
IncidentsResolvedCount | Megoldott incidensek száma | Megoldott incidensek száma |
IncidentsResolvedWithinTargetResolutionTimeCount | Kitűzött megoldási időn belül megoldott incidensek száma | Kitűzött megoldási időn belül megoldott incidensek száma |
IncidentsResolutionTimeInHoursSum | Incidensek órában mért összesített megoldási ideje | Incidensek órában mért összesített megoldási ideje |
IncidentsPastTargetResolutionTimeCount | Kitűzött megoldási időn túli incidensek száma | Kitűzött megoldási időn túli incidensek száma |
ReleasesImplementedOnScheduleCount | Időben megvalósított kiadások száma | Időben megvalósított kiadások száma |
TimeWorkedSum | Összesített munkaidő | Összesített munkaidő |
<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 <= 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 > TargetResolutionTime) OR (([Status] != 'IncidentStatusEnum.Resolved' AND [Status] != 'IncidentStatusEnum.Closed') AND GETUTCDATE() > TargetResolutionTime)) then 1 else 0 end )</Calculation>
</NamedCalculation>
<NamedCalculation ID="ReleasesImplementedOnSchedule" Target="ReleaseDW!ReleaseRecordDim" ColumnType="Int">
<Calculation>( case when ( ActualEndDate <= 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>