I want to create a several Cubes with 10 characteristics only and link them with a Multiprovider. These cubes are 'Real Time' (BI 7.0) so that I can do BPS planning on them.
1) I am wondering wether it would be interesting (from a performance point of view) to use a single Dimension per characteristic rather that grouoing some of the characteristics in fewer dimensions.
2) If I go for 1 char per dimension, will I gain in performance during accesses if I flag all dimensions as Line Items?
3) Does the choice of using Line Items have an impact on the Multiprovider
4) Does the choice of using Line Items have an impact on the BPS planning functionnalities?
Thanks, Points awarded for responses,