We are using Transformer 7.1.320.0-0 on WIN 2003 server against a SQL server 2000 DB. In our model we have an 'ALL FISCAL YEARS' dimension based on a date field with the following information:
(FIRST day of week is MONDAY)
>YEAR -- Lunar Year; Ranking=10
>QUARTER -- Lunar Quarter; Ranking=20
>MONTH -- 5-4-4 Week Months; Ranking=30
>WEEK -- Week; Ranking=40
>DAY -- Day; Ranking=50
If I go into a NEW model, and create a NEW time dimension, somewhere in the Date Wizard(Step 13), it has a setting for 'Add an extra week(53)' and a choice of how many extra days triggers this extra week.
HOW can I see what this setting is set to for the CURRENT production model's Time dimension?
The choices on the Extra Week screen (Date Wizard Step 13) are as follows:
> None - do not add extra weeks
> When there are 4 extra days
> When there are 5 extra days
> When there are 6 extra days
> When there are 7 extra days
We need a choice of "> When there are 3 extra days". This year, December 29, 30, and 31 need to be Week 53 for us, even though it does not fit the 5-4-4 pattern.
Also, going forward, this of course means that JANUARY 2004 (Week 1) starts on Jan 1st, which is a THURSDAY. The rest of the year will follow the 5-4-4 pattern.
On our Feeder report, there are fields from the ALL_TIME SQL Server table associated to the Date field. These fields, Fiscal Year, Fiscal Week, Fiscal Period, etc. are coming in from the .IQD correctly -- Fiscal Year = 2003, Fiscal Week=53, Fiscal Period =12.
When the Transformer Model runs, it makes Monday Dec 29 the FIRST day of Fiscal 2004. It does not use the associated fields from the feeder report to generate the date categories.
How can I change my model to reflect these date requirements ?
Any suggestions would be apprecicated !!
![[dazed]](/data/assets/smilies/dazed.gif "[dazed] [dazed]")
(FIRST day of week is MONDAY)
>YEAR -- Lunar Year; Ranking=10
>QUARTER -- Lunar Quarter; Ranking=20
>MONTH -- 5-4-4 Week Months; Ranking=30
>WEEK -- Week; Ranking=40
>DAY -- Day; Ranking=50
If I go into a NEW model, and create a NEW time dimension, somewhere in the Date Wizard(Step 13), it has a setting for 'Add an extra week(53)' and a choice of how many extra days triggers this extra week.
HOW can I see what this setting is set to for the CURRENT production model's Time dimension?
The choices on the Extra Week screen (Date Wizard Step 13) are as follows:
> None - do not add extra weeks
> When there are 4 extra days
> When there are 5 extra days
> When there are 6 extra days
> When there are 7 extra days
We need a choice of "> When there are 3 extra days". This year, December 29, 30, and 31 need to be Week 53 for us, even though it does not fit the 5-4-4 pattern.
Also, going forward, this of course means that JANUARY 2004 (Week 1) starts on Jan 1st, which is a THURSDAY. The rest of the year will follow the 5-4-4 pattern.
On our Feeder report, there are fields from the ALL_TIME SQL Server table associated to the Date field. These fields, Fiscal Year, Fiscal Week, Fiscal Period, etc. are coming in from the .IQD correctly -- Fiscal Year = 2003, Fiscal Week=53, Fiscal Period =12.
When the Transformer Model runs, it makes Monday Dec 29 the FIRST day of Fiscal 2004. It does not use the associated fields from the feeder report to generate the date categories.
How can I change my model to reflect these date requirements ?
Any suggestions would be apprecicated !!