Cubo de Gestão de Alertas

SystemCenterAlertManagementCube (SystemCenterCube)

Cubo sobre dados de Gestão de Alertas

Element properties:

CustomMDX	SystemCenterAlertCubeMDX

CustomMDX

Cube Localization:

*AlertAboutConfigItem*	Alerta sobre Item de Configuração	Alerta sobre Item de Configuração
*AlertResolutionState*	Estado de Resolução do Alerta	Estado de Resolução do Alerta
*ServiceContainsConfigItem*	Serviço Contém Item de Configuração	Serviço Contém Item de Configuração
*ServiceContainsComputer*	Serviço Contém Computador	Serviço Contém Computador
*GroupContainsConfigItem*	Grupo Contém Computador	Grupo Contém Item de Configuração
*GroupContainsComputer*	Grupo Contém Computador	Grupo Contém Computador

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>