|
v_kash
Starting Member
43 Posts |
 Posted - 11/16/2012 : 11:28:03
|
Hello: Am somewhat new to SSAS. My issue is the sort order when I process the cube and bring in the 'calendar month'. It sorts the months alphabetically, not numerically. In my Time Dimension table, the two 'month' columns I have are Calendar Month Number and Calendar Month Name. The other issue is when i bring in the Calendar Month Number, it sorts it by 1, 10, 11, 12,2,3,4,5,6,7,8,9. It should be 1,2,3,4,5,6,7,8,9,10,11,12. What is the BEST way to get the month columns sorted correctly? I've searched a few forums, and there are different 'ways' to address this. Just looking for a detailed explanation on what to do as I am new to this!!
Thanks!! |
|
SSAS SORT ISSUE
