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

Purpose

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

Applicable in CAST Version

Applicable RDBMS

Details

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:

   ```sql
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

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

Notes/comments

Related Pages