Service Manager Service Catalog Library Cubes

SystemCenterServiceCatalogCube (SystemCenterCube)

Element properties:

CustomMDX	SystemCenterCatalogCubeMDX

CustomMDX

Cube Localization:

*SLAConfigurationHasMetric*	SLA Configuration Has Metric	SLA Configuration Has Metric
*SLAConfigurationHasCalendar*	SLA Configuration Has Calendar	SLA Configuration Has Calendar
*ActivityIsAboutConfigItem*	Activity Is About Config Item	Activity Is About Config Item
*ActivityCreatedByUser*	Activity Created By User	Activity Created By User
*ActivityAssignedToUser*	Activity Assigned To User	Activity Assigned To User
*ActivityRelatesToConfigItem*	Activity Relates To ConfigItem	Activity Relates To ConfigItem
*ActivityRelatesToWorkItem*	Activity Relates To WorkItem	Activity Relates To WorkItem
*ActivityStatusDuration*	Activity Status Duration	Activity Status Duration
*ReviewActivityHasReviewer*	Review Activity Has Reviewer	Review Activity Has Reviewer
*ReviewerIsReviewerUser*	Reviewer Is Reviewer User	Reviewer Is Reviewer User
*ReviewerVotedByUser*	Reviewer Voted By User	Reviewer Voted By User
*ReviewActivityRelatesToConfigItem*	Review Activity Relates To ConfigItem	Review Activity Relates To ConfigItem
*ReviewActivityAssignedToUser*	Review Activity Assigned To User	Review Activity Assigned To User
*ReviewActivityCreatedByUser*	Review Activity Created By User	Review Activity CreatedBy User
*WorkItemGroupContainsServiceRequest*	WorkItem Group Contains Service Request	WorkItem Group Contains Service Request
*ServiceRequestIsAboutConfigItem*	Service Request Is About ConfigItem	Service Request Is About ConfigItem
*ServiceRequestCreatedByUser*	Service Request Created By User	Service Request Created By User
*ServiceRequestAssignedToUser*	Service Request Assigned To User	Service Request Assigned To User
*ServiceRequestRelatesToConfigItem*	Service Request Relates To Config Item	Service Request Relates To Config Item
*ServiceRequestRelatesToWorkItem*	Service Request Relates To WorkItem	Service Request Relates To WorkItem
*ServiceRequestAffectedUser*	Service Request Affected User	Service Request Affected User
*ServiceRequestContainsActivity*	Service Request Contains Activity	ServiceRequestContainsActivity
*ServiceRequestStatusDuration*	Service Request Status Duration	Service Request Status Duration
*ServiceRequestSLAInstanceInformation*	Service Request SLA Instance Information	Service Request SLA Instance Information
*ServiceRequestRelatesToRequestOffering*	Service Request Relates To Request Offering	Service Request Relates To Request Offering
*ServiceOfferingRelatesToRequestOffering*	Service Offering Relates To Request Offering	Service Offering Relates To Request Offering
*ServiceOfferingPublishedByUser*	Service Offering Published By User	Service Offering Published By User
*RequestOfferingPublishedByUser*	Request Offering Published By User	Request Offering Published By User
*ServiceOfferingOwner*	Service Offering Owner	Service Offering Owner
*RequestOfferingOwner*	Request Offering Owner	Request Offering Owner
*ServiceRelatesToServiceOffering*	Service Relates To Service Offering	Service Relates To Service Offering

Source Code:

<SystemCenterCube ID="SystemCenterServiceCatalogCube">

  <MeasureGroups>

    <!--SLA related facts -->

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

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

    <!--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="ActivityRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="ActivityRelatesToConfigItemDateDim"/>

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

    <MeasureGroup ID="ActivityStatusDuration" Fact="ActivityDW!ActivityStatusDurationFact" DateDimAlias="ActivityStatusDurationDateDim"/>

    <!--Review Activity 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"/>

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

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

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

    <!-- Service Request Related Facts -->

    <MeasureGroup ID="WorkItemGroupContainsServiceRequest" Fact="DWBase!WorkItemGroupContainsWorkItemFact" DateDimAlias="WorkItemGroupContainsServiceRequestDateDim"/>

    <MeasureGroup ID="ServiceRequestIsAboutConfigItem" Fact="DWBase!WorkItemAboutConfigItemFact" DateDimAlias="ServiceRequestIsAboutConfigItemDateDim"/>

    <MeasureGroup ID="ServiceRequestCreatedByUser" Fact="DWBase!WorkItemCreatedByUserFact" DateDimAlias="ServiceRequestCreatedByUserDateDim"/>

    <MeasureGroup ID="ServiceRequestAssignedToUser" Fact="DWBase!WorkItemAssignedToUserFact" DateDimAlias="ServiceRequestAssignedToUserDateDim"/>

    <MeasureGroup ID="ServiceRequestRelatesToConfigItem" Fact="DWBase!WorkItemRelatesToConfigItemFact" DateDimAlias="ServiceRequestRelatesToConfigItemDateDim"/>

    <MeasureGroup ID="ServiceRequestRelatesToWorkItem" Fact="DWBase!WorkItemRelatesToWorkItemFact" DateDimAlias="ServiceRequestRelatesToWorkItemDateDim"/>

    <MeasureGroup ID="ServiceRequestAffectedUser" Fact="DWBase!WorkItemAffectedUserFact" DateDimAlias="ServiceRequestAffectedUserDateDim"/>

    <MeasureGroup ID="ServiceRequestContainsActivity" Fact="ActivityDW!WorkItemContainsActivityFact" DateDimAlias="ServiceRequestContainsActivityDateDim"/>

    <MeasureGroup ID="ServiceRequestStatusDuration" Fact="ServiceDW!ServiceRequestStatusDurationFact" DateDimAlias="ServiceRequestStatusDurationDateDim"/>

    <MeasureGroup ID="ServiceRequestSLAInstanceInformation" Fact="SLADWLibrary!SLAInstanceInformationFact" DateDimAlias="ServiceRequestSLAInstanceInformationDateDim"/>

    <!-- Service Catalog Related Facts -->

    <!--<MeasureGroup ID="WorkItemRelatesToRequestOffering" Fact="CatalogDW!WorkItemRelatesToRequestOfferingFact"/>-->

    <MeasureGroup ID="ServiceRequestRelatesToRequestOffering" Fact="CatalogDW!WorkItemRelatesToRequestOfferingFact" DateDimAlias="ServiceRequestRelatesToRequestOfferingDateDim"/>

    <MeasureGroup ID="ServiceOfferingRelatesToRequestOffering" Fact="CatalogDW!ServiceOfferingRelatesToRequestOfferingFact" DateDimAlias="ServiceOfferingRelatesToRequestOfferingDateDim"/>

    <MeasureGroup ID="ServiceOfferingPublishedByUser" Fact="CatalogDW!OfferingPublishedByFact" DateDimAlias="ServiceOfferingPublishedByUserDateDim"/>

    <MeasureGroup ID="RequestOfferingPublishedByUser" Fact="CatalogDW!OfferingPublishedByFact" DateDimAlias="RequestOfferingPublishedByUserDateDim"/>

    <MeasureGroup ID="ServiceOfferingOwner" Fact="CatalogDW!OfferingOwnerFact" DateDimAlias="ServiceOfferingOwnerDateDim"/>

    <MeasureGroup ID="RequestOfferingOwner" Fact="CatalogDW!OfferingOwnerFact" DateDimAlias="RequestOfferingOwnerDateDim"/>

    <MeasureGroup ID="ServiceRelatesToServiceOffering" Fact="CatalogDW!ServiceRelatesToServiceOfferingFact" DateDimAlias="ServiceRelatesToServiceOfferingDateDim"/>

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

    <!-- 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="ActivityRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ActivityDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>

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

    <!--Substitutions for Review Activity-->

    <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="ReviewActivityRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ActivityDW!ReviewActivityDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>

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

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

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

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

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

    <!-- Substitutions for Service Request -->

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

    <Substitution MeasureGroupName="WorkItemGroupContainsServiceRequest" TargetDimension="DWBase!WorkItemDim" AliasReplacementDimensionAs="ServiceRequestDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemGroupContainsWorkItems" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ServiceRequestIsAboutConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemAboutConfigItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestCreatedByUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemCreatedByUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestAssignedToUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemAssignedToUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestRelatesToWorkItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemRelatesToWorkItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestRelatesToConfigItem" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemRelatesToConfigItem" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestContainsActivity" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="Activity!System.WorkItemContainsActivity" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestAffectedUser" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="WorkItem!System.WorkItemAffectedUser" RelationshipEndPoint="Source"/>

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

    <Substitution MeasureGroupName="ServiceRequestSLAInstanceInformation" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim"/>

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

    <!-- Substitutions for Service Catalog -->

    <Substitution MeasureGroupName="ServiceRequestRelatesToRequestOffering" TargetDimension="DWBase!WorkItemDim" ReplacementDimension="ServiceDW!ServiceRequestDim" Relationship="Catalog!System.WorkItemRelatesToRequestOffering" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ServiceRequestRelatesToRequestOffering" TargetDimension="CatalogDW!RequestOfferingDim" AliasTargetDimensionAs="RequestOfferingDim" Relationship="Catalog!System.WorkItemRelatesToRequestOffering" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ServiceOfferingRelatesToRequestOffering" TargetDimension="CatalogDW!ServiceOfferingDim" AliasTargetDimensionAs="ServiceOfferingDim" Relationship="Catalog!System.ServiceOfferingRelatesToRequestOffering" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ServiceOfferingRelatesToRequestOffering" TargetDimension="CatalogDW!RequestOfferingDim" AliasTargetDimensionAs="RequestOfferingDim" Relationship="Catalog!System.ServiceOfferingRelatesToRequestOffering" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ServiceOfferingPublishedByUser" TargetDimension="CatalogDW!OfferingDim" ReplacementDimension="CatalogDW!ServiceOfferingDim" Relationship="Catalog!System.OfferingPublishedBy" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ServiceOfferingPublishedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ServiceOfferingPublisherUserDim" Relationship="Catalog!System.OfferingPublishedBy" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="RequestOfferingPublishedByUser" TargetDimension="CatalogDW!OfferingDim" ReplacementDimension="CatalogDW!RequestOfferingDim" Relationship="Catalog!System.OfferingPublishedBy" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="RequestOfferingPublishedByUser" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="RequestOfferingPublisherUserDim" Relationship="Catalog!System.OfferingPublishedBy" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ServiceOfferingOwner" TargetDimension="CatalogDW!OfferingDim" ReplacementDimension="CatalogDW!ServiceOfferingDim" Relationship="Catalog!System.OfferingOwner" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ServiceOfferingOwner" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="ServiceOfferingOwnerDim" Relationship="Catalog!System.OfferingOwner" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="RequestOfferingOwner" TargetDimension="CatalogDW!OfferingDim" ReplacementDimension="CatalogDW!RequestOfferingDim" Relationship="Catalog!System.OfferingOwner" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="RequestOfferingOwner" TargetDimension="DWBase!UserDim" AliasTargetDimensionAs="RequestOfferingOwnerDim" Relationship="Catalog!System.OfferingOwner" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ServiceRelatesToServiceOffering" TargetDimension="DWBase!ServiceDim" AliasTargetDimensionAs="ServiceDim" Relationship="Catalog!System.ServiceRelatesToServiceOffering" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ServiceRelatesToServiceOffering" TargetDimension="CatalogDW!ServiceOfferingDim" AliasTargetDimensionAs="ServiceOfferingDim" Relationship="Catalog!System.ServiceRelatesToServiceOffering" RelationshipEndPoint="Target"/>

  </Substitutions>

  <CustomMDX>SystemCenterCatalogCubeMDX</CustomMDX>

  <NamedCalculations>

    <NamedCalculation ID="ServiceRequest_CreatedDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_CompletedDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ClosedDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ScheduledStartDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ScheduledEndDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ActualStartDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ActualEndDate__DateKey" Target="ServiceDW!ServiceRequestDim" ColumnType="Int">

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

    </NamedCalculation>

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

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

    </NamedCalculation>

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

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

    </NamedCalculation>

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

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

    </NamedCalculation>

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

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

    </NamedCalculation>

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

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ReviewActivityCreatedDate__DateKey" Target="ActivityDW!ReviewActivityDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ReviewActivityScheduledStartDate__DateKey" Target="ActivityDW!ReviewActivityDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ReviewActivityScheduledEndDate__DateKey" Target="ActivityDW!ReviewActivityDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ReviewActivityActualStartDate__DateKey" Target="ActivityDW!ReviewActivityDim" ColumnType="Int">

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

    </NamedCalculation>

    <NamedCalculation ID="ServiceRequest_ReviewActivityActualEndDate__DateKey" Target="ActivityDW!ReviewActivityDim" ColumnType="Int">

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

    </NamedCalculation>

  </NamedCalculations>

  <ManyToManyRelationships>

    <ManyToManyRelationship CubeDimension="ServiceOfferingDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="ServiceRequestRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="RequestOfferingDim" IntermediateMeasureGroup="ServiceOfferingRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ServiceRequestRelatesToRequestOffering" IntermediateMeasureGroup="RequestOfferingDim"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="ServiceRequestRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="ServiceOfferingOwnerDim" TargetMeasureGroup="RequestOfferingDim" IntermediateMeasureGroup="ServiceOfferingRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="ServiceOfferingOwnerDim" TargetMeasureGroup="ServiceRequestRelatesToRequestOffering" IntermediateMeasureGroup="RequestOfferingDim"/>

    <ManyToManyRelationship CubeDimension="ServiceOfferingOwnerDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="ServiceRequestRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="RequestOfferingOwnerDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="ServiceRequestRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="ServiceOfferingPublisherUserDim" TargetMeasureGroup="RequestOfferingDim" IntermediateMeasureGroup="ServiceOfferingRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="ServiceOfferingPublisherUserDim" TargetMeasureGroup="ServiceRequestRelatesToRequestOffering" IntermediateMeasureGroup="RequestOfferingDim"/>

    <ManyToManyRelationship CubeDimension="ServiceOfferingPublisherUserDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="ServiceRequestRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="RequestOfferingPublisherUserDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="ServiceRequestRelatesToRequestOffering"/>

    <ManyToManyRelationship CubeDimension="WorkItemGroupDim" TargetMeasureGroup="ServiceRequestDim" IntermediateMeasureGroup="WorkItemGroupContainsServiceRequest"/>

  </ManyToManyRelationships>

</SystemCenterCube>