BW Logical Partitioning
I would like to perform partioning of one our cube which is approximately having 100000000 records.
We are having data since 2005 till current date.
I have done partioning of cube from 01.2008 to 12.2009 , after doing this when I checked in background I found that there are 24 partitions has been created.
1ST Partitions : 01.2008 to 12.2009
How can I add new partitions to existing partitions?
When I tried to add new partition 06.2010 to existing one (01.2008 to 12.2009) it has overwritten existing one.
My query is if we create large number of Partitions then does it going to affect data load timing?
If some one knows proper way to do partioning then please suggest, my data volume is 100000000, range 01.2005 till current date