CAST Engineering Dashboard - Information - How to compute the metric grade at system level

The page describes the computation of the metric grade at system level. Computation need to be done on the central Database.

Factor impacting the metric grade computation for system level

The factors used for the metric grade computation at system level are

1. Usage of aggregation Weight metric
2. The metric grade of each application belonging to the system

Compute the metric grade

1. Get the ID of the metric used for module weight using following query

   SELECT OPTION_VALUE FROM <CB_NAME>.SYS_SITE_OPTIONS WHERE OPTION_NAME = 'ADG_CENTRAL_WEIGHT_METRIC'

2. If a metric is used as aggregation Weight, get values used to weight application grades into system grades using following query:

   SELECT DMR.METRIC_NUM_VALUE as "WEIGHT", AP.OBJECT_ID as "APP_ID", AP.OBJECT_NAME as "APP_NAME", DMR.SNAPSHOT_ID as "SNAPSHOT_ID"
   FROM <CB_NAME>.DSS_OBJECTS AP, <CB_NAME>.DSS_METRIC_RESULTS DMR,<CB_NAME>.DSS_LINKS DL
   WHERE DMR.METRIC_ID = <WEIGHT_METRIC_ID> AND DMR.METRIC_VALUE_INDEX = 1 
   AND DMR.OBJECT_ID = AP.OBJECT_ID AND DL.PREVIOUS_OBJECT_ID = <SYSTEM_ID> 
   AND DL.NEXT_OBJECT_ID = AP.OBJECT_ID AND AP.OBJECT_TYPE_ID = -102 AND DL.LINK_TYPE_ID = 1

3. Get the metric grade of each application belonging to the system: Connect to the dashboard and read these values

4. If a metric is used as aggregation Weight

   the metric grade at system level = SUM (<WEIGHT_OF_APPLICATION_ID>*<METRIC_GRADE_OF_APPLICATION_ID>)/SUM(<WEIGHT_OF_APPLICATION_ID>)

5. If no metric is used as aggregation Weight

   the metric grade at system level = SUM (<METRIC_GRADE_OF_APPLICATION_ID>)/NUMBER_OF_APPLICATION