Hi all,
Firstly this website is a godsend, thanks to all of you for your contributions :)
I have a report which needs to return a tuple of variable measure [Q_Measure] from a prompt, a year and a week. The week needs to be different depending on the year and each week type is from a different dimension. These are higher education years of 104 weeks.
I want to form a tuple made from year, week and measure
[Q_Measure] - Data Item already solved with a prompt macro.
For the current year (Data Item: lastChild([All Enrolment Years]) I need to return the current week flag [Y]
For the previous year I need to return the previous year current week flag [Y1] (this will be the current week no. plus 52.)
for all previous years I need to return the last week [week 104]
All these weeks are snapshots that sit on different dimensions which meads i can't use an if-then-else on them to bind the year and week together based on a condition. I could use a case statement but this is incompatible with MDX when using crosstabs.
Please help!
Thank you guys, keep up the good work!!