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



Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)




RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
CSS1(tick)




If you are comparing grades, do the following twice for each snapshot. Otherwise, if you are validating the grade value, you will do the following only once for your snapshot

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