Sort order in time view is not working if a year break is given. How can I correct this?

• Related Articles

• Why does the Sort order in time view not work when there is a year break?

  We will not be able to achieve this with the current structure of DIM_DATE. In order to resolve this, please follow the below steps: 1. Take a backup of existing DIM_DATE table from warehouse DB 2. Create a new column in DIM_DATE table as ...

• Why is the Sort order on dimension view Day (time) not appropriately being displayed?

  The order_by clause might be missing in the data model for the level - 'Day'. Add the Order By Clause and re-cache to apply the changes. The KPI as well the reports will appear in order.

• Filters are not in order. How can I correct this?

  Delete the default Time filter and add the filters as per the order and republish the KPI. This should correct the filter order.

• Why is the TIME filter not displaying in proper order?

  If there are issues in the displaying order in filters, delete that default Time filter and add the filters as per the order. Republish the KPI. This will resolve the issue and will be reflected to all the users.

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