CustomMDX | SystemCenterWorkItemsCubeMDX |
SLAInstanceInformation | Informação de Instância SLA | Informação de Instância SLA |
SLAConfigurationHasMetric | Configuração do SLA Tem Métrica | Configuração do SLA Tem Métrica |
SLAConfigurationHasCalendar | Configuração do SLA Tem Calendário | Configuração do SLA Tem Calendário |
WorkItemGroupContainsWorkItem | Grupo de Itens de Trabalho Contém Item de Trabalho | Grupo de Itens de Trabalho Contém Item de Trabalho |
WorkItemIsAboutConfigItem | WorkItem Is About ConfigItem | WorkItem Is About ConfigItem |
WorkItemCreatedByUser | Item de Trabalho Criado por Utilizador | Item de Trabalho Criado por Utilizador |
WorkItemAssignedToUser | Item de Trabalho Atribuído ao Utilizador | Item de Trabalho Atribuído ao Utilizador |
WorkItemAffectedByUser | Item de Trabalho Afectado por Utilizador | Item de Trabalho Afectado por Utilizador |
WorkItemRelatesToConfigItem | Item de Trabalho Relacionado com Item de Configuração | Item de Trabalho Relacionado com Item de Configuração |
WorkItemRelatesToWorkItem | Item de Trabalho Relacionado com Item de Trabalho | Item de Trabalho Relacionado com Item de Trabalho |
WorkItemHasBillableTime | Item de Trabalho Possui Tempo Facturável | Item de Trabalho Possui Tempo Facturável |
BillableTimeBilledByUser | Tempo Facturável Facturado por Utilizador | Tempo Facturável Facturado por Utilizador |
IncidentStatusDuration | Duração do Estado do Incidente | Duração do Estado do Incidente |
IncidentResolutionByUser | Resolução do Incidente por Utilizador | Resolução do Incidente por Utilizador |
IncidentPrimaryUser | Utilizador Primário do Incidente | Utilizador Primário do Incidente |
IncidentIsAboutConfigItem | Incident Is About Config Item | Incident Is About Config Item |
IncidentCreatedByUser | Incidente Criado por Utilizador | Incidente Criado por Utilizador |
IncidentAssignedToUser | Incidente Atribuído ao Utilizador | Incidente Atribuído ao Utilizador |
IncidentAffectedByUser | Incidente Afectado por Utilizador | Incidente Afectado por Utilizador |
IncidentRelatesToConfigItem | Incidente Relacionado com Item de Configuração | Incidente Relacionado com Item de Configuração |
IncidentRelatesToWorkItem | Incidente Relacionado com Item de Trabalho | Incidente Relacionado com Item de Trabalho |
IncidentHasBillableTime | Incidente Possui Tempo Facturável | Incidente Possui Tempo Facturável |
IncidentRelatesToProblem | Incidente Relacionado com Problema | Incidente Relacionado com Problema |
IncidentSLAInstanceInformation | Informação de Instância SLA do Incidente | Informação de Instância SLA do Incidente |
IncidentIsAboutService | Incidente é sobre o Serviço | Incidente é sobre o Serviço |
ProblemResolutionByUser | Resolução do Problema por Utilizador | Resolução do Problema por Utilizador |
ProblemIsAboutConfigItem | Problem Is About Config Item | Problem Is About Config Item |
ProblemCreatedByUser | Problema Criado por Utilizador | Problema Criado por Utilizador |
ProblemAssignedToUser | Problema Atribuído ao Utilizador | Problema Atribuído ao Utilizador |
ProblemAffectedByUser | Problema Afectado por Utilizador | Problema Afectado por Utilizador |
ProblemRelatesToConfigItem | Problema Relacionado com Item de Configuração | Problema Relacionado com Item de Configuração |
ProblemRelatesToWorkItem | Problema Relacionado com Item de Trabalho | Problema Relacionado com Item de Trabalho |
ProblemHasBillableTime | Problema Possui Tempo Facturável | Problema Possui Tempo Facturável |
ProblemSLAInstanceInformation | Informação de Instância SLA do Problema | Informação de Instância SLA do Problema |
ReleaseIsAboutConfigItem | Release Is About Config Item | Release Is About Config Item |
ReleaseCreatedByUser | Versão Criada por Utilizador | Versão Criada por Utilizador |
ReleaseAssignedToUser | Versão Atribuída ao Utilizador | Versão Atribuída ao Utilizador |
ReleaseSLAInstanceInformation | Informação de Instância SLA da Versão | Informação de Instância SLA da Versão |
WorkItemIsAboutComputer | WorkItem Is About Computer | WorkItem Is About Computer |
WorkItemIsAboutService | WorkItem Is About Service | WorkItem Is About Service |
ServiceContainsConfigItem | Serviço Contém Item de Configuração | Serviço Contém Item de Configuração |
ServiceContainsComputer | Serviço Contém Computador | Serviço Contém Computador |
IncidentsResolvedCount | Contagem de Incidentes Resolvidos | Contagem de Incidentes Resolvidos |
IncidentsResolvedWithinTargetResolutionTimeCount | Contagem de Incidentes Resolvidos no Tempo de Resolução de Destino | Contagem de Incidentes Resolvidos no Tempo de Resolução de Destino |
IncidentsResolutionTimeInHoursSum | Soma do Tempo de Resolução de Incidentes em Horas | Soma do Tempo de Resolução de Incidentes em Horas |
IncidentsPastTargetResolutionTimeCount | Contagem do Tempo de Destino Passado de Resolução dos Incidentes | Contagem do Tempo de Destino Passado de Resolução dos Incidentes |
ReleasesImplementedOnScheduleCount | Contagem das Versões Implementadas no Prazo | Contagem das Versões Implementadas no Prazo |
TimeWorkedSum | Soma do Tempo Trabalhado | Soma do Tempo Trabalhado |
<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>
</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>