Report Portal

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.

Read more...

Tags: design, dimension

 

2007-2015 VidasSoft Systems Inc.