Report Portal

Date Order

I had a request recently to change the order of the date dimension in my SSAS cubes to descending, so that users could easily find the most recent dates. Users are using COGNOS Analysis Studio to slice and dice the data. The users of course could have simply dragged the date hierarchy onto the "canvas", right-clicked and selected "Sort Descending" but this was considered too much of an inconvenience.

Read more...

Tags: design, mdx

 

2007-2015 VidasSoft Systems Inc.