Datová krychle s daty pro řízení spotřeby
CustomMDX | SystemCenterPowerManagementCubeMDX |
ComputerHostsOperatingSystem | Počítač hostuje operační systém | Počítač hostuje operační systém |
DeployedComputerRunsWindowsComputer | V nasazeném počítači běží počítač se systémem Windows | V nasazeném počítači běží počítač se systémem Windows |
ConfigManagerCollectionHasComputer | Kolekce ConfigManager má počítač | Kolekce ConfigManager má počítač |
PowerActivityDay | Den aktivity napájení | Den aktivity napájení |
ServiceContainsConfigItem | Služba obsahuje položku konfigurace | Služba obsahuje položku konfigurace |
ServiceContainsComputer | Služba obsahuje počítač | Služba obsahuje počítač |
<SystemCenterCube ID="SystemCenterPowerManagementCube">
<MeasureGroups>
<MeasureGroup ID="ComputerHostsOperatingSystem" Fact="DWBase!ComputerHostsOperatingSystemFact" DateDimAlias="ComputerHostsOperatingSystemDateDim"/>
<MeasureGroup ID="DeployedComputerRunsWindowsComputer" Fact="DWConfigMgr!DeployedComputerRunsWindowsComputerFact" DateDimAlias="DeployedComputerRunsWindowsComputerDateDim"/>
<MeasureGroup ID="ConfigManagerCollectionHasComputer" Fact="DWConfigMgr!ConfigurationManagerCollectionHasComputer" DateDimAlias="ConfigManagerCollectionHasComputerDateDim"/>
<MeasureGroup ID="PowerActivityDay" Fact="DWConfigMgr!PowerActivityDayFact" DateDimAlias="PowerActivityDayDateDim"/>
<MeasureGroup ID="ServiceContainsConfigItem" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsConfigItemDateDim"/>
<MeasureGroup ID="ServiceContainsComputer" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsComputerDateDim"/>
</MeasureGroups>
<Substitutions>
<Substitution MeasureGroupName="ComputerHostsOperatingSystem" TargetDimension="DWBase!ComputerDim" AliasTargetDimensionAs="ComputerDim" Relationship="Windows!Microsoft.Windows.ComputerHostsOperatingSystem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ComputerHostsOperatingSystem" TargetDimension="DWBase!OperatingSystemDim" AliasTargetDimensionAs="OperatingSystemDim" Relationship="Windows!Microsoft.Windows.ComputerHostsOperatingSystem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="DeployedComputerRunsWindowsComputer" TargetDimension="DWBase!ComputerDim" AliasTargetDimensionAs="ComputerDim" Relationship="ConfigMgr!Microsoft.SystemCenter.ConfigurationManager.DeployedComputerRunsWindowsComputer" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ConfigManagerCollectionHasComputer" TargetDimension="DWConfigMgr!ConfigurationManagerCollectionDim" AliasTargetDimensionAs="ConfigurationManagerCollectionDim" Relationship="ConfigMgr!Microsoft.SystemCenter.ConfigurationManager.CollectionHasConfigItem" RelationshipEndPoint="Source"/>
<Substitution MeasureGroupName="ConfigManagerCollectionHasComputer" TargetDimension="DWBase!ComputerDim" AliasTargetDimensionAs="ComputerDim" Relationship="ConfigMgr!Microsoft.SystemCenter.ConfigurationManager.CollectionHasConfigItem" RelationshipEndPoint="Target"/>
<Substitution MeasureGroupName="ServiceContainsComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim"/>
</Substitutions>
<CustomMDX>SystemCenterPowerManagementCubeMDX</CustomMDX>
<ManyToManyRelationships>
<ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="PowerActivityDay" IntermediateMeasureGroup="ServiceContainsComputer"/>
</ManyToManyRelationships>
</SystemCenterCube>