One of the tables does not have a sequence number. Where is it displayed in the order?

• Related Articles

• How to define sequence or order for tables in dbmodel ?

  You can define the order for aggregate tables through ?sequence?. See the below example..

• Do all the aggregate tables specified in data model need to have a sequence number?

  All aggregate tables specified in the 'dbmodel.xml' have to be given a unique sequence number in order to apply the order of execution. And sequence is not just the running number for all tables; it has to be grouped by data mart. Please contact ARC ...

• The newly added measures are not displayed in the sorted order. Why?

  You have to update the measure sequence. For the newly added measures, the sequence might be missing.

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

• The sequence of Q1...Q4 quarter filters appearing in the KPI Grid is not in order

  Ensure that the 'Quarter level' in 'DIM_DATE' in the 'dbmodel.xml' file contains the 'orderBy' condition. If not, please add the 'orderBy' condition to the Quarter level in DIM_DATE in the 'dbmodel.xml' file and re-cache changes for the applied ...