SystemCenterWorkItemsCubeMDX (Resource)

Element properties:

Source Code:

<Resource ID="SystemCenterWorkItemsCubeMDX" Accessibility="Public" FileName="SystemCenterWorkItemsCube.MDX.txt"/>

File Content: SystemCenterWorkItemsCube.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].[Incidents Opened]


AS [Measures].[IncidentDimCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';     


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Resolved Within Target Resolution Time Percentage]


 AS IIF( [Measures].[IncidentDim_IncidentsResolvedCount] > 0,  ([Measures].[IncidentDim_IncidentsResolvedWithinTargetResolutionTimeCount]/[Measures].[IncidentDim_IncidentsResolvedCount]), NULL), 


FORMAT_STRING = "Percent", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';          


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Automatically Resolved By Problem]


  AS ([Measures].[IncidentDimCount], [IncidentResolutionCategory].[OutriggerID].&[IncidentResolutionCategoryEnum.ResolvedByProblem]), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';     


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Average Resolution Time (Hours)]


 AS IIF( [Measures].[IncidentDim_IncidentsResolvedCount] > 0,  ([Measures].[IncidentDim_IncidentsResolutionTimeInHoursSum]/[Measures].[IncidentDim_IncidentsResolvedCount]), NULL), 


FORMAT_STRING = "Standard", 


NON_EMPTY_BEHAVIOR = { [IncidentDim_IncidentsResolvedCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';        


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Escalated]


AS IIF( IsError([IncidentDim].[Escalated].&[True]), NULL,  ([Measures].[IncidentDimCount], [IncidentDim].[Escalated].&[True] )), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';     


CREATE MEMBER CURRENTCUBE.[Measures].[Average Time Worked (Hours)]


 AS IIF( [Measures].[IncidentHasBillableTimeCount] > 0, ([Measures].[BillableTimeDim_TimeWorkedSum]/(60 * [Measures].[IncidentHasBillableTimeCount])), NULL ), 


FORMAT_STRING = "Standard", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentHasBillableTime';     


CREATE MEMBER CURRENTCUBE.[Measures].[Average Time In Status (Hours)]


 AS IIF( [Measures].[IncidentStatusDurationCount] > 0, ([Measures].[TotalTimeMeasure]/(60 * [Measures].[IncidentStatusDurationCount])), NULL), 


FORMAT_STRING = "Standard", 


NON_EMPTY_BEHAVIOR = { [IncidentStatusDurationCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentStatusDuration';          


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Active]


 AS (([Measures].[IncidentDimCount], [IncidentStatus].[OutriggerID].&[IncidentStatusEnum.Active])


+


([Measures].[IncidentDimCount], [IncidentStatus].[OutriggerID].&[IncidentStatusEnum.Active.Pending])), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';          


CREATE MEMBER CURRENTCUBE.[Measures].[Problems Created]


AS [Measures].[ProblemDimCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ProblemDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ProblemDim';          


CREATE MEMBER CURRENTCUBE.[Measures].[Problems Closed]


 AS ([Measures].[ProblemDimCount], [ProblemStatus].[OutriggerID].&[ProblemStatusEnum.Closed]), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ProblemDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ProblemDim';       


CREATE MEMBER CURRENTCUBE.[Measures].[Avg Incidents Linked Per Problem]


 AS IIF ( [Measures].[ProblemDimCount] > 0 , ([Measures].[IncidentRelatesToProblemCount]/[Measures].[ProblemDimCount]), NULL ), 


FORMAT_STRING = "Standard", 


NON_EMPTY_BEHAVIOR = { [IncidentRelatesToProblemCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';        


CREATE MEMBER CURRENTCUBE.[Measures].[Avg Incidents Per Config Item]


 AS IIF( [Measures].[ConfigItemDimCount] > 0, [Measures].[IncidentIsAboutConfigItemCount]/[Measures].[ConfigItemDimCount], NULL), 


FORMAT_STRING = "Standard", 


NON_EMPTY_BEHAVIOR = { [IncidentIsAboutConfigItemCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';        


CREATE MEMBER CURRENTCUBE.[Measures].[Impacted Config Items]


 AS [Measures].[WorkItemIsAboutConfigItemCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [WorkItemIsAboutConfigItemCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'WorkItemIsAboutConfigItem';       


CREATE MEMBER CURRENTCUBE.[Measures].[Impacted Computers]


 AS [Measures].[WorkItemIsAboutComputerCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [WorkItemIsAboutComputerCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'WorkItemIsAboutComputer';       


CREATE MEMBER CURRENTCUBE.[Measures].[Impacted Services]


 AS [Measures].[WorkItemIsAboutServiceCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [WorkItemIsAboutServiceCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'WorkItemIsAboutService';       


CREATE MEMBER CURRENTCUBE.[Measures].[Releases Created]


 AS [Measures].[ReleaseDimCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ReleaseDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ReleaseDim';       


CREATE MEMBER CURRENTCUBE.[Measures].[Releases Implemented]


 AS ([Measures].[ReleaseDimCount], [ReleaseStatus].[OutriggerID].&[ReleaseStatusEnum.Completed]), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ReleaseDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ReleaseDim';


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Meeting All SLOs]


AS Exists


      (        


        [IncidentDim].[DisplayName].MEMBERS,


       ,"IncidentSLAInstanceInformation"


      ).Count


       - 


      Exists


      (       


        [IncidentDim].[DisplayName].MEMBERS,


       {


          [SlaInstanceStatus].[OutriggerID].&[SLAInstance.Status.Breached]


         ,[SlaInstanceStatus].[OutriggerID].&[SLAInstance.Status.Active]


         ,[SlaInstanceStatus].[OutriggerID].&[SLAInstance.Status.Warning]


         ,[SlaInstanceStatus].[OutriggerID].&[SLAInstance.Status.NotReady]


        }


       ,"IncidentSLAInstanceInformation"


      ).Count


,


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Breaching At Least One SLO]


AS ([Measures].[IncidentDimCount], [SlaInstanceStatus].[OutriggerID].&[SLAInstance.Status.Breached]),


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Meeting Meeting All SLOs Percentage]


AS IIF( ([Measures].[Incidents Meeting All SLOs] + [Measures].[Incidents Breaching At Least One SLO] ) > 0,  [Measures].[Incidents Meeting All SLOs]/([Measures].[Incidents Meeting All SLOs] + [Measures].[Incidents Breaching At Least One SLO] ), NULL), 


FORMAT_STRING = "Percent",


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';


CREATE MEMBER CURRENTCUBE.[Measures].[Incidents Breaching SLO Percentage]


AS IIF( ([Measures].[Incidents Meeting All SLOs] + [Measures].[Incidents Breaching At Least One SLO] ) > 0,  [Measures].[Incidents Breaching At Least One SLO]/([Measures].[Incidents Meeting All SLOs] + [Measures].[Incidents Breaching At Least One SLO] ), NULL), 


FORMAT_STRING = "Percent",


NON_EMPTY_BEHAVIOR = { [IncidentDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'IncidentDim';