Even thought Variance (cost of living-MOM) and Variance (holiday Premium-MOM) total columns is checked, why is it not displaying the total value?

• Related Articles

• Why do some of the % measures such as Variance(average Last Salary-MOM),Variance(Average Tenure-MOM) display percentage value more than 100%?

  This problem can occur if GROWTH_CONTRIBUTION column in ADMIN_MEASURES_MASTER table which should be null is mapped to a different Measure ID in the DB. This results in percentage being taken from previous month instead of taking from the total and ...

• Why is the Total column at the top of grid calculating totals for string columns?

  This problem can occur if Total is enabled for the measure. Please check the modify analysis page for the KPI and uncheck the Total and the problem should be fixed.

• Why is the KPI not displaying results and throws an exception - 'java.lang.Exception: Query Execution Failed! : A column has been specified more than once in the order by list. Columns in the order by list must be unique'?

  In case of a crosstab KPI, the KPI fails to execute when the crosstab ORDER BY clause contains two columns. Therefore the columns in the ORDER BY must be unique. Also, please note that the measure ORDER BY should be specified as None as it will not ...

• When I add a base measure with average aggregation, the Total field should show the average value. But why is it showing the sum of that average?

  The sum of the average is displayed in the 'Total' field becauase the functionality is to display the total value and not the average value. When you add a base measure with average aggregation, it considers only the line items and not the 'Total' ...

• While adding a base measure with average aggregation then, the total field should show the average value, but it shows the sum of that average. Why?

  Whenever the aggregate functions are applied, it will consider only the line items but not the TOTAL column. Total field always displays the summed-up values from the line items.