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

• Related Articles

• The crosstab KPI is not working. Why?

  The reason might be 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 same crosstab KPI will work properly. If you require further help, please contact the ...

• Cross-tab KPI is not working as expected. The results are not displaying in a cross-tab. What could be the reason?

  One of the possible reasons could be as stated below: --------------------------------------------------------------------------- All measures selected in the KPI must have been dimensional measures. As a result, cross tab report might not be ...

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

• Crosstab is not sorting properly when week range is selected across multiple years. Why?

  This issue can occur if the column name for the week in 'TIME' dimension is mapped to 'WEEK_NUMBER_THIS_YEAR'. To solve the issue, change the column name of the week in 'TIME' dimension in the dbmodel to 'WEEK_NAME_THIS_YEAR'.

• Unexpected results from "weekly film dataviewer" KPI

  The Issue here is the column_name with which the measure 'C4182' was created is not mapped to any of the levels in the db2_dbmodel.xml file. This is a pre-requisite for any measure to function properly.