/*
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].[Physical Computers]
AS [Measures].[DeployedComputerDimCount],
FORMAT_STRING = "Standard",
NON_EMPTY_BEHAVIOR = { [DeployedComputerDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'DeployedComputerDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Virtual Computers]
AS IIF(IsError([ComputerDim].[IsVirtualMachine].&[True]), NULL , ([Measures].[ComputerDimCount], [ComputerDim].[IsVirtualMachine].&[True])),
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ComputerDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ComputerDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Avg Processor Speed]
AS IIF( [Measures].[ProcessorDimCount] > 0, [Measures].[ProcessorDim_TotalProcessorSpeed]/[Measures].[ProcessorDimCount], NULL),
FORMAT_STRING = "Standard",
NON_EMPTY_BEHAVIOR = { [ProcessorDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ProcessorDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Number of Processors]
AS [Measures].[ProcessorDimCount],
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ProcessorDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ProcessorDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Config Items]
AS [Measures].[ConfigItemDimCount],
FORMAT_STRING = "Standard",
NON_EMPTY_BEHAVIOR = { [ConfigItemDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ConfigItemDim';
Home