I made a start at writing some sql for this before quickly realising I'm horribly out of my depth. Does anyone have some sql for this already in place?
I need to list each investment id & name, followed by their forecasted cost for 2015/16 broken down by cost type - as annual figures.
Does anyone have somethink like this already? This table displays our time periods i think: NBI_DIM_FISCAL_TIME