경고 관리 큐브

SystemCenterAlertManagementCube (SystemCenterCube)

경고 관리 데이터에 대한 큐브

Element properties:

CustomMDX	SystemCenterAlertCubeMDX

CustomMDX

Cube Localization:

*AlertAboutConfigItem*	구성 항목에 대한 경고	구성 항목에 대한 경고
*AlertResolutionState*	경고 해결 상태	경고 해결 상태
*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>