The crosstab KPI is not working. Why?

• Related Articles

• Crosstab KPI expected to display results week-wise is not working. Why?

  One among the many causes for the Issue is: The measures selected in the KPI are dimensional measures and there are no base measures to display week wise. If you add one base measure, the cross tab KPI should work as expected. If you require further ...

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

  Ensure that the Crosstab Total is applied, for the contribution measures to work properly.

• Week' on Crosstab KPI does not sort on column correctly. Why?

  Perform the following steps to resolve: 1. Add a new column week_number_this_year-year in DIM_DATE. 2. Map the new column to date_fld level s description parameter, in the mssql_dbmodel.xml file. OR Change the Set Order By column to DATE_FLD.

• Why is Swap Axis utility disabled for crosstab KPI even though I belong to Administrator role?

  The Swap Axis utility is enabled only for normal KPIs and remains disabled for crosstab KPIs. This is the reason, you cannot access Swap Axis utility for crosstab KPIs.

• The new filter for manual KPI is not working

  The default value for the filter must have been 'ALL' instead of number. So, change the default value to number in 'ADMIN_FILTER_DEFINITION' table in the admin database.