CustomMDX | SystemCenterWorkItemsCubeMDX |
SLAInstanceInformation | Oplysninger om SLA-forekomst | Oplysninger om SLA-forekomst |
SLAConfigurationHasMetric | SLA-konfiguration har metrikværdi | SLA-konfiguration har metrikværdi |
SLAConfigurationHasCalendar | SLA-konfiguration har kalender | SLA-konfiguration har kalender |
WorkItemGroupContainsWorkItem | Arbejdsganggruppe indeholder arbejdsgang | Arbejdsganggruppe indeholder arbejdsgang |
WorkItemIsAboutConfigItem | WorkItem Is About ConfigItem | WorkItem Is About ConfigItem |
WorkItemCreatedByUser | Arbejdsgang oprettet af bruger | Arbejdsgang oprettet af bruger |
WorkItemAssignedToUser | Arbejdsgang tildelt til bruger | Arbejdsgang tildelt til bruger |
WorkItemAffectedByUser | Arbejdsgang påvirket af bruger | Arbejdsgang påvirket af bruger |
WorkItemRelatesToConfigItem | Arbejdsgang relaterer til configuration item | Arbejdsgang relaterer til configuration item |
WorkItemRelatesToWorkItem | Arbejdsgang relaterer til arbejdsgang | Arbejdsgang relaterer til arbejdsgang |
WorkItemHasBillableTime | Arbejdsgang har fakturerbar tid | Arbejdsgang har fakturerbar tid |
BillableTimeBilledByUser | Fakturerbar tid faktureret af bruger | Fakturerbar tid faktureret af bruger |
IncidentStatusDuration | Varighed af incidentstatus | Varighed af incidentstatus |
IncidentResolutionByUser | Incident løst af bruger | Incident løst af bruger |
IncidentPrimaryUser | Primær bruger for incident | Primær bruger for incident |
IncidentIsAboutConfigItem | Incident Is About Config Item | Incident Is About Config Item |
IncidentCreatedByUser | Incident oprettet af bruger | Incident oprettet af bruger |
IncidentAssignedToUser | Incident tildelt til bruger | Incident tildelt til bruger |
IncidentAffectedByUser | Incident påvirket af bruger | Incident påvirket af bruger |
IncidentRelatesToConfigItem | Incident relaterer til configuration item | Incident relaterer til configuration item |
IncidentRelatesToWorkItem | Incident relaterer til arbejdsgang | Incident relaterer til arbejdsgang |
IncidentHasBillableTime | Incident har fakturerbar tid | Incident har fakturerbar tid |
IncidentRelatesToProblem | Incident relaterer til problem | Incident relaterer til problem |
IncidentSLAInstanceInformation | Oplysninger om incident-SLA-forekomst | Oplysninger om incident-SLA-forekomst |
IncidentIsAboutService | Incident er om service | Incident er om service |
ProblemResolutionByUser | Problem løst af bruger | Problem løst af bruger |
ProblemIsAboutConfigItem | Problem Is About Config Item | Problem Is About Config Item |
ProblemCreatedByUser | Problem oprettet af bruger | Problem oprettet af bruger |
ProblemAssignedToUser | Problem tildelt til bruger | Problem tildelt til bruger |
ProblemAffectedByUser | Problem påvirket af bruger | Problem påvirket af bruger |
ProblemRelatesToConfigItem | Problem relaterer til configuration item | Problem relaterer til configuration item |
ProblemRelatesToWorkItem | Problem relaterer til arbejdsgang | Problem relaterer til arbejdsgang |
ProblemHasBillableTime | Problem har fakturerbar tid | Problem har fakturerbar tid |
ProblemSLAInstanceInformation | Oplysninger om problem-SLA-forekomst | Oplysninger om problem-SLA-forekomst |
ReleaseIsAboutConfigItem | Release Is About Config Item | Release Is About Config Item |
ReleaseCreatedByUser | Release oprettet af bruger | Release oprettet af bruger |
ReleaseAssignedToUser | Release tildelt til bruger | Release tildelt til bruger |
ReleaseSLAInstanceInformation | Oplysninger om Release SLA-forekomst | Oplysninger om Release SLA-forekomst |
WorkItemIsAboutComputer | WorkItem Is About Computer | WorkItem Is About Computer |
WorkItemIsAboutService | WorkItem Is About Service | WorkItem Is About Service |
ServiceContainsConfigItem | Tjeneste indeholder configuration item | Tjeneste indeholder configuration item |
ServiceContainsComputer | Tjeneste indeholder computer | Tjeneste indeholder computer |
IncidentsResolvedCount | Antal løste incidents | Antal løste incidents |
IncidentsResolvedWithinTargetResolutionTimeCount | Antal incidents løst inden for målsat løsningstid | Antal incidents løst inden for målsat løsningstid |
IncidentsResolutionTimeInHoursSum | Samlet antal timer til incidentløsning | Samlet antal timer til incidentløsning |
IncidentsPastTargetResolutionTimeCount | Antal incidents overskredet løsningstid for destination | Antal incidents overskredet løsningstid for destination |
ReleasesImplementedOnScheduleCount | Antal Releases implementeret efter planen | Antal Releases implementeret efter planen |
TimeWorkedSum | Samlet arbejdstid | Samlet arbejdstid |
<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>