Cambio y cubo de administración de actividades

SystemCenterChangeAndActivityManagementCube (SystemCenterCube)

Element properties:

CustomMDX	SystemCenterCACubeMDX

CustomMDX

Cube Localization:

Source Code:

<SystemCenterCube ID="SystemCenterChangeAndActivityManagementCube">

  <MeasureGroups>

    <!--Substitions for Workitem-->

    <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="WorkItemRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="WorkItemRelatesToWorkItemDateDim"/>

    <!--Activity Related facts-->

    <MeasureGroup ID="ActivityIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ActivityIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="ActivityCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ActivityCreatedByUserDateDim"/>

    <MeasureGroup ID="ActivityAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ActivityAssignedToUserDateDim"/>

    <MeasureGroup ID="ActivityRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="ActivityRelatesToWorkItemDateDim"/>

    <MeasureGroup ID="ActivityIsAboutComputer" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ActivityIsAboutComputerDateDim"/>

    <!--ChangeRequest Related facts-->

    <MeasureGroup ID="ChangeRequestIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ChangeRequestIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="ChangeRequestCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ChangeRequestCreatedByUserDateDim"/>

    <MeasureGroup ID="ChangeRequestAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ChangeRequestAssignedToUserDateDim"/>

    <MeasureGroup ID="ChangeRequestRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="ChangeRequestRelatesToWorkItemDateDim"/>

    <MeasureGroup ID="ChangeRequestContainsActivity" Fact="ActivityDW!WorkItemContainsActivityFact" DateDimAlias="ChangeRequestContainsActivityDateDim"/>

    <MeasureGroup ID="ChangeRequestIsAboutComputer" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ChangeRequestIsAboutComputerDateDim"/>

    <!--Review Related facts-->

    <MeasureGroup ID="ReviewActivityHasReviewer" Fact="ActivityDW!ReviewActivityHasReviewerFact" DateDimAlias="ReviewActivityHasReviewerDateDim"/>

    <MeasureGroup ID="ReviewerIsReviewerUser" Fact="ActivityDW!ReviewerIsUserFact" DateDimAlias="ReviewerIsReviewerUserDateDim"/>

    <MeasureGroup ID="ReviewerVotedByUser" Fact="ActivityDW!ReviewerVotedByUserFact" DateDimAlias="ReviewerVotedByUserDateDim"/>

    <!--Review Activity Related facts-->

    <MeasureGroup ID="ReviewActivityRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="ReviewActivityRelatesToConfigItemDateDim"/>

    <MeasureGroup ID="ReviewActivityAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ReviewActivityAssignedToUserDateDim"/>

    <MeasureGroup ID="ReviewActivityCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ReviewActivityCreatedByUserDateDim"/>

    <!--Rest-->

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

    <MeasureGroup ID="ActivityRelatesToChangeRequest" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="ActivityRelatesToChangeRequestDateDim"/>

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

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

  </MeasureGroups>

  <Substitutions>

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

    <!-- Substitutions for Activity-->

    <Substitution MeasureGroupName="ActivityIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ActivityCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ActivityAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ActivityRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ActivityIsAboutComputer" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

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

    <!-- Substitutions for ChangeRequest-->

    <Substitution MeasureGroupName="ChangeRequestIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ChangeRequestCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ChangeRequestAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ChangeRequestRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ChangeRequestContainsActivity" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="Activity!System.WorkItemContainsActivity" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ChangeRequestContainsActivity" TargetDimension="ActivityDW!ActivityDim" AliasTargetDimensionAs="ActivityDim" Relationship="Activity!System.WorkItemContainsActivity" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ChangeRequestIsAboutComputer" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

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

    <!--Substitution for Reviews-->

    <Substitution MeasureGroupName="ReviewActivityHasReviewer" TargetDimension="ActivityDW!ActivityDim" AliasTargetDimensionAs="ActivityDim" Relationship="Activity!System.ReviewActivityHasReviewer" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ReviewActivityHasReviewer" TargetDimension="ActivityDW!ReviewerDim" AliasTargetDimensionAs="ReviewerDim" Relationship="Activity!System.ReviewActivityHasReviewer" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ReviewerIsReviewerUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ReviewerUserDim" Relationship="Activity!System.ReviewerIsUser" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ReviewerVotedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ReviewerUserDim" Relationship="Activity!System.ReviewerVotedByUser" RelationshipEndPoint="Target"/>

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

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

    <Substitution MeasureGroupName="ActivityRelatesToChangeRequest" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ActivityRelatesToChangeRequest" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ChangeDW!ChangeRequestDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Target"/>

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

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

  </Substitutions>

  <CustomMDX>SystemCenterCACubeMDX</CustomMDX>

  <NamedCalculations>

    <NamedCalculation ID="ChangeRequestsImplemented" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>( case when ( Status = 'ChangeStatusEnum.Completed' ) then 1 else 0 end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequestsImplementedOnSchedule" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>( case when (  Status = 'ChangeStatusEnum.Completed' AND ActualEndDate &lt;= ScheduledEndDate ) then 1 else 0 end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="EmergencyChangeRequests" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>( case when ( Category ='ChangeCategoryEnum.Emergency' ) then 1 else 0 end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ProcessTimePerChangeInDays" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <!-- Calculation>ROUND(DATEDIFF(HH, ActualStartDate, ActualEndDate) * 1./24, 2 ) -->

      <Calculation>(DATEDIFF(HH, ActualStartDate, ActualEndDate)/24)</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ActivitiesImplemented" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>( case when ( Status = 'ActivityStatusEnum.Completed' ) then 1 else 0 end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ActivitiesImplementedOnSchedule" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>( case when ( Status = 'ActivityStatusEnum.Completed' AND ActualEndDate &lt;= ScheduledEndDate ) then 1 else 0 end )</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_CreatedDate__DateKey" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), CreatedDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ScheduledStartDate__DateKey" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ScheduledStartDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ScheduledEndDate__DateKey" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ScheduledEndDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActualStartDate__DateKey" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ActualStartDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActualEndDate__DateKey" Target="ChangeDW!ChangeRequestDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ActualEndDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActivityCreatedDate__DateKey" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), CreatedDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActivityScheduledStartDate__DateKey" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ScheduledStartDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActivityScheduledEndDate__DateKey" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ScheduledEndDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActivityActualStartDate__DateKey" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ActualStartDate, 112),'20000101')</Calculation>

    </NamedCalculation>

    <NamedCalculation ID="ChangeRequest_ActivityActualEndDate__DateKey" Target="ActivityDW!ActivityDim" ColumnType="Int">

      <Calculation>isNull(CONVERT(nvarchar(8), ActualEndDate, 112),'20000101')</Calculation>

    </NamedCalculation>

  </NamedCalculations>

  <Measures>

    <Measure ID="ChangeRequestsImplementedCount" Target="ChangeDW!ChangeRequestDim" Type="Sum" Property="ChangeRequestsImplemented"/>

    <Measure ID="ChangeRequestsImplementedOnScheduleCount" Target="ChangeDW!ChangeRequestDim" Type="Sum" Property="ChangeRequestsImplementedOnSchedule"/>

    <Measure ID="EmergencyChangeRequestsCount" Target="ChangeDW!ChangeRequestDim" Type="Sum" Property="EmergencyChangeRequests"/>

    <Measure ID="ProcessTimePerChangeInDaysSum" Target="ChangeDW!ChangeRequestDim" Type="Sum" Property="ProcessTimePerChangeInDays"/>

    <Measure ID="ActivitiesImplementedCount" Target="ActivityDW!ActivityDim" Type="Sum" Property="ActivitiesImplemented"/>

    <Measure ID="ActivitiesImplementedOnScheduleCount" Target="ActivityDW!ActivityDim" Type="Sum" Property="ActivitiesImplementedOnSchedule"/>

  </Measures>

  <ManyToManyRelationships>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ChangeRequestIsAboutConfigItem" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ChangeRequestDim" IntermediateMeasureGroup="ChangeRequestIsAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ActivityIsAboutConfigItem" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ActivityDim" IntermediateMeasureGroup="ActivityIsAboutConfigItem"/>

  </ManyToManyRelationships>

