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.