×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

OLAP, right ORDER for DateTime DIMENSION

OLAP, right ORDER for DateTime DIMENSION

OLAP, right ORDER for DateTime DIMENSION

(OP)
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?

RE: OLAP, right ORDER for DateTime DIMENSION

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
 
 
 

RE: OLAP, right ORDER for DateTime DIMENSION

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close