I need to do the lofical partioning of the cube, by Financial year . I have 3-4 year data in the cube and looking to create a separate cubes for every 2 years .
On top of that i am looking for one cube to have current fiscal year data only, as most of the reporting is done this
My concern is if i create separate cubes for separate years, so i do i need to create a new cube every year.
Kindly Guide me how to do this activity and approch to be used.