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

• Related Articles

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

  It is not possible to achieve the result with the current stricter of DIM_DATE. Perform the following steps to resolve the issue: 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.

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

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