Transformer Help..ASAP

[yenfen]

Hi
I'm trying to add 10 days (2 weeks) to the end of a fiscal year in Transformer (I'm using a lunar calendar - 52 Weeks). Example: the fiscal year 2003 ended in 9/20/03 but I want it to end in 10/4/03 (FY03 Quarter 4). When I generated the cube, it wants to put 10/4/03 as the next fiscal year 2004. What should I do if I want to add 10/4/03 as part of fiscal year 2003? anyone with any kind of information is greatly appreciated.

Thank you so much!

 

[drlex]

yenfen,
how about either
1) creating a special category in the time dimension to include the 'extra' 2 weeks
or
2) creating an extra column in the data source that is a based on the date column (If date within 2 week period, change to last day of fiscal year or the last sunday) and then create an extra time dimension as "fiscal year-modifed" or similar.
obviously both suggestions require manual maintenance if this model is rerun in subsequent years.
lex