28 May 2014

Measure -- System Center Cube

You can use custom measures to aggregate and display data based on numeric attributes from dimensions. Service Manager does not support custom measures based on facts. Continuing with the example of he Named Calculation above, Service Manager defines a custom measure on IncidentsPastTargetResolutionTime as the following:

<Measure ID="IncidentsPastTargetResolutionTimeCount" Target="IncidentDW!IncidentDim" Type="Sum" Property="IncidentsPastTargetResolutionTime"/>
Reviewing this XML code, the target of the measure is the IncidentDimension and the specific property is IncidentsPastTargetResolutionTime. This is the custom property that was defined previously. Custom measures can target either native or calculated properties in the dimension.

Finally, the measure type is defined to be a sum. Possible values for a measure type include Sum and Count. Because of performance considerations, Service Manager Distinct Count measure types are not allowed. The following table describes measure attributes.

Attribute
Required
Values
Definition
ID
Yes
String
Name of the measure
Target
Yes
Management Pack Dimension
The target dimension for the measure
Property
Yes
String
The targeted dimension property
Type
No
(Count, Sum)
The type of the measure

No comments:

Post a Comment