Hi,

I want to partition a cube on the basis of fiscal month.
The requirement is that the partition will have to be dynamic.
The cube is to be partitioned into 2 , one partition containing the data for the previous fiscal months and other partition containing the data for the current fiscal month.
Now if I use partition wizard to partition the cube then at the end of each fiscal month I have to merge the two partition and then I have to repartition the cube into two.
Is there any method to partition the cube such that partition changes dynamically whenever fiscal month change?

Thanks in advance for any help
Regards
Amit Pal Singh