1. It was concluded that if you have huge amount of data having several cubes may serve as a kind of physical partitioning - improved performance.
2. The other option was Or you can insert into the same cube a new characteristic, kind of KF type and set different values for actual, plan, forecasted data.
..but this approach has a disadvantage needs a multiprovider, more DB space because of redundant storage of characteristics in the similar cubes.
Well, my concern now is on 2 above, if you combine the Cubes into a multiprovider, arent you defeating the advantage of the separation (like partition) which would lead to an improved performance?
Thanks