Hello:
I am trying to develop a cube in MS OLAP to do Last Month- This Month type of comparison analysis. One way to do this is to have a column in the data base to hold LAst Month fact on every This Month field.

I want to avoid that. Is there any way in MS OLAP that I can define e.g. a measure that will automatically set the value of itself to the last month numbers whenever the current month is shown on the report ( as a row column, slice etc).

Regards,
Sumit