Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rml
Starting Member
7 Posts |
 Posted - 2002-02-21 : 07:26:16
|
| I have constructed a time dimension(Year/Quarter/Month) for the cube.However, when I expand the time dimension, the display format for month is 1,10,11,12,2,3,4,.....,9what can I do to order the time dimension like 1,2,3,4.....10,11,12 |
|
|
dsdeming
479 Posts |
Posted - 2002-02-21 : 07:51:42
|
| If your time dimension is defined as a string, months or days need to be front padded with zeros to a total length of 2.Hope that helps. |
 |
|
|
rml
Starting Member
7 Posts |
Posted - 2002-02-22 : 22:45:30
|
| The virtual dimension order the weekday in alphabetical order.Then How can I order Mon, Tue, Wed, Thurs, Fri, Sat, Sun in virtual dimension? |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-02-25 : 06:05:17
|
| don't use the "label" column for sorting. Use a different column for the sorting.When you use the dimension wiazrd, it offers you the choice to modify the sorting and uniqueness properties.hope that helps. |
|
|
|
|
|
|
|
|
Time dimension