Cubo de WorkItems do Service Manager

SystemCenterWorkItemsCube (SystemCenterCube)

Element properties:

CustomMDX	SystemCenterWorkItemsCubeMDX

CustomMDX

Cube Localization:

Source Code:

<SystemCenterCube ID="SystemCenterWorkItemsCube">

  <MeasureGroups>

    <!--SLA Related facts-->

    <MeasureGroup ID="SLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="SLAInstanceInformationDateDim"/>

    <MeasureGroup ID="SLAConfigurationHasMetric" Fact="SLADWLibrary!SLAConfigurationHasMetricFact" DateDimAlias="SLAConfigurationHasMetricDateDim"/>

    <MeasureGroup ID="SLAConfigurationHasCalendar" Fact="SLADWLibrary!SLAConfigurationHasCalendarFact" DateDimAlias="SLAConfigurationHasCalendarDateDim"/>

    <!--Workitem Related facts-->

    <MeasureGroup ID="WorkItemGroupContainsWorkItem" Fact="DWBase!WorkItemGroupContainsWorkItemFact" DateDimAlias="WorkItemGroupContainsWorkItemDateDim"/>

    <MeasureGroup ID="WorkItemIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="WorkItemIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="WorkItemCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="WorkItemCreatedByUserDateDim"/>

    <MeasureGroup ID="WorkItemAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="WorkItemAssignedToUserDateDim"/>

    <MeasureGroup ID="WorkItemAffectedByUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="WorkItemAffectedByUserDateDim"/>

    <MeasureGroup ID="WorkItemRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="WorkItemRelatesToConfigItemDateDim"/>

    <MeasureGroup ID="WorkItemRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="WorkItemRelatesToWorkItemDateDim"/>

    <MeasureGroup ID="WorkItemHasBillableTime" Fact="DWBase!WorkItemHasBillableTimeFact" DateDimAlias="WorkItemHasBillableTimeDateDim"/>

    <MeasureGroup ID="BillableTimeBilledByUser" Fact="DWBase!BillableTimeHasWorkingUserFact" DateDimAlias="BillableTimeBilledByUserDateDim"/>

    <!--Incident Related facts-->

    <MeasureGroup ID="IncidentStatusDuration" Fact="IncidentDW!IncidentStatusDurationFact" DateDimAlias="IncidentStatusDurationDateDim"/>

    <MeasureGroup ID="IncidentResolutionByUser" Fact="IncidentDW!IncidentResolvedByUserFact" DateDimAlias="IncidentResolutionByUserDateDim"/>

    <MeasureGroup ID="IncidentPrimaryUser" Fact="IncidentDW!IncidentHasPrimaryOwnerFact" DateDimAlias="IncidentPrimaryUserDateDim"/>

    <MeasureGroup ID="IncidentIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="IncidentIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="IncidentCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="IncidentCreatedByUserDateDim"/>

    <MeasureGroup ID="IncidentAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="IncidentAssignedToUserDateDim"/>

    <MeasureGroup ID="IncidentAffectedByUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="IncidentAffectedByUserDateDim"/>

    <MeasureGroup ID="IncidentRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="IncidentRelatesToConfigItemDateDim"/>

    <MeasureGroup ID="IncidentRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="IncidentRelatesToWorkItemDateDim"/>

    <MeasureGroup ID="IncidentHasBillableTime" Fact="DWBase!WorkItemHasBillableTimeFact" DateDimAlias="IncidentHasBillableTimeDateDim"/>

    <MeasureGroup ID="IncidentRelatesToProblem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="IncidentRelatesToProblemDateDim"/>

    <MeasureGroup ID="IncidentSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="IncidentSLAInstanceInformationDateDim"/>

    <MeasureGroup ID="WorkItemGroupContainsIncident" Fact="DWBase!WorkItemGroupContainsWorkItemFact" DateDimAlias="WorkItemGroupContainsIncidentDim"/>

    <MeasureGroup ID="IncidentIsAboutService" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="IncidentIsAboutServiceDim"/>

    <!--Problem Related facts-->

    <MeasureGroup ID="ProblemResolutionByUser" Fact="ProblemDW!ProblemResolvedByUserFact" DateDimAlias="ProblemResolutionByUserDateDim"/>

    <MeasureGroup ID="ProblemIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ProblemIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="ProblemCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ProblemCreatedByUserDateDim"/>

    <MeasureGroup ID="ProblemAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ProblemAssignedToUserDateDim"/>

    <MeasureGroup ID="ProblemAffectedByUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="ProblemAffectedByUserDateDim"/>

    <MeasureGroup ID="ProblemRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="ProblemRelatesToConfigItemDateDim"/>

    <MeasureGroup ID="ProblemRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="ProblemRelatesToWorkItemDateDim"/>

    <MeasureGroup ID="ProblemHasBillableTime" Fact="DWBase!WorkItemHasBillableTimeFact" DateDimAlias="ProblemHasBillableTimeDateDim"/>

    <MeasureGroup ID="ProblemSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="ProblemSLAInstanceInformationDateDim"/>

    <!-- Releases-->

    <MeasureGroup ID="ReleaseIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ReleaseIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="ReleaseCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ReleaseCreatedByUserDateDim"/>

    <MeasureGroup ID="ReleaseAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ReleaseAssignedToUserDateDim"/>

    <MeasureGroup ID="ReleaseSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="ReleaseSLAInstanceInformationDateDim"/>

    <MeasureGroup ID="WorkItemIsAboutComputer" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="WorkItemIsAboutComputerDateDim"/>

    <MeasureGroup ID="WorkItemIsAboutService" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="WorkItemIsAboutServiceDateDim"/>

    <MeasureGroup ID="ServiceContainsConfigItem" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsConfigItemDateDim"/>

    <MeasureGroup ID="ServiceContainsComputer" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsComputerDateDim"/>

  </MeasureGroups>

  <Substitutions>

    <!--Substitions for SLA-->

    <Substitution MeasureGroupName="SLAConfigurationHasMetric" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim" Relationship="SLACore!System.SLA.ConfigurationRefersToMetric" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SLAConfigurationHasMetric" TargetDimension="SLADWLibrary!SLAMetricDim" AliasReplacementDimensionAs="SLATimeMetricDim" ReplacementDimension="SLADWLibrary!SLADatePropertyTimeMetricDim" Relationship="SLACore!System.SLA.ConfigurationRefersToMetric" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SLAConfigurationHasCalendar" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim" Relationship="SLACore!System.SLA.ConfigurationRefersToCalendar" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SLAConfigurationHasCalendar" TargetDimension="SLADWLibrary!CalendarDim" AliasTargetDimensionAs="SLACalendarDim" Relationship="SLACore!System.SLA.ConfigurationRefersToCalendar" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim"/>

    <Substitution MeasureGroupName="SLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>

    <!--Substitions for Workitem-->

    <Substitution MeasureGroupName="WorkItemGroupContainsWorkItem" TargetDimension="DWBase!WorkItemGroupDim" AliasTargetDimensionAs="WorkItemGroupDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemGroupContainsWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemCreatedByUser" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemAssignedToUser" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemAffectedByUser" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemAffectedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AffectedUserDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemRelatesToConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="RelatedWorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemHasBillableTime" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemHasBillableTime" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="BillableTimeBilledByUser" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItem.BillableTimeHasWorkingUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="BillableTimeBilledByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="UserDim" Relationship="WorkItem!System.WorkItem.BillableTimeHasWorkingUser" RelationshipEndPoint="Target"/>

    <!--Substitutions for Incident-->

    <Substitution MeasureGroupName="IncidentResolutionByUser" TargetDimension="IncidentDW!IncidentDim" AliasTargetDimensionAs="IncidentDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentResolutionByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ResolvedByUserDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentPrimaryUser" TargetDimension="IncidentDW!IncidentDim" AliasTargetDimensionAs="IncidentDim" Relationship="Incident!System.WorkItem.IncidentPrimaryOwner" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentPrimaryUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="IncidentPrimaryUserDim" Relationship="Incident!System.WorkItem.IncidentPrimaryOwner" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentAffectedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentAffectedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AffectedUserDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentRelatesToConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="RelatedWorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentHasBillableTime" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentHasBillableTime" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentRelatesToProblem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" AliasReplacementDimensionAs="IncidentDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentRelatesToProblem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" AliasReplacementDimensionAs="ProblemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" AliasReplacementDimensionAs="IncidentDim"/>

    <Substitution MeasureGroupName="IncidentSLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>

    <Substitution MeasureGroupName="WorkItemGroupContainsIncident" TargetDimension="DWBase!WorkItemGroupDim" AliasTargetDimensionAs="WorkItemGroupDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemGroupContainsIncident" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" AliasReplacementDimensionAs="IncidentDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Target"/>

    <!--Substitutions for Problem-->

    <Substitution MeasureGroupName="ProblemResolutionByUser" TargetDimension="ProblemDW!ProblemDim" AliasTargetDimensionAs="ProblemDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemResolutionByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ResolvedByUserDim" Relationship="WorkItem!System.WorkItem.TroubleTicketResolvedByUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemAffectedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemAffectedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AffectedUserDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemRelatesToConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="RelatedWorkItemDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemHasBillableTime" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProblemHasBillableTime" TargetDimension="DWBase!BillableTimeDim" AliasTargetDimensionAs="BillableTimeDim" Relationship="WorkItem!System.WorkItemHasBillableTime" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProblemSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ProblemDW!ProblemDim" AliasReplacementDimensionAs="ProblemDim"/>

    <Substitution MeasureGroupName="ProblemSLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>

    <!--Substitutions for Releases-->

    <Substitution MeasureGroupName="ReleaseIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ReleaseIsAboutConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ReleaseCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ReleaseCreatedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="CreatedByUserDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ReleaseAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ReleaseAssignedToUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="AssignedToUserDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ReleaseSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ReleaseDW!ReleaseRecordDim" AliasReplacementDimensionAs="ReleaseDim"/>

    <Substitution MeasureGroupName="ReleaseSLAInstanceInformation" TargetDimension="SLADWLibrary!SLAConfigurationDim" AliasTargetDimensionAs="SLAConfigurationDim"/>

    <Substitution MeasureGroupName="WorkItemIsAboutComputer" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemIsAboutComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="WorkItemIsAboutService" TargetDimension="DWBase!WorkItemDim" AliasTargetDimensionAs="WorkItemDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="WorkItemIsAboutService" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ServiceDim" AliasReplacementDimensionAs="ServiceDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="IncidentIsAboutService" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="IncidentDW!IncidentDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="IncidentIsAboutService" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ServiceDim" AliasReplacementDimensionAs="ServiceDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ServiceContainsComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim"/>

    <Substitution MeasureGroupName="ServiceContainsConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="RelatedConfigItemDim"/>

  </Substitutions>

  <CustomMDX>SystemCenterWorkItemsCubeMDX</CustomMDX>

  <NamedCalculations>

    <NamedCalculation ID="IncidentsResolved" Target="IncidentDW!IncidentDim" ColumnType="Int">

      <Calculation>case when (Status = 'IncidentStatusEnum.Resolved' OR Status = 'IncidentStatusEnum.Closed' ) then 1 else 0 end</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="IncidentsResolvedWithinTargetResolutionTime" Target="IncidentDW!IncidentDim" ColumnType="Int">

      <Calculation>(case when (  (Status= 'IncidentStatusEnum.Resolved' OR Status = 'IncidentStatusEnum.Closed')  AND ResolvedDate &lt;= TargetResolutionTime ) then 1  else 0  end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="IncidentsResolutionTimeInHours" Target="IncidentDW!IncidentDim" ColumnType="Int">

      <Calculation>(case when (Status = 'IncidentStatusEnum.Resolved' OR Status = 'IncidentStatusEnum.Closed') then DATEDIFF(HOUR, CreatedDate, ResolvedDate)  else 0  end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="IncidentsPastTargetResolutionTime" Target="IncidentDW!IncidentDim" ColumnType="Int">

      <Calculation>(case when ( (([Status] = 'IncidentStatusEnum.Resolved' OR [Status] = 'IncidentStatusEnum.Closed') AND ResolvedDate &gt; TargetResolutionTime) OR (([Status] != 'IncidentStatusEnum.Resolved' AND [Status] != 'IncidentStatusEnum.Closed') AND GETUTCDATE() &gt; TargetResolutionTime)) then 1 else 0 end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ReleasesImplementedOnSchedule" Target="ReleaseDW!ReleaseRecordDim" ColumnType="Int">

      <Calculation>( case when ( ActualEndDate &lt;= ScheduledEndDate ) then 1 else 0 end )</Calculation>

    </NamedCalculation>

  </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>

*SLAInstanceInformation*	Informações da Instância de SLA	Informações da Instância de SLA
*SLAConfigurationHasMetric*	A Configuração de SLA Tem Métrica	A Configuração de SLA Tem Métrica
*SLAConfigurationHasCalendar*	A Configuração de SLA Tem Calendário	A Configuração de SLA Tem Calendário
*WorkItemGroupContainsWorkItem*	O Grupo WorkItem Contém o Item de Trabalho	O Grupo WorkItem Contém o Item de Trabalho
*WorkItemIsAboutConfigItem*	WorkItem Is About ConfigItem	WorkItem Is About ConfigItem
*WorkItemCreatedByUser*	WorkItem Criado pelo Usuário	WorkItem Criado pelo Usuário
*WorkItemAssignedToUser*	WorkItem Atribuído ao Usuário	WorkItem Atribuído ao Usuário
*WorkItemAffectedByUser*	WorkItem Afetado pelo Usuário	WorkItem Afetado pelo Usuário
*WorkItemRelatesToConfigItem*	WorkItem Relacionado ao ConfigItem	WorkItem Relacionado ao ConfigItem
*WorkItemRelatesToWorkItem*	WorkItem Relacionado ao WorkItem	WorkItem Relacionado ao WorkItem
*WorkItemHasBillableTime*	O WorkItem Tem Horas Faturáveis	O WorkItem Tem Horas Faturáveis
*BillableTimeBilledByUser*	Horas Faturáveis Cobradas pelo Usuário	Horas Faturáveis Cobradas pelo Usuário
*IncidentStatusDuration*	Duração do Status do Incidente	Duração do Status do Incidente
*IncidentResolutionByUser*	Resolução de Incidente pelo Usuário	Resolução de Incidente pelo Usuário
*IncidentPrimaryUser*	Usuário Principal do Incidente	Usuário Principal do Incidente
*IncidentIsAboutConfigItem*	Incident Is About Config Item	Incident Is About Config Item
*IncidentCreatedByUser*	Incidente Criado pelo Usuário	Incidente Criado pelo Usuário
*IncidentAssignedToUser*	Incidente Atribuído ao Usuário	Incidente Atribuído ao Usuário
*IncidentAffectedByUser*	Incidente Afetado pelo Usuário	Incidente Afetado pelo Usuário
*IncidentRelatesToConfigItem*	Incidente Relacionado ao Item de Configuração	Incidente Relacionado ao Item de Configuração
*IncidentRelatesToWorkItem*	Incidente Relacionado ao Item de Trabalho	Incidente Relacionado ao Item de Trabalho
*IncidentHasBillableTime*	O Incidente Tem Horas Faturáveis	O Incidente Tem Horas Faturáveis
*IncidentRelatesToProblem*	Incidente Relacionado ao Problema	Incidente Relacionado ao Problema
*IncidentSLAInstanceInformation*	Informações da Instância de SLA do Incidente	Informações da Instância de SLA do Incidente
*IncidentIsAboutService*	O Incidente é sobre o Serviço	O Incidente é sobre o Serviço
*ProblemResolutionByUser*	Resolução de Problemas pelo Usuário	Resolução de Problemas pelo Usuário
*ProblemIsAboutConfigItem*	Problem Is About Config Item	Problem Is About Config Item
*ProblemCreatedByUser*	Problema Criado pelo Usuário	Problema Criado pelo Usuário
*ProblemAssignedToUser*	Problema Atribuído ao Usuário	Problema Atribuído ao Usuário
*ProblemAffectedByUser*	Problema Afetado pelo Usuário	Problema Afetado pelo Usuário
*ProblemRelatesToConfigItem*	Problema Relacionado ao Item de Configuração	Problema Relacionado ao Item de Configuração
*ProblemRelatesToWorkItem*	Problema Relacionado ao Item de Trabalho	Problema Relacionado ao Item de Trabalho
*ProblemHasBillableTime*	O Problema Tem Horas Faturáveis	O Problema Tem Horas Faturáveis
*ProblemSLAInstanceInformation*	Informações da Instância de SLA do Problema	Informações da Instância de SLA do Problema
*ReleaseIsAboutConfigItem*	Release Is About Config Item	Release Is About Config Item
*ReleaseCreatedByUser*	Liberação Criada pelo Usuário	Liberação Criada pelo Usuário
*ReleaseAssignedToUser*	Liberação Atribuída ao Usuário	Liberação Atribuída ao Usuário
*ReleaseSLAInstanceInformation*	Informações da Instância de SLA de Liberação	Informações da Instância de SLA de Liberação
*WorkItemIsAboutComputer*	WorkItem Is About Computer	WorkItem Is About Computer
*WorkItemIsAboutService*	WorkItem Is About Service	WorkItem Is About Service
*ServiceContainsConfigItem*	O Serviço Contém o ConfigItem	O Serviço Contém o ConfigItem
*ServiceContainsComputer*	O Serviço Contém o Computador	O Serviço Contém o Computador
*IncidentsResolvedCount*	Contagem de Incidentes Resolvidos	Contagem de Incidentes Resolvidos
*IncidentsResolvedWithinTargetResolutionTimeCount*	Incidentes Resolvidos Dentro da Contagem de Tempo de Resolução de Destino	Incidentes Resolvidos Dentro da Contagem de Tempo de Resolução de Destino
*IncidentsResolutionTimeInHoursSum*	Soma em Horas do Tempo de Resolução de Incidentes	Soma em Horas do Tempo de Resolução de Incidentes
*IncidentsPastTargetResolutionTimeCount*	Contagem de Incidentes que Ultrapassaram o Tempo de Resolução de Destino	Contagem de Incidentes que Ultrapassaram o Tempo de Resolução de Destino
*ReleasesImplementedOnScheduleCount*	Contagem Implementada de Liberações em Agenda	Contagem Implementada de Liberações em Agenda
*TimeWorkedSum*	Soma do Tempo Trabalhado	Soma do Tempo Trabalhado