SSAS- Dimension Attribute needs to be sorted In one of my SSAS- cube one attribute(inset_date) which is Date datatype and format is yyyy-mm-dd, when I checked in excel pivots it is not coming in order.
I have changed the order by property from name to key but it is not sorted,
Key  -- insert_date(date)
Name -- insert_date(wchar)
Value-- insert_date(date)
Can you please what other properties I have to change to sort the attribute of a dimension?
Thank you for your well asked question.
Ordering attribute hierarchy in SSAS can be done in four different ways

By Key
By name
By Other related attribute key.
By other related attribute name.
By in order to activate ordering we need to set the property AttributeHierarchyOrdered=True.