Alert Management Cube

SystemCenterAlertManagementCube (SystemCenterCube)

Cube about Alert Management data

Element properties:

CustomMDX	SystemCenterAlertCubeMDX

CustomMDX

Cube Localization:

*AlertAboutConfigItem*	Alert About Config Item	Alert About Config Item
*AlertResolutionState*	Alert ResolutionState	Alert ResolutionState
*ServiceContainsConfigItem*	Service Contains Config Item	Service Contains Config Item
*ServiceContainsComputer*	Service Contains Computer	Service Contains Computer
*GroupContainsConfigItem*	Group Contains Computer	Group Contains ConfigItem
*GroupContainsComputer*	Group Contains Computer	Group Contains Computer

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>