YTD in cube based report

[ar0421]

I have a cube based repport that currently working on a prompt where user selects timeframe.
In the report studio my filter is:
[Standard Data Cube].[Time].[Time].[Month] in (?TimePrompt?)


User now wants to schedule the report where timeframe is YTD.
I tried to replace ?TimePrompt? with [YTD], but it does not work.

[Standard Data Cube].[Time].[Time].[Month] in [YTD])


Any ideas?

Thanks.

[cognostechie]

It's not a good idea to use SQL operators when making reports from a cube. Make a copy of the report and try this in the copy -

1> Go to the Query, expand the Time dimension until you see the years. Just one level above the individual years, you will see a Blue color level called 'Time'. Drag and drop this in the Query to create a Data Item. Name it 'All Years'. Create another Data Item and use this expression - lastchild([All Years]). Name it 'CurrentYear'.

2> Create a slicer with this expression -

[Standard Data Cube].[Time].[Time].[Year] = #prompt('TimePrompt','mun','[CurrentYear]')#

That should do it. When scheduling the report, don't select anything from the Prompt so the report would default to the Current Year.

I am presuming the last year in the Time dimension would be the current year and the data would not go beyond the current date. If not, use the YTD from the cube.