The contribution measure used in crosstab KPI shows wrong values. Why?

• Related Articles

• The contribution measure used in the cross tab KPI shows wrong values

  As per the functionality, the contribution measure works in cross tab KPI only when the cross tab total is applied.

• Expression measure considers measure IDs instead of measure names and hence values appear as 0 in KPI grid. How can this be corrected?

  This problem has occurred because the measure IDs are not defined properly in the below expression measure. CASE WHEN (SUM(C3508)+SUM(C3505)+SUM(C3507)) 0 THEN ROUND((SUM(FLOAT(C3506))/(SUM(FLOAT(C3508))+SUM(FLOAT(3505))+SUM(FLOAT(3507))))*100,2) ...

• Linked dimension is not working, while adding a measure to the KPI. It shows the error 'Suitable dimension is not available for the selected measure." Why?

  Ensure that the details (example, table names, column names etc) defined in the 'dbmodel.xml' file matches with those in the database. For example, if a table name for a dimension in the database is in UPPERCASE, the dimension name defined in ...

• Can I use a % Contribution Measure in cross-tab?

  Yes, you can. Set 'Yes' option in the Cross Tab Total utility.

• Does Expression measure for Net Sales contribution% work?

  Other than the base measures, any measure will not work in Expression measure. This is the current product functionality. Since Net sales Contribution% is a contribution measure, it should not be used in the filter expression.