If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Last Period Next Year

Started by cognosjon, 10 Aug 2011 09:12:53 AM

Previous topic - Next topic

cognosjon

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

leahmarie

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!

cognosjon

mmmmmm ???
ok thanks I'll have a look at the function. I'll update with how I get on.