I'm hoping that someone could help point me in the right direction with this.
I'm using 8.4 fp2 and I'm working with DMR.
I have a Crosstab report requirement to create a Forecast finance report that displays a forecast value for the last AP of the current year(User Selected) and the last AP of Next Year.
So if the user chooses 2011 they see 2011 Ap12 and 2012 Ap12 side by side.
For the last AP of the current year I have no issues and have done this by creating a new measure and have then changed its Aggregate Rule to be based upon my Time dimension and set the aggregate rule to last. I've tested this and it works fine.
The issue I now have is how to grab the same period for the following year? I'm a bit stumped. :o
Any guidance appreciated.
Thanks
This is a dimensional function, so maybe it will work. I don't have any experience with DMR though, so this might be a shot in the dark. There is a dimensional function called parallelPeriod that will do exactly what you need. You'll just have to use the syntax correctly;
parallelPeriod(level, int_exp, member(or in your case ?parameter?))
So for yours, parallelPeriod([Hierarchy].[level].[Year], 1, ?dateparameter?)
Good luck!
mmmmmm ???
ok thanks I'll have a look at the function. I'll update with how I get on.