This one is tricky!! I have a need to create a report with a dimension comprised of numeric # of weeks from a milestone date like a release date. The time dimension is yyyyww, but there is unique numeric number of how many weeks away from the milestone this is for a particular project. This should be able to handle the number of weeks before and after the milestone date.
I have added a screen shot of what my other tools does.
a_week_num - represents the number of weeks from a date we call Alpha
po_week_num - represents the number of weeks from a date we call PO
PRQ_week_num - represents the number of weeks from a date we call PRQ
then you have the WWstartdate - I dont need that
then the program or project
then the yyyyww.
I have also added the report I want to create. this report aligns programs with different start dates, by aligning them on the yyyyww based on the a_week_num dates.