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

'Rest of Year' special time category...

Started by jonathan.webb@raytheon.co, 17 Jun 2011 03:05:21 AM

Previous topic - Next topic

jonathan.webb@raytheon.co

Morning all,

I've got stuck trying to create a special time category in a date dimension called 'Rest of Year'. My cube contains both actuals and forecast data, with current month established as the latest month of actuals... so your current month might be June, your YTD is Jan-June.. I need a special time category for Rest of Year which would be Jul-Dec.

I can create a calculated member within the date dimension which is Current Year minus Year to Date.. but I really want a proper special time category which will allow the users to drill down to the quarters/months within the rest of year.

Any suggestions greatly received  :)
Cheers