Help! How to compute last 12 periods with dimensional model.

[dinos]

Hi,

I am trying to create a simple line chart that depicts the last 12 periods of revenue.  A period can be a quarter, a month, a week, or a day.

Time Dimension levels are:
Year, Period, Date

The use is prompted to select a year and period.  Based on these selections, what is the logic that I can use to retrieve only the last 12 periods?   Also, last 12 periods can transcend years, so the logic would need to account for possible roll over into multiple years.  Help!

[dinos]

Issue resolved.  The function to use is LastPeriods() and to make sure that member sorting is applied in Framework Manager (available in 8.4) to the necessary dimensions, namely the Time dimension in this case.