How to define sequence or order for tables in dbmodel ?

• Related Articles

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

  All aggregate tables specified in the dbmodel.xml should be given unique sequence numbers, inorder to apply the order of execution. The sequence has to be grouped by data mart too.

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

• How can I fix the sequence of Q1...Q4 quarter filters appearing in the KPI Grid, which 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 ...

• How does ARC Temporary Tables get created?

  When we execute multi parse KPIs, the temp tables automatically get created and dropped in real-time. Sometimes executing such multi parse KPIs may take longer time and business users might terminate in between because of the time taken. At such ...