passing 2 members from prompt - (2 lmembers to be put with a measure in a tuple)

[Tim Palmer]

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