WEEKS in TIME dimension

[silban76]

Hi All,

This is my problem:

The weeks in the time dimension is from a column in the IQD.
The weeks are directly mapped to the month and the year in the table itself
example:
2002 Nov 10/28/2001
2002 Nov 11/04/2001
2002 Nov 11/11/2001
2002 Nov 11/18/2001
2002 Nov 12/02/2001

My dilema is when I generate the categories, I want the week 10/28/2001 to show up under the month october and not november.
I understand that the weeks are premapped in the database table, Is there a way around this??

Thank You
silban

 

[Draoued]

In your transformer model click Show diagram.
Go to your time dimension and right click the Week path. Navigate to the Time tab.
Here you can specify on which day the week starts.
And how you want it to be splitted over month, or not splitted meaning kept where the largest period is.