Hello users of SSAS2005!
I am in the funny position of developing a cube for (at least) three different user groups, and each need "their" special treatment. My problem is in sort order of one particular dimension. The dimension has 3 fields: ID (=person number), Firstname and Lastname - as simple as straightforward as it can be.
Now Finance wants it sorted by ID to relate it to their documents. Human resources needs it by last name, so it can be copy-pasted directly into their structures.
It gets really hilarious when IT needs it sorted by first name (not joking here) because an external application delivers correlating date sorted by first name (again, I am not making that up).
Since I cannot convience anyone onto one common sort I need to make all three possible sort orders available, and I might end up with having 3 identical dimensions or one dimension with 3 identical attributes (except for sorting)
We use Excel as our frontend, I know I can sort a cube there as well. This is, of course, if the field to base the sorting upon is dragged onto the same axis, but that is a bit clumsy too.
What is the "best practices" approach to such a funny situation? (Except for changing the company workflow, let's take that as ... sigh ... static.)
Hello Ralf! I am not sure that this is possible in SSAS/MDX.
One way to solve this is to make the SSAS 2005 reports in Reporting Services 2005.
Check Books On Line for dynamic sorting in reporting services. It is also possible to sort with parameters.
If you can only use Excel pivot tables you can make three different reports, each sorted according to each groups preference.
Publish them i Sharepoint(or any other portal).
HTH
Thomas Ivarsson
HTH
Thomas Ivarsson
No comments:
Post a Comment