Tuple challenge... up for it?

[Tim Palmer]

Hi all,

I am trying to construct a dynamic crosstab based on our university structure.  there is a default measure, our college structure and on the other side a tuple:

tuple(week, Year, Measure)

the week comes from 3 different snapshot dimensions:

- Current week flag- (needs to be linked to current year)
- Current week previous year flag - needs to be linked to current year -1
- Week 104 - maximum year needs to be linked to current year -2

Current week previous year is due to a 104 week, overlapping academic year

Any ideas on how to go about this?

Key challenges:

1. linking the year to the week
2. calculations/ functions across 3 dimensions
3. Remaining dimensionally sound!! (no case statements!!)