I was wondering while partitioning a cube suppose , giving value range for fiscal period - 001/2004 to 001/2008 and number of partitions to some XX ..
But what will happen after 2008 data, it will reside in only one partition > 2008 ( may be the last partition ) .
Is there any other way to extend the limit for the partition ??
What is a standard practice or best practice for paritioning a cube ?
Awaiting your answers.
Dinesh Kumar replied
Please have a look at OSS note 697275. It mentions the new program to increase the number of partitions.
It as well answers one question: All data is written to the highest partition if the partition it should write into is not available.
Another OSS note where there is a mention of a newer program: 895539