Find previous week from a prompted week number

[ian.hawksey]

Hi guys.
Using Report Studio 8.3 against a Cognos cube.

I have set up a prompt, where the user selects a week number from a dimension, and I now want a column in the report to show a value for the week previous to the one selected
eg user selects week 50
I want the report to show the cost for week 49

I've tried various functions without success.

Any suggestions?

Thanks in advance

[CognosPaul]

All you should need to do is something like:
prevMember(#prompt('weekNumber','memberuniquename')#) where weekNumber is your parameter name.

If this doesn't work make sure that the value prompt is returning a mun instead of a category code. If you're using detail filters then there is a very good chance this won't work.

[ian.hawksey]

PaulM.
Unfortunately I didn't get to try this out as the user requirement changed !

Thanks anyway

[CognosPaul]

I'd suggest trying it anyway. Dimensional reporting has a fairly steep learning curve, but once you understand it you can do a lot. Understanding dimensional functions now will save a lot of headaches later.