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