</SystemCenterCube>

*WorkItemIsAboutConfigItem*	WorkItem Is About ConfigItem	WorkItem Is About ConfigItem
*WorkItemCreatedByUser*	Elemento de trabajo creado por el usuario	Elemento de trabajo creado por el usuario
*WorkItemAssignedToUser*	Elemento de trabajo asignado al usuario	Elemento de trabajo asignado al usuario
*WorkItemRelatesToWorkItem*	El elemento de trabajo está relacionado con el elemento de trabajo	El elemento de trabajo está relacionado con el elemento de trabajo
*ActivityIsAboutConfigItem*	Activity Is About ConfigItem	Activity Is About ConfigItem
*ActivityCreatedByUser*	Actividad creada por el usuario	Actividad creada por el usuario
*ActivityAssignedToUser*	Actividad asignada al usuario	Actividad asignada al usuario
*ActivityRelatesToWorkItem*	La actividad está relacionada con el elemento de trabajo	La actividad está relacionada con el elemento de trabajo
*ActivityIsAboutComputer*	Activity Is About Computer	Activity Is About Computer
*ChangeRequestIsAboutConfigItem*	Change Request Is About Config Item	Change Request Is About Config Item
*ChangeRequestCreatedByUser*	Solicitud de cambio creada por el usuario	Solicitud de cambio creada por el usuario
*ChangeRequestAssignedToUser*	Solicitud de cambio asignada al usuario	Solicitud de cambio asignada al usuario
*ChangeRequestRelatesToWorkItem*	La solicitud de cambio está relacionada con el elemento de trabajo	La solicitud de cambio está relacionada con el elemento de trabajo
*ChangeRequestContainsActivity*	La solicitud de cambio contiene la actividad	La solicitud de cambio contiene la actividad
*ChangeRequestIsAboutComputer*	Change Request Is About Computer	Change Request Is About Computer
*ReviewActivityHasReviewer*	La actividad de revisión tiene un revisor	La actividad de revisión tiene un revisor
*ReviewerIsReviewerUser*	El revisor es un usuario revisor	El revisor es un usuario revisor
*ReviewerVotedByUser*	Revisor votado por el usuario	Revisor votado por el usuario
*ReviewActivityRelatesToConfigItem*	La actividad de revisión está relacionada con el elemento de configuración	La actividad de revisión está relacionada con el elemento de configuración
*ReviewActivityAssignedToUser*	Actividad de revisión asignada al usuario	Actividad de revisión asignada al usuario
*ReviewActivityCreatedByUser*	Actividad de revisión creada por el usuario	Actividad de revisión creada por el usuario
*WorkItemIsAboutComputer*	Work Item Is About Computer	Work Item Is About Computer
*ActivityRelatesToChangeRequest*	La actividad está relacionada con la solicitud de cambio	La actividad está relacionada con la solicitud de cambio
*ServiceContainsConfigItem*	El servicio contiene el elemento de configuración	El servicio contiene el elemento de configuración
*ServiceContainsComputer*	El servicio contiene el equipo	El servicio contiene el equipo
*ChangeRequestsImplementedCount*	Número de solicitudes de cambio implementadas	Número de solicitudes de cambio implementadas
*ChangeRequestsImplementedOnScheduleCount*	Número de solicitudes de cambio implementadas de programación	Número de solicitudes de cambio implementadas de programación
*EmergencyChangeRequestsCount*	Número de solicitudes de cambio de emergencia	Número de solicitudes de cambio de emergencia
*ProcessTimePerChangeInDaysSum*	Suma de tiempo de proceso por cambio en días	Suma de tiempo de proceso por cambio en días
*ActivitiesImplementedCount*	Número de actividades implementadas	Número de actividades implementadas
*ActivitiesImplementedOnScheduleCount*	Número de actividades implementadas de programación	Número de actividades implementadas de programación