dbTalk Databases Forums  

Time Sequence Dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Time Sequence Dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Darryl Jewett
 
Posts: n/a

Default Time Sequence Dimension - 11-14-2003 , 09:32 AM






I have a dimension 'Time' of year/month/day. I want the
representation to be reverse from the default, example:

2001 2002 2003 I want to be 2003 2002 2001

Week1 Week2 Week3 I want to be Week3 Week2 Week1

Any ideas on how I can accomplish this? Can you specify
asc or desc order in the dimension editor? Do I need or
order in the underlying fact and dimension tables?

Any help would be great!

Darryl



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.