Rolling 12 Months using Cubes Current Month as the last period in the 12.

[andy_mason_84]

Hi,

I am trying to get a rolling 12 months, working back from the Current Month dimension in my cube.

This is the code i am using, it throws no errors but also brings back no data.

tail(periodsToDate (

[Cube].[All Reporting Dates].[All Reporting Dates].[All Reporting Dates]

, item(filter(

[Cube].[All Reporting Dates].[All Reporting Dates].[Month]

, caption(

[Cube].[All Reporting Dates].[All Reporting Dates].[Month]

) =caption([Cube].[All Reporting Dates].[Current Month].[Month]) ),0)),12)


Anyone see anything obvious i am doing wrong here?

Cheers,

AM