CUBE : Day Of Week start on Sunday, I want it to start on Monday

Hello guys, Here is a problem I meet when trying to create a calendar using BIRT. I m neaaaaaaaaaaaarly getting it

, but I have a final problem : I use the automatic Date Time type in my cube and it put the Sunday in first and finish by Saturday. You can see on the screenshot that if sunday comes at the last place, the calendard would be perfect, but for now it's not ^_^ Do you have an idea if it's possible ? If yes how ? I don't fear scripting

Thanks in advance

Find more posts tagged with

Comments

mwilliams

One way would be to create custom groupings for year, month, day of week and use those fields as your group values.

egau

Hello,Thanks for replying. Yes it seems to be the only solution :-(. As you proposed, instead of using a date time field as a group, I created 3 column in the dataset to get year, month, day of week and I use the "Map" function to replace 1,2,3... by Monday etc.. but it means I have to manually managed the translation. I also used weekDay(xx,2) in my "weekDay" column to get "Monday" as the first date instead of Sunday ( default ) Thanks for replying. I hope this workaround will help other people ! C ya

mwilliams

You're welcome.

I guess the other solution would be to subtract a day from your date field in your dataset and then use a mapping rule to replace the day of week values with the appropriate ones.