SystemCenterCACubeMDX (Resource)
Element properties:
Source Code:
<Resource ID="SystemCenterCACubeMDX" Accessibility="Public" FileName="SystemCenterChangeAndActivityManagementCube.MDX.txt"/>
File Content: SystemCenterChangeAndActivityManagementCube.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], [ActivityDim_ActivityStatus].[OutriggerID].&[ActivityStatusEnum.Completed]),
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ActivityDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ActivityDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Change Requests Opened]
AS [Measures].[ChangeRequestDimCount],
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Completed Changes]
AS ([Measures].[ChangeRequestDimCount], [ChangeRequestDim_ChangeStatus].[OutriggerID].&[ChangeStatusEnum.Completed]),
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Cancelled Changes]
AS ([Measures].[ChangeRequestDimCount], [ChangeRequestDim_ChangeStatus].[OutriggerID].&[ChangeStatusEnum.Cancelled]),
FORMAT_STRING = "0",
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Failed Changes]
AS ([Measures].[ChangeRequestDimCount], [ChangeRequestDim_ChangeStatus].[OutriggerID].&[ChangeStatusEnum.Failed]),
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim' ;
CREATE MEMBER CURRENTCUBE.[Measures].[In Progress Changes]
AS ([Measures].[ChangeRequestDimCount], [ChangeRequestDim_ChangeStatus].[OutriggerID].&[ChangeStatusEnum.InProgress]),
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim' ;
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 Computers]
AS ([Measures].[WorkItemIsAboutComputerCount]),
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [WorkItemIsAboutComputerCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'WorkItemIsAboutComputer';
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].[Related Work Items]
AS [Measures].[WorkItemRelatesToWorkItemCount],
FORMAT_STRING = "0",
NON_EMPTY_BEHAVIOR = { [WorkItemRelatesToWorkItemCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'WorkItemRelatesToWorkItem';
CREATE MEMBER CURRENTCUBE.[Measures].[Change Requests Implemented On Schedule Percentage]
AS IIF( [Measures].[ChangeRequestDim_ChangeRequestsImplementedCount] >0, ([Measures].[ChangeRequestDim_ChangeRequestsImplementedOnScheduleCount]/[Measures].[ChangeRequestDim_ChangeRequestsImplementedCount]), NULL),
FORMAT_STRING = "Percent",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Emergency Change Request Percentage]
AS IIF([Measures].[ChangeRequestDimCount] > 0, ([Measures].[ChangeRequestDim_EmergencyChangeRequestsCount]/[Measures].[ChangeRequestDimCount]), NULL),
FORMAT_STRING = "Percent",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Average Process Time Per Change (Days)]
AS IIF([Measures].[ChangeRequestDim_ChangeRequestsImplementedCount] >0, ([Measures].[ChangeRequestDim_ProcessTimePerChangeInDaysSum]/[Measures].[ChangeRequestDim_ChangeRequestsImplementedCount]), NULL),
FORMAT_STRING = "Standard",
NON_EMPTY_BEHAVIOR = { [ChangeRequestDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ChangeRequestDim';
CREATE MEMBER CURRENTCUBE.[Measures].[Activities Implemented On Schedule Percentage]
AS IIF([Measures].[ActivityDim_ActivitiesImplementedCount] >0, ([Measures].[ActivityDim_ActivitiesImplementedOnScheduleCount]/[Measures].[ActivityDim_ActivitiesImplementedCount]), NULL),
FORMAT_STRING = "Percent",
NON_EMPTY_BEHAVIOR = { [ActivityDimCount] },
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'ActivityDim';
Home