Hi,

Here is the merchandise week table structure details from our database

create table dbo.T_AGGR_MERCHANDISING_WEEK_DIM

(MERCHANDISING_WEEK_DIM_ID pk,int,not null,

MERCHANDISING_WEEK char(4),not null,

MERCHANDISING_YEAR char(4), not null

MERCHANDISING_WEEK_START_DATE datetime,not null

MERCHANDISING_WEEK_END_DATE datetime,not null)

PFA doc for the values for above table......

Thanks

Gopi