SystemCenterSoftwareUpdateCubeMDX (Resource)

Element properties:

TypeResource
File NameSystemCenterSoftwareUpdateCube.MDX.txt
AccessibilityPublic

Source Code:

<Resource ID="SystemCenterSoftwareUpdateCubeMDX" Accessibility="Public" FileName="SystemCenterSoftwareUpdateCube.MDX.txt"/>

File Content: SystemCenterSoftwareUpdateCube.MDX.txt

/*

The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/
CALCULATE;
CREATE MEMBER CURRENTCUBE.[Measures].[Required]
AS [Measures].[ComputerHasSoftwareUpdateCount],
FORMAT_STRING = "Standard",
NON_EMPTY_BEHAVIOR = { [ComputerHasSoftwareUpdateCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ComputerHasSoftwareUpdate';
CREATE MEMBER CURRENTCUBE.[Measures].[Security Update Compliance]
AS IIF( ( [Measures].[IsInstalled] + [Measures].[IsMissing] ) > 0, [Measures].[IsInstalled] / ( [Measures].[IsInstalled] + [Measures].[IsMissing] ), NULL),
FORMAT_STRING = "Percent",
NON_EMPTY_BEHAVIOR = { [ComputerHasSoftwareUpdateCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ComputerHasSoftwareUpdate' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Security Bulletin Compliance]
AS IIF ( ([IsInstalled Without Security Bulletin] + [IsMissing Without Security Bulletin]) >0, [IsInstalled Without Security Bulletin]/([IsInstalled Without Security Bulletin] + [IsMissing Without Security Bulletin]), NULL ),
FORMAT_STRING = "Percent",
NON_EMPTY_BEHAVIOR = { [ComputerHasSoftwareUpdateCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ComputerHasSoftwareUpdate' ;
CREATE MEMBER CURRENTCUBE.[Measures].[IsInstalled Without Security Bulletin]
AS ( [Measures].[IsInstalled], [SoftwareUpdateDim].[BulletinID].&[]),
NON_EMPTY_BEHAVIOR = { [ComputerHasSoftwareUpdateCount] },
VISIBLE = 0;
CREATE MEMBER CURRENTCUBE.[Measures].[IsMissing Without Security Bulletin]
AS ([Measures].[IsMissing], [SoftwareUpdateDim].[BulletinID].&[]),
NON_EMPTY_BEHAVIOR = { [ComputerHasSoftwareUpdateCount] },
VISIBLE = 0;