Alternatively Sorting Attribute Members in Analysis Services 2005
While it is quite common to sort the attribute members of our Analysis Services 2005 cubes based upon either their name or key values (perhaps even a composite member key), many of us encounter situations where we need to accomplish a different sort order – a sort order that is based upon a characteristic lying outside the attribute members themselves. In these cases, an option we have is to order such an attribute on the basis of the name or key of a related secondary attribute.
Tags: design