Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Ask a question or Report a Bug
 WhereScape Forum : Make a Posting : Ask a question or Report a Bug
Topic: week hiererchy in date dimension Post Reply Post New Topic
Author Message
echangeh
RED Users
RED Users

eHealthinsurance Inc

Joined: 21 April 2007
Online Status: Offline
Posts: 70
Quote echangeh Replybullet Topic: week hiererchy in date dimension
    Posted: 25 June 2009 at 12:21pm

Our users requested a week hiererchy in date dimension. What's the best way to do this in RED? There is a cal_week_in_year in date dimension. But, it is just week number with no year attached to it. It would cause trouble MS analysis cube. For the week number 5 in 2009, it preferrs 200905 instead of 5 in hierarchy. Please advise. Thanks!
IP IP Logged
Chris.Lerew
WhereScape Consulting
WhereScape Consulting
Avatar
Wherescape Ltd

Joined: 04 April 2007
Online Status: Offline
Posts: 217
Quote Chris.Lerew Replybullet Posted: 25 June 2009 at 9:33pm
It should be very esy to amend update_dim_date to provide yyyyweek.
Most users customise dim_date and the update procedure to their own requirements.
IP IP Logged
echangeh
RED Users
RED Users

eHealthinsurance Inc

Joined: 21 April 2007
Online Status: Offline
Posts: 70
Quote echangeh Replybullet Posted: 26 June 2009 at 5:33am

Thanks,
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.