Store order is different each time the Store Authorization KPI is run. How can I keep the Store order constant?

• Related Articles

• The store order is different each time Store Authorization KPI is executed. What could be the reason?

  This is true in case of SQL KPIs If a manual KPI is created/generated using SQL then, the store does not come in order. There are certain other limitations in SQL KPI apart from this. As a workaround, we suggest you to publish this as an auto KPI.

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

• 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 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 does the ARC's session time out when two different URLs are accessed simultaneously?

  When two different ARC Instances residing in the same server are accessed, some specific server settings might conflict resulting in the application session timing out. Hence, it is recommended that one of the Instance is accessed using the IP ...