Hello,
I have a dimension called DimStudent and when I drop an attribute called Class in a Row Fields area for cube browsing, I get values that are not logically sorted. Is there a way to sort class attribute in a browser in logical order without using additional Academic Level (values GR, UG ect.) attribute such as
| Freshman |
| Junior |
| Senior |
| Sophomore |
| Undergrad Post-Bacc |
| Unknown |
| Doctorate |
| Graduate Post-Bacc |
| Masters |
| Post-Masters |
|
Here are my unsorted default values: Class |
| Doctorate |
| Freshman |
| Grad Non-Matric |
| Graduate Post-Bacc |
| Junior |
| Masters |
| Post-Masters |
| Senior |
| Sophomore |
| Undergrad Non-Matric |
| Undergrad Post-Bacc |
| Unknown |
| Grand Total |
Thanks!
Sorting Values of a Atribute While Browsing a Cube
BRAMOIN
< xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" />When you are in the dimension editor you can click on an attribute hierarchy and then go to the properties window. In the properties window for the attribute hierarchy you will see a property called "OrderBy" and another called "OrderByAttribute". These two properties work together to specify how to order the members in the attribute hierarchy. Here is a brief description of the different "OrderBy" property settings and how they work: