Why is the Sort order on dimension view Day (time) not appropriately being displayed?

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.