OLAP, right ORDER for DateTime DIMENSION

[peterlog]

I can't to obtain the right order for DateTime dimension and for multiple level (and field) dimension

I'm working with MS SQL 7 (without SP), and OLAP (without SP too) I've a cube. I've created a dimension DateXMonth, and then I've deleted and then I've created again:
+ Year
+ Month
+ Day

because this show random order for every time that I've created them, or different type of data (numeric or character for the month)

+ 2000
+ July
+ April
+ December
..... NO ORDER

other time

+2000
+1
+16
+2
+20
+3

..... STRING ORDER

other time

+2000
+January
+February
+March

.... STRING ORDER (right!!)

With other multiple level DIMENSION:
+City (char)
+Line (integer)
+Section (char)
+Turn (integer)

..I've the same trouble, I can't to obtain the right order (NUMERICAL o character). . I've tried with the properties for the field Order by Key = true, but nothing. .
I've changed the type of data character (size 10) to small integer (size 4)

WHAT HAPPEN?

 

[Welshbird]

Ordering the data relies on the key filed being in order in the underlying data. To show the time as Characters v. Numerics you will need to use "convert (VARCHAR, " function to tell it what you want it to display. You can then have time dimensions stored in underlying data as
01/01/2001 but visible as:
2000
January
01/Jan/01

Or however you want.

Mail me at work for more details if necessary, and I'll send you some examples...

Fiona.


Fiona Williams

 

[peterlog]

I resolve this trouble, installing OLAP Service Pack 3. It seems to be that the problem was in the OLAP Manager exe or something similar.