COGNOiSe.com - The IBM Cognos Community

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