Sorting Descending in Analysis Services for a Date Dimension

Overview: This entry describes how I fulfilled a customer requirement to present the Date attributes & hierarchies in descending order, rather than ascending. This technique utilizes individual sort fields for each attribute. Each sort field contains the same content as the key, but is multiplied by * -1 to reverse the order.