CAST Engineering Dashboard - Contribution or weight - Incorrect contribution value

This page helps to troubleshoot issues when the Contribution of the Quality Rule is incorrect on dashboard.

For example the contribution should be equal to 100% in the case when the consolidation mode is using a full application mode. The following screenshot illustrate an unexpected behavior:

Figure 1

Step by Step scenario

1. Run analysis
2. Compute snapshot
3. Open CED

1. Validate if the contribution displayed on the CED is correct -
   Depending on the consolidation mode and Number of modules, the contribution will be as follows:

   Consolidation Mode	Number of Modules	Contribution
   Full Application	One Full content	100%
   Other legacy modes based on averages of modules	N	(100/N)%

   For more detail refer to Investigation - Quality Model Drilldown

2. If the displayed contribution on CED is wrong then Get the SQL query for the "RETRIEVER_RULE_INVEST_TCRIT_TABLE" using the following pages  - CAST Engineering Dashboard - Information - Configuring Dashboard to SQL trace and CAST Engineering Dashboard - Information - Configuring Dashboard to show the retriever name

3. Compare the query retrieved from the previous point with the following:

   SELECT res.metric_id, 
          /* id de la metrique fille */ 
          res.curgrade, 
          /* grade de la metrique fille dans le snapshot courant */ 
          ( 
          CASE res.prevgrade 
                 WHEN 0 THEN 100 
                 ELSE(res.curgrade - res.prevgrade) / res.prevgrade * 100 
          END), 
          /* grade variation de la metrique fille par rapport au snapshot precedent */ 
          res.aggregate_weight, 
          /* poids de la metrique fille dans la metrique mere */ 
          CASE %object_type% 
                 WHEN -102 THEN 
                        /* Compute consolidation percentage when object is an application */ 
                        CASE res.weight_metric 
                               WHEN 0 THEN 1 
                               WHEN 1 THEN 
                                      ( 
                                             SELECT res.module_weight / 
                                                    CASE res.total_weight 
                                                           WHEN 0 THEN 1 
                                                           ELSE res.total_weight 
                                                    END 
                                             FROM   %prefix%viewer_dual ) 
                        END 
                 WHEN 20000 THEN 1 
                        /* Consolidation percentage is always 1 when object is a module */ 
          END, 
          res.metric_critical, 
          /* 1 si la metrique fille est critique pour la metrique mere */ 
          ( 
                 SELECT d.metric_description 
                 FROM   %prefix%dss_metric_descriptions d 
                 WHERE  d.metric_id = res.metric_id 
                 AND    d.description_type_id = 0 
                 AND    d.language = ''%languageid%'' ) 
          /* TC Name */

   
   

   1. If the query matches the above select query then contact CAST Technical Support. with the following Relevant input

   2. If the query does not match the above select query then perform the bellow steps -

      
      

      1. Execute the following query under the central schema:

         UPDATE viewer_parameters 
         SET    value = 
         ' select  res.METRIC_ID,     /* id de la metrique fille */  res.CURGRADE,     /* grade de la metrique fille dans le snapshot courant */     (case res.PREVGRADE         when 0         then 100         else(res.CURGRADE - res.PREVGRADE) / res.PREVGRADE * 100     end),     /* grade variation de la metrique fille par rapport au snapshot precedent */  res.AGGREGATE_WEIGHT,    /* poids de la metrique fille dans la metrique mere */  case %object_type%         when -102         then             /* Compute consolidation percentage when object is an application */             case res.WEIGHT_METRIC                 when 0                 then 1                 when 1                 then                     (select                         res.MODULE_WEIGHT / case res.TOTAL_WEIGHT when 0 then 1 else res.TOTAL_WEIGHT end                     from                         %PREFIX%VIEWER_DUAL                     )             end         when 20000         then 1 /* Consolidation percentage is always 1 when object is a module */     end,     res.METRIC_CRITICAL,    /* 1 si la metrique fille est critique pour la metrique mere */     (select         d.METRIC_DESCRIPTION     from         %PREFIX%DSS_METRIC_DESCRIPTIONS d     where         d.METRIC_ID = res.METRIC_ID         and d.DESCRIPTION_TYPE_ID = 0         and d.LANGUAGE = ''%languageid%''     )    /* TC Name */     '
         WHERE  id = 'SELECT_QUERY_1' 
                AND component_id = 'RETRIEVER_RULE_INVEST_TCRIT_TABLE' 

      2. Restart tomcat application

      3. Open CED

      4. Navigate to the view FRAME_PORTAL_INVESTIGATION_VIEW and observe if the issue is fixed
         

      Note that this a known bug that is fixed in AIP 8.2.10.
      
      

4. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input

Ticket # 10366