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!!)