Cloud Services Cube

CloudServicesCube (SystemCenterCube)

Cube Localization:

*TenantContainsSubscriptionMeasure*	Tenant Contains Cloud Resources Subscription	Tenant Contains Cloud Resources Subscription
*TenantHasAdminsMeasure*	Tenant Has Admins	Tenant Has Admins
*TenantHasCostCenterMeasure*	Tenant Has Cost Center	Tenant Has Cost Center
*SubscriptionRelatesToLogicalNetworkMeasure*	Cloud Resources Subscription Relates To Logical Networks	Cloud Resources Subscription Relates To Logical Networks
*SubscriptionRelatesToVMTemplateMeasure*	Cloud Resources Subscription Relates To VM Templates	Cloud Resources Subscription Relates To VM Templates
*SubscriptionRelatesToServiceTemplateMeasure*	Cloud Resources Subscription Relates To Service Templates	Cloud Resources Subscription Relates To Service Templates
*SubscriptionRelatesToResourceCriteriaMeasure*	Cloud Resources Subscription Relates To Resource Criteria	Cloud Resources Subscription Relates To Resource Criteria
*SubscriptionHasUsersMeasure*	Cloud Resources Subscription Has Users	Cloud Resources Subscription Has Users
*SubscriptionRelatesToVirtualMachineMeasure*	Cloud Resources Subscription Relates To Virtual Machines	Cloud Resources Subscription Relates To Virtual Machines
*VMCostSettingsDailyMeasure*	VM Cost Settings Daily Measure	VM Cost Settings Daily Measure
*VirtualMachineDailyMeasure*	Virtual Machine Daily Measure	Virtual Machine Daily Measure
*VirtualMachineCostMeasure*	Virtual Machine Cost Measure	Virtual Machine Cost Measure

Source Code:

<SystemCenterCube ID="CloudServicesCube">

  <MeasureGroups>

    <!--Tenant Measure Group-->

    <MeasureGroup ID="TenantContainsSubscriptionMeasure" Fact="CloudServicesDataWarehouse!CloudServicesTenantContainsSubscriptionFact" DateDimAlias="TenantContainsSubscriptionMeasureDateDim"/>

    <MeasureGroup ID="TenantHasAdminsMeasure" Fact="CloudServicesDataWarehouse!CloudServicesTenantHasAdminsFact" DateDimAlias="TenantHasAdminsMeasureDateDim"/>

    <MeasureGroup ID="TenantHasCostCenterMeasure" Fact="CloudServicesDataWarehouse!CloudServicesTenantHasCostCenterFact" DateDimAlias="TenantHasCostCenterMeasureDateDim"/>

    <!--Subscription Measure Group-->

    <MeasureGroup ID="SubscriptionRelatesToLogicalNetworkMeasure" Fact="CloudServicesDataWarehouse!CloudServicesSubscriptionRelatesToLogicalNetworkFact" DateDimAlias="SubscriptionRelatesToLogicalNetworkMeasureDateDim"/>

    <MeasureGroup ID="SubscriptionRelatesToVMTemplateMeasure" Fact="CloudServicesDataWarehouse!CloudServicesSubscriptionRelatesToVMTemplateFact" DateDimAlias="SubscriptionRelatesToVMTemplateMeasureDateDim"/>

    <MeasureGroup ID="SubscriptionRelatesToServiceTemplateMeasure" Fact="CloudServicesDataWarehouse!CloudServicesSubscriptionRelatesToServiceTemplateFact" DateDimAlias="SubscriptionRelatesToServiceTemplateMeasureDateDim"/>

    <MeasureGroup ID="SubscriptionRelatesToResourceCriteriaMeasure" Fact="CloudServicesDataWarehouse!CloudServicesSubscriptionToResourceCriteriaFact" DateDimAlias="SubscriptionRelatesToResourceCriteriaMeasureDateDim"/>

    <MeasureGroup ID="SubscriptionHasUsersMeasure" Fact="CloudServicesDataWarehouse!CloudServicesSubscriptionHasUsersFact" DateDimAlias="SubscriptionHasUsersMeasureDateDim"/>

    <MeasureGroup ID="SubscriptionRelatesToVirtualMachineMeasure" Fact="CloudServicesDataWarehouse!CloudServicesSubscriptionRelatesToVirtualMachineFact" DateDimAlias="SubscriptionRelatesToVirtualMachineMeasureDateDim"/>

    <!--Virtual Machine NMeasure Group-->

    <MeasureGroup ID="VMCostSettingsDailyMeasure" Fact="CloudServicesDataWarehouse!CloudServicesVMCostSettingsDailyFact" DateDimAlias="VMCostSettingsDailyMeasureDateDim"/>

    <MeasureGroup ID="VirtualMachineDailyMeasure" Fact="CloudServicesDataWarehouse!CloudServicesVirtualMachineDailyFact" DateDimAlias="VirtualMachineDailyMeasureDateDim"/>

    <MeasureGroup ID="VirtualMachineCostMeasure" Fact="CloudServicesDataWarehouse!CloudServicesVirtualMachineSummaryFact" DateDimAlias="VirtualMachineCostMeasureDateDim"/>

  </MeasureGroups>

  <Substitutions>

    <!--Tenant Substituion-->

    <Substitution MeasureGroupName="TenantContainsSubscriptionMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesTenantDim" AliasTargetDimensionAs="CloudServicesTenantDim" Relationship="CloudServices!ServiceManager.CloudServices.TenantContainsSubscription" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="TenantContainsSubscriptionMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.TenantContainsSubscription" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="TenantHasAdminsMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesTenantDim" AliasTargetDimensionAs="CloudServicesTenantDim" Relationship="CloudServices!ServiceManager.CloudServices.TenantHasAdmins" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="TenantHasAdminsMeasure" TargetDimension="CloudServicesDataWarehouse!MicrosoftADUserBaseDim" AliasTargetDimensionAs="CloudServicesAdminsDim" Relationship="CloudServices!ServiceManager.CloudServices.TenantHasAdmins" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="TenantHasCostCenterMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesTenantDim" AliasTargetDimensionAs="CloudServicesTenantDim" Relationship="CloudServices!ServiceManager.CloudServices.TenantHasCostCenter" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="TenantHasCostCenterMeasure" TargetDimension="CloudServicesDataWarehouse!SystemCostCenterDim" AliasTargetDimensionAs="CloudServicesCostCenterDim" Relationship="CloudServices!ServiceManager.CloudServices.TenantHasCostCenter" RelationshipEndPoint="Target"/>

    <!--Subscription Substitution-->

    <Substitution MeasureGroupName="SubscriptionRelatesToLogicalNetworkMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToLogicalNetwork" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToLogicalNetworkMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesLogicalNetworkDim" AliasTargetDimensionAs="CloudServicesLogicalNetworkDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToLogicalNetwork" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToVMTemplateMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToVMTemplate" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToVMTemplateMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesVMTemplateDim" AliasTargetDimensionAs="CloudServicesVMTemplateDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToVMTemplate" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToServiceTemplateMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToServiceTemplate" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToServiceTemplateMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesServiceTemplateDim" AliasTargetDimensionAs="CloudServicesServiceTemplateDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToServiceTemplate" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToResourceCriteriaMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToResourceCriteria" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToResourceCriteriaMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesResourceCriteriaDim" AliasTargetDimensionAs="CloudServicesResourceCriteriaDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToResourceCriteria" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SubscriptionHasUsersMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionHasUsers" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SubscriptionHasUsersMeasure" TargetDimension="CloudServicesDataWarehouse!MicrosoftADUserBaseDim" AliasTargetDimensionAs="CloudServicesSubscriptionUsersDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionHasUsers" RelationshipEndPoint="Target"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToVirtualMachineMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesSubscriptionDim" AliasTargetDimensionAs="CloudServicesSubscriptionDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToVirtualMachine" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="SubscriptionRelatesToVirtualMachineMeasure" TargetDimension="CloudServicesDataWarehouse!CloudServicesVirtualMachineDim" AliasTargetDimensionAs="CloudServicesVirtualMachineDim" Relationship="CloudServices!ServiceManager.CloudServices.SubscriptionRelatesToVirtualMachine" RelationshipEndPoint="Target"/>

  </Substitutions>

</SystemCenterCube>