Datová krychle pro aktualizaci softwaru

SystemCenterSoftwareUpdateCube (SystemCenterCube)

Element properties:

CustomMDX	SystemCenterSoftwareUpdateCubeMDX

CustomMDX

Cube Localization:

*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
*ConfigurationManagerCollectionHasComputer*	Kolekce ConfigurationManager má počítač	Kolekce ConfigurationManager má počítač
*ComputerHasSoftwareUpdate*	Počítač má aktualizaci softwaru	Počítač má aktualizaci softwaru
*ServiceContainsConfigItem*	Služba obsahuje položku konfigurace	Služba obsahuje položku konfigurace
*ServiceContainsComputer*	Služba obsahuje počítač	Služba obsahuje počítač

Source Code:

<SystemCenterCube ID="SystemCenterSoftwareUpdateCube">

  <MeasureGroups>

    <MeasureGroup ID="ComputerHostsOperatingSystem" Fact="DWBase!ComputerHostsOperatingSystemFact" DateDimAlias="ComputerHostsOperatingSystemDateDim"/>

    <MeasureGroup ID="DeployedComputerRunsWindowsComputer" Fact="DWConfigMgr!DeployedComputerRunsWindowsComputerFact" DateDimAlias="DeployedComputerRunsWindowsComputerDateDim"/>

    <MeasureGroup ID="ConfigurationManagerCollectionHasComputer" Fact="DWConfigMgr!ConfigurationManagerCollectionHasComputer" DateDimAlias="ConfigurationManagerCollectionHasComputerDateDim"/>

    <MeasureGroup ID="ComputerHasSoftwareUpdate" Fact="DWConfigMgr!ComputerHasSoftwareUpdateInstalledFact" DateDimAlias="ComputerHasSoftwareUpdateDateDim"/>

    <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="ConfigurationManagerCollectionHasComputer" TargetDimension="DWConfigMgr!ConfigurationManagerCollectionDim" AliasTargetDimensionAs="ConfigurationManagerCollectionDim" Relationship="ConfigMgr!Microsoft.SystemCenter.ConfigurationManager.CollectionHasConfigItem" RelationshipEndPoint="Source"/>

    <Substitution MeasureGroupName="ConfigurationManagerCollectionHasComputer" 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>SystemCenterSoftwareUpdateCubeMDX</CustomMDX>

  <ManyToManyRelationships>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="ComputerHasSoftwareUpdate" IntermediateMeasureGroup="ServiceContainsComputer"/>

  </ManyToManyRelationships>

</SystemCenterCube>