Hi,
I have Year Hierarchy in Time Dimension, I want to show data for selected Year
For example, If I Run the Report in August & I selected the Year 2013 then I want to get data from Jan 2013 to Aug 2013
If I select the Year 2012 then I want to get data from Jan 2012 to Aug 2012
If I run the Report in next month i.e., September & I selected the year 2011 then I want to get data from Jan 2011 to Aug 2011
For Year selection I created below DataItem, it's working fine for me
.
Tuple ([Sales].[Time].[Year]->[All].?Year?,[Revenue])
I created Other DataItem SelectedMonth as
[Sales Analysis].[Time].[Month]->?Month?
Using above I created below DataItem as
periodsToDate([Sales Analysis].[Time].[Year].[Year],[Selected Month])
Here am getting the error
Can anyone suggest how to do same for YTD
Thanks,
SSR
Hi,
The periodsToDate() function expects the level and the member to be in the same hierarchy. In your case it looks like you have separate dimensions for year and month? Does your Month dimension have an All Months level? You should probably use this if so.
Cheers!
MF.