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

• Related Articles

• The newly added module is not displayed for assigning security.

  This problem can occur if the new module created does not contain any KPIs. Please create at least one KPI for the newly created module. Additionally, there is no need to assign this to Super users. By default, security does not apply to Super users. ...

• Why is the newly added Module not working properly?

  If there is no KPI in the newly created module, the module does not reflect in the Analyst.

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

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

• Why is the order improper, while using the Month Range option? For example, I selected Nov 2010-Jan 2011. Week 1 of Jan 2011 got displayed first.

  Modify the 'OrderBy' column in the crosstab area of the KPI as 'DATE_KEY - Ascending' to get the month range in the ascending format. After doing the changes, if you select Nov 2010-Jan 2011, then the Week1 of Jan 2011 appears at the end.