アラート管理キューブ

SystemCenterAlertManagementCube (SystemCenterCube)

アラート管理データに関するキューブ

Element properties:

CustomMDX	SystemCenterAlertCubeMDX

CustomMDX

Cube Localization:

*AlertAboutConfigItem*	構成アイテムに関するアラート	構成アイテムに関するアラート
*AlertResolutionState*	ResolutionState アラート	ResolutionState アラート
*ServiceContainsConfigItem*	サービスが構成アイテムを含む	サービスが構成アイテムを含んでいます
*ServiceContainsComputer*	サービスがコンピューターを含む	サービスがコンピューターを含んでいます
*GroupContainsConfigItem*	グループがコンピューターを含む	グループが構成アイテムを含んでいます
*GroupContainsComputer*	グループがコンピューターを含む	グループがコンピューターを含んでいます

Source Code:

<SystemCenterCube ID="SystemCenterAlertManagementCube">

  <MeasureGroups>

    <MeasureGroup ID="AlertAboutConfigItem" Fact="DWOM!AlertInstanceFact" DateDimAlias="AlertAboutConfigItemDateDim"/>

    <MeasureGroup ID="AlertResolutionState" Fact="DWOM!AlertResolutionStateFact" DateDimAlias="AlertResolutionStateDateDim"/>

    <MeasureGroup ID="ServiceContainsConfigItem" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsConfigItemDateDim"/>

    <MeasureGroup ID="ServiceContainsComputer" Fact="DWBase!ServiceContainsConfigItemFact" DateDimAlias="ServiceContainsComputerDateDim"/>

    <MeasureGroup ID="GroupContainsConfigItem" Fact="DWBase!GroupContainsConfigItemFact" DateDimAlias="GroupContainsConfigItemDateDim"/>

    <MeasureGroup ID="GroupContainsComputer" Fact="DWBase!GroupContainsConfigItemFact" DateDimAlias="GroupContainsComputerDateDim"/>

  </MeasureGroups>

  <Substitutions>

    <Substitution MeasureGroupName="AlertAboutConfigItem" TargetDimension="DWBase!EntityDim" ReplacementDimension="DWBase!ConfigItemDim" AliasReplacementDimensionAs="ConfigItemDim"/>

    <Substitution MeasureGroupName="ServiceContainsComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim"/>

    <Substitution MeasureGroupName="GroupContainsComputer" TargetDimension="DWBase!ConfigItemDim" ReplacementDimension="DWBase!ComputerDim" AliasReplacementDimensionAs="ComputerDim"/>

  </Substitutions>

  <CustomMDX>SystemCenterAlertCubeMDX</CustomMDX>

  <ManyToManyRelationships>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="AlertAboutConfigItem" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="GroupDim" TargetMeasureGroup="AlertAboutConfigItem" IntermediateMeasureGroup="GroupContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="ServiceDim" TargetMeasureGroup="AlertResolutionState" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="GroupDim" TargetMeasureGroup="AlertResolutionState" IntermediateMeasureGroup="GroupContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="ConfigItemDim" TargetMeasureGroup="AlertResolutionState" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="RuleDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="ManagementPackDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertDim" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="RuleDim" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="ManagementPackDim" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="ResolutionStateDim" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="ResolutionStateDim" TargetMeasureGroup="AlertAboutConfigItem" IntermediateMeasureGroup="AlertResolutionState"/>

    <ManyToManyRelationship CubeDimension="ResolutionStateDim" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="ResolutionStateDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertPriority" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertPriority" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertSeverity" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertSeverity" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="GroupDim" TargetMeasureGroup="ServiceContainsConfigItem" IntermediateMeasureGroup="GroupContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="GroupDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertPriority" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertSeverity" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

    <ManyToManyRelationship CubeDimension="ServiceContainsConfigItemDateDim" TargetMeasureGroup="ServiceDim" IntermediateMeasureGroup="ServiceContainsConfigItem"/>

    <ManyToManyRelationship CubeDimension="AlertAboutConfigItemDateDim" TargetMeasureGroup="ConfigItemDim" IntermediateMeasureGroup="AlertAboutConfigItem"/>

  </ManyToManyRelationships>

</SystemCenterCube>