ServiceManagerComplianceCube (SystemCenterCube)

Source Code:

<SystemCenterCube ID="ServiceManagerComplianceCube">

  <MeasureGroups>

    <!--Program related facts-->

    <MeasureGroup Fact="ComplianceDW!ProgramHasCategoriesFact" ID="ProgramHasCategories" DateDimAlias="ProgramHasCategoriesDateDim"/>

    <MeasureGroup Fact="ComplianceDW!CategoryHasCOFact" ID="CategoryHasCO" DateDimAlias="CategoryHasCODateDim"/>

    <MeasureGroup Fact="ComplianceResultDW!ProgramHasResultFact" ID="ProgramHasResult" DateDimAlias="ProgramHasResultDateDim"/>

    <!--Control Objective related facts -->

    <MeasureGroup Fact="ComplianceDW!COHasCAFact" ID="COHasCA" DateDimAlias="COHasCADateDim"/>

    <MeasureGroup Fact="ComplianceResultDW!ControlObjectiveHasResultFact" ID="ControlObjectiveHasResult" DateDimAlias="ControlObjectiveHasResultDateDim"/>

    <!--Control Activity related facts-->

    <MeasureGroup Fact="ComplianceDW!ComplianceControlActivityApplicabilityGroupFact" ID="ComplianceControlActivityApplicabilityGroup" DateDimAlias="ComplianceControlActivityApplicabilityGroupDateDim"/>

    <MeasureGroup Fact="ComplianceResultDW!ControlActivityHasResultFact" ID="ControlActivityHasResult" DateDimAlias="ControlActivityHasResultDateDim"/>

    <!--Applicability Group Related facts-->

    <MeasureGroup Fact="ComplianceDW!ApplicableGroupConfigItemFact" ID="ApplicableGroupConfigItem" DateDimAlias="ApplicableGroupConfigItemDateDim"/>

    <!--MERResult facts-->

    <MeasureGroup Fact="ComplianceDW!ManagedEntityResultFact" ID="ManagedEntityResult" DateDimAlias="ManagedEntityResultDateDim"/>

  </MeasureGroups>

  <Substitutions>

    <!-- Subsitutions for Program-->

    <Substitution MeasureGroupName="ProgramHasCategories" TargetDimension="ComplianceDW!ProgramDim" AliasTargetDimensionAs="ProgramDim" Relationship="Compliance!System.Compliance.ProgramHasCategory" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ProgramHasCategories" TargetDimension="ComplianceDW!CategoryDim" AliasTargetDimensionAs="CategoryDim" Relationship="Compliance!System.Compliance.ProgramHasCategory" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="CategoryHasCO" TargetDimension="ComplianceDW!CategoryDim" AliasTargetDimensionAs="CategoryDim" Relationship="Compliance!System.Compliance.CategoryContainsControlObjective" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="CategoryHasCO" TargetDimension="ComplianceDW!ControlObjectiveDim" AliasTargetDimensionAs="ControlObjectiveDim" Relationship="Compliance!System.Compliance.CategoryContainsControlObjective" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ProgramHasResult" TargetDimension="ComplianceDW!ProgramDim" AliasTargetDimensionAs="ProgramDim"/>

    <!-- Subsitutions for Control Objective-->

    <Substitution MeasureGroupName="COHasCA" TargetDimension="ComplianceDW!ControlObjectiveDim" AliasTargetDimensionAs="ControlObjectiveDim" Relationship="Compliance!System.Compliance.ControlObjectiveContainsControlActivity" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="COHasCA" TargetDimension="ComplianceDW!ControlActivityDim" AliasTargetDimensionAs="ControlActivityDim" Relationship="Compliance!System.Compliance.ControlObjectiveContainsControlActivity" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ControlObjectiveHasResult" TargetDimension="ComplianceDW!ControlObjectiveDim" AliasTargetDimensionAs="ControlObjectiveDim"/>

    <!-- Subsitutions for Control Activity-->

    <Substitution MeasureGroupName="ComplianceControlActivityApplicabilityGroup" TargetDimension="ComplianceDW!ControlActivityDim" AliasTargetDimensionAs="ControlActivityDim" Relationship="Compliance!System.Compliance.ControlActivityApplicabilityGroup" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ComplianceControlActivityApplicabilityGroup" TargetDimension="ComplianceDW!ApplicabilityGroupDim" AliasTargetDimensionAs="ApplicabilityGroupDim" Relationship="Compliance!System.Compliance.ControlActivityApplicabilityGroup" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="ControlActivityHasResult" TargetDimension="ComplianceDW!ControlActivityDim" AliasTargetDimensionAs="ControlActivityDim"/>

    <!-- Subsitutions for Applicable group-->

    <Substitution MeasureGroupName="ApplicableGroupConfigItem" TargetDimension="ComplianceDW!ApplicabilityGroupDim" AliasTargetDimensionAs="ApplicabilityGroupDim" Relationship="GroupLibrary!Microsoft.SystemCenter.InstanceGroupContainsEntities" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ApplicableGroupConfigItem" TargetDimension="DWBase!ConfigItemDim" AliasTargetDimensionAs="ConfigItemDim" Relationship="GroupLibrary!Microsoft.SystemCenter.InstanceGroupContainsEntities" RelationshipEndPoint="Target"/>

  </Substitutions>

</SystemCenterCube>