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

• Related Articles

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

  It is because Variance (cost of living-MOM) and Variance (holiday Premium-MOM) are crosstab % contribution measures and it is the calculation of the corresponding month s cost of living divided by total cost of living . As these values for the ...

• How to display measures in terms of thousands or millions?

  There is a KPI utility called 'Unit Measure'. A required unit can be set for a given measure using this utility. Note: This feature is session based and is applicable only for currency type measures.

• 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.

• In Yearly Period filter, how can I display the value for 2009?

  To view the previous years we need to modify 'ARC194' query in the admin warehouse xml file. ARC194 = 2006 - 1 AND YEAR = ? - 1 AND YEAR <= ? AND year 9999 order by year desc --> SELECT DISTINCT YEAR, YEAR_NAME FROM DIM_DATE WHERE YEAR >= (select ...