Hi,
I have a monthly report driven by month entity and I want to have a cube to show a Full Year budget for the year from Jan-Dec. Although I can use a Reference To 'Year' function which only set it to a static year, I want it to be dynamic so when navgating through the month into next year the Full Year budget figure changes.
What would be the best approach to achieve this and how?