12 months rolling

[deepak2k2]

Hi,
I've 80% done with my report.  But i got stuck up with my prompt selection.

My requirement is if i select the prompt(mmm/yyyy), so that i could get (selected month -12) in my cross tab.  Ex:  if i select Oct2009 in my value prompt, cross should show Oct 2008 to Oct 2009. 

I know how to do it Relational Model, but i'm buidling the reports using Dimensional Model.

Please give me suggetion, how to implement it?

[deepak2k2]

Anyone is there to answer my query?

Its really appreciated.

[rockytopmark]

From the dreaded On-Line help:

lastPeriods ( integer_exp , member )
Returns the set of members from the same level that ends with the specified member. The number of members returned is the absolute value of "integer_exp".  If "integer_exp" is negative, members following and including the specified member are returned. Typically used with a time dimension.

[deepak2k2]

Thanks for the reply.

When i use it, it shows an error "Invalid coercion from 'hierarchy' to 'member'".

Please give suggestions.

[deepak2k2]

any more suggestions...

[MFGF]

Thanks for the reply.

When i use it, it shows an error "Invalid coercion from 'hierarchy' to 'member'".

Please give suggestions.

I'd suggest you are seeing this error because you have used a Hierarchy in your expression rather than a member from a level.

Can you share with us the exact expression you used?

Regards,

MF.