Time dimension structure has the following attributes
Date - YYYY-MM-DD is the Key.
Date_fmt - date represented as an integer YYYYMMDD
Week - YYYY W[1-52] (e.g. 2010 W10) in char
Month - YYYY Mon (2010 Apr) in char
Quarter - YYYY Q[1-4]
Year - YYYY
Based on the solutions in this forum, I created a new attribute date_fmt which is of type integer and assigned as an AttributeKey.
Date is sorted, except Week and Month.
Date OrderBy : AttributeKey, OrderByAttribute : Date_fmt
OrderBy for Date_fmt, Week, Month, Quarter, Year is Key. Date_fmt has OrderBy set to Key, as there is no other option. Date_fmt AttributeHierarchyVisible : False
I am not able to assign OrderBy : AttributeKey, OrderByAttribute : Date_fmt to the Month and Week attributes.
I tried adding 2 new attributes month_fmt [1-12] and week_fmt [1-52] which are integers. Idea was to specify these 2 new attributes to the Month/Week OrderByAttribute : month_fmt/week_fmt. But not able to set these options.
Question: Since OrderBy is set to Key, why the sort is not taking effect on month and week? How can I sort month and week?
View Complete Post