I see, and what is the plan for the transition year? Will there be a 15 period year before the cutover to Apr-Mar?
No, It's a 12 period year only.
Not sure I understand how that will work.
Anyway, I would personally create a new time profile (period 1 = April, period 12 = March), attach that to a new cube, pull the openings for that cube from the old cube when appropriate and use the new cube going forward. Then you have two cubes, one with the historical data, and one with the new data going forward. You could still use the same dimensions, including entity and scenario.
That is along the lines of how I have handled local entities having a different fiscal-year than that of corporate. You basically need a cube for each fiscal year, with each cube using an appropriate fiscal year specific time profile. You need to build logic to copy the data between the fiscal year cubes. The logic needs to know how to time shift between the source and destination cube, including converting values, and dealing with year-end rolls. I also use the time shift functions so that I can use a common set of FXRates for all the cubes.
