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

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

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

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

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

    • How to retain the measure sort order in the KPI grid?

      To retain the measure sort order in the KPI grid, set the following property in arc.properties file: arc.grid.measure.sort=no. Please note that by setting the above property, the measure sort order is retained in the KPI grid, however the export to ...

    • How can I retain the measure sort order in the KPI grid?

      Alter the following property in arc.properties file to retain the measure order sort in the KPI grid. However, on setting this property, the export to excel sort order will not be retained. But, it is available in ARC 6.2 with advanced export options ...