Skip to Content
Former Member
Oct 06, 2012 at 02:07 AM

1 big cube or 10 small cubes


Dear Experts,

Towards set up of BW framework for a DP implementation, I have
this trade off decision between choosing 1 large infocube (to pack data from
multiple sources) or n small cubes that stores data from individual sources

Which approach is better? considering

- Performance? does it matter with size of infocube ?

- Ease of use ? e.g. process chains, corrections, locking if any

- Back up of data. ... to one cube or several cubes.

- CVC creation? wrt this cube

-Copying/data administration



If I go ahead with single cube the data volume I am talking of
(4 years +) could be of the order of 50 million records!!

Request to share some best practices of RSA1