SystemCenterCatalogCubeMDX (Resource)

Element properties:

Source Code:

<Resource ID="SystemCenterCatalogCubeMDX" Accessibility="Public" FileName="SystemCenterServiceCatalogCube.MDX.txt"/>

File Content: SystemCenterServiceCatalogCube.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].[Activities Created]


 AS [Measures].[ActivityDimCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ActivityDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ActivityDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[Completed Activities]


 AS ([Measures].[ActivityDimCount], [ActivityStatus].[OutriggerID].&[ActivityStatusEnum.Completed]), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ActivityDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ActivityDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[Service Requests Opened]


 AS [Measures].[ServiceRequestDimCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[Completed Service Requests]


 AS ([Measures].[ServiceRequestDimCount], [ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.Completed] ), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[Canceled Service Requests]


 AS ([Measures].[ServiceRequestDimCount], [ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.Canceled] ), 


FORMAT_STRING = "0", 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';      


 


CREATE MEMBER CURRENTCUBE.[Measures].[Failed Service Requests]


 AS ([Measures].[ServiceRequestDimCount],[ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.Failed] ), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[In Progress Service Requests]


 AS ([Measures].[ServiceRequestDimCount],[ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.InProgress] ), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim'; 


 


CREATE MEMBER CURRENTCUBE.[Measures].[Closed Service Requests]


 AS ([Measures].[ServiceRequestDimCount],[ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.Closed] ), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[Submitted Service Requests]


 AS ([Measures].[ServiceRequestDimCount],[ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.Submitted] ), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';       





CREATE MEMBER CURRENTCUBE.[Measures].[On Hold Service Requests]


 AS ([Measures].[ServiceRequestDimCount],[ServiceRequestStatus].[OutriggerID].&[ServiceRequestStatusEnum.OnHold] ), 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';   





CREATE MEMBER CURRENTCUBE.[Measures].[Service Request Status % of Total]


 AS IIF(([Measures].[ServiceRequestDimCount], [ServiceRequestStatus].[All]) > 0, 


      (([ServiceRequestStatus].[OutriggerID].CurrentMember, [Measures].[ServiceRequestDimCount]) / ([Measures].[ServiceRequestDimCount], [ServiceRequestStatus].[All])), 


   NULL), 


FORMAT_STRING = "Percent", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim'  ;       





CREATE MEMBER CURRENTCUBE.[Measures].[Reviewers]


 AS [Measures].[ReviewerDimCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ReviewerDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ReviewerDim';      





CREATE MEMBER CURRENTCUBE.[Measures].[Votes]


 AS [Measures].[ReviewerVotedByUserCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ReviewerVotedByUserCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ReviewerVotedByUser';     





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


 AS [Measures].[ServiceRequestIsAboutConfigItemCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestIsAboutConfigItemCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestIsAboutConfigItem';     





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


 AS [Measures].[ServiceRequestRelatesToWorkItemCount], 


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestRelatesToWorkItemCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestRelatesToWorkItem'; 





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


AS Exists


      (        


        [ServiceRequestDim].[DisplayName].MEMBERS,


       ,"ServiceRequestSLAInstanceInformation"


      ).Count


       - 


      Exists


      (       


        [ServiceRequestDim].[DisplayName].MEMBERS,


       {


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


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


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


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


        }


       ,"ServiceRequestSLAInstanceInformation"


      ).Count


,


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';





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


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


FORMAT_STRING = "0", 


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';





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


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


FORMAT_STRING = "Percent",


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';





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


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


FORMAT_STRING = "Percent",


NON_EMPTY_BEHAVIOR = { [ServiceRequestDimCount] }, 


VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'ServiceRequestDim';