CAST Engineering Dashboard - Contribution or weight - Incorrect contribution value

Purpose (problem description)

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

Observed in CAST AIP

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
CSS✅

Step by Step scenario

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

Action Plan

  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 ModeNumber of ModulesContribution
    Full ApplicationOne Full content100%
    Other legacy modes based on averages of modulesN(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](https://help.castsoftware.com/hc/en-us/requests/new). with the following [Relevant input](/export-v2/tg/technical-guides/technical-guides-by-cast-aip-component/cast-engineering-dashboard-component-ced/cast-engineering-dashboard-contribution-or-weight/)
   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:

         ```sql
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  
     ![](https://doc-data.castsoftware.com/TG/attachments/566538568/566538567.png)

  Note that this a known bug that is fixed in AIP 8.2.10.
  1. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input

Notes/comments

Ticket # 10366

Related Pages