ServiceManagerChargebackCubeMDX (Resource)

Element properties:

Source Code:

<Resource ID="ServiceManagerChargebackCubeMDX" Accessibility="Public" FileName="ServiceManagerChargebackCube.MDX.txt"/>

File Content: ServiceManagerChargebackCube.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.





SCOPE_ISOLATION=CUBE








*/


CALCULATE;





/********************************************/


/******** Chargeback Daily Fact *************/


/********************************************/





/******* Custom measures for usage count *******/


CREATE MEMBER CURRENTCUBE.[Measures].[Count: Cores (Days)]


    AS


    (


        [Measures].[CoresCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [CoresCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Count: Mem(GB) (Days)]


    AS


    (


        ([Measures].[MemoryCountMeasure]) / 1024


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [MemoryCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Count: Storage(GB) (Days)]


    AS


    (


        ([Measures].[StorageCountMeasure]) / 1024


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [StorageCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Count: Dynamical VHDs (Days)]


    AS


    (


        [Measures].[DynamicalVHDTypeCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [DynamicalVHDTypeCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Count: High Availabile VMs (Days)]


    AS


    (


        [Measures].[HighAvailabilityCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [HighAvailabilityCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Count: Static IPs (Days)]


    AS


    (


        [Measures].[StaticIPCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [StaticIPCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[VM Days]


    AS


    (


        [Measures].[ServiceManagerInfraDailyChargebackCount]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraDailyChargebackCount] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';








/******* Custom measures for usage cost *******/


CREATE MEMBER CURRENTCUBE.[Measures].[VM Cost]


    AS


    (


        [Measures].[CoresCostMeasure]


        + [Measures].[MemoryTotalCostMeasure]


        + [Measures].[StorageTotalCostMeasure]


        + [Measures].[HighAvailabilityCostMeasure]


        + [Measures].[DynamicalVHDTypeCostMeasure]


        + [Measures].[StaticIPCostMeasure]


        + [Measures].[VMBaseCostMeasure]


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [CoresCostMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Cloud Cost]


    AS


    (


        [Measures].[PrivateCloudMembershipCostMeasure]


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [PrivateCloudMembershipCostMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[VM Total Cost]


    AS


    (


        [Measures].[CoresCostMeasure]


        + [Measures].[MemoryTotalCostMeasure]


        + [Measures].[StorageTotalCostMeasure]


        + [Measures].[HighAvailabilityCostMeasure]


        + [Measures].[DynamicalVHDTypeCostMeasure]


        + [Measures].[StaticIPCostMeasure]


        + [Measures].[VMBaseCostMeasure]


        + [Measures].[PrivateCloudMembershipCostMeasure]


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [CoresCostMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraDailyChargeback';











/********************************************/


/******** Chargeback Monthly Fact ***********/


/********************************************/





/******* Custom measures for usage count *******/


CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Count: Cores (Days)]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_CoresCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_CoresCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Count: Mem(GB) (Days)]


    AS


    (


        ([Measures].[ServiceManagerInfraMonthlyChargeback_MemoryCountMeasure]) / 1024


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_MemoryCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Count: Storage(GB) (Days)]


    AS


    (


        ([Measures].[ServiceManagerInfraMonthlyChargeback_StorageCountMeasure]) / 1024


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_StorageCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Count: Dynamical VHDs (Days)]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_DynamicalVHDTypeCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_DynamicalVHDTypeCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Count: High Availabile VMs (Days)]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_HighAvailabilityCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_HighAvailabilityCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Count: Static IPs (Days)]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_StaticIPCountMeasure]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_StaticIPCountMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly VM Days]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargebackCount]


    )


    ,FORMAT_STRING = "#,##0"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargebackCount] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';








/******* Custom measures for usage cost *******/


CREATE MEMBER CURRENTCUBE.[Measures].[Monthly VM Cost]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_CoresCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_MemoryTotalCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_StorageTotalCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_HighAvailabilityCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_DynamicalVHDTypeCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_StaticIPCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_VMBaseCostMeasure]


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_CoresCostMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly Cloud Cost]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_PrivateCloudMembershipCostMeasure]


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_PrivateCloudMembershipCostMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';





CREATE MEMBER CURRENTCUBE.[Measures].[Monthly VM Total Cost]


    AS


    (


        [Measures].[ServiceManagerInfraMonthlyChargeback_CoresCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_MemoryTotalCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_StorageTotalCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_HighAvailabilityCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_DynamicalVHDTypeCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_StaticIPCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_VMBaseCostMeasure]


        + [Measures].[ServiceManagerInfraMonthlyChargeback_PrivateCloudMembershipCostMeasure]


    )


    ,FORMAT_STRING = "#,##0.00"


    ,NON_EMPTY_BEHAVIOR = { [ServiceManagerInfraMonthlyChargeback_CoresCostMeasure] }


    ,VISIBLE = 1


    ,ASSOCIATED_MEASURE_GROUP = 'ServiceManagerInfraMonthlyChargeback';