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

Calculate Year difference

Started by kgcognos, 05 Dec 2014 11:31:44 AM

Previous topic - Next topic

kgcognos

I have 2 value prompts.
1-  Fiscal Month/Year Prompt [ie ... January, 2014.. February, 2014...]
2-  Compare Sales to Year Prompt  [ie  2013, 2012, 2011 ...]   

How do I get the year difference between the 2 prompts?
If I select January 2014 and compare it 2012, my [CompYearDiff] should be 2 so that I can use it in parallerPeriod function:

( parallelPeriod ([Sales Cube].[Fiscal Time].[Fiscal Time].[Year],[CompYearDiff],[Selected Month]) ) 

Thank you in advance.

kgcognos

How can I make this statement work? I need to get the # of years in between. 
ancestor([Selected Month],2) - ?CompYear?

The [Selected Month] is like January, 2014....
?CompYear? is 2013...

Thank you

kgcognos

what's the equivalent of "_years_between" function when using dimensional cube?