Hi All,
Our customer would like to have a single weekly level infocube which will be partitioned on characteristic "0CALMONTH". This infocube will contain data of all 12 months in such a manner that at database level there will be a partition created for each respective month.
We are using IBM DB2 as our databse and AIX (UNIX) as our OS.
I tried searching on SDN and it seems that physical partitioning is not possible with above system configuration and logical partitioning will require 12 different infocubes (one per month).
Can we consider Clustering based on 0CALMONTH and if yes is it going to give us the same result as that of physical partitioning or is there any other way we can achieve it?
Thanks for your kind suggestions.
Regards,
Nilima Rodrigues