transformer auto-partitioning

[Robert Edis]

G'day Mark

You may find a more responsive audience at www.cognoise.com.  That forum
specialises in Cognos BI products whereas this one is for Cognos ADT
products.

Regards,

Blue

Marc Werner wrote:

Hi,

I got a transformer model holding 5 time dimensions,
1 big customer dimension ( 120.000 categories , 4 levels )
and another 10 small and flat dimensions with about 5-50 categories
some of them only have 1 level ( no hierarchies )

Building cubes ( we got about 50 Mio fact-records ) using that model
having auto-partition switched on I get strange sizes of the cubes
bla.mdc
bla1.mdp  700 Mbyte
bla2.mdp  200 Mbyte
bla3.mdp  200 Mybte
...

due to transformer not being able to spread the flat dimensions across
different partitions I guess.

Has anybody expierence with models of that shape ?
Is it worth to exclude the flat & small dimensions from auto-partitioning ?
Is it worth to do manual partitioning inside the customer-dimension ?

Thanks for any help
Regards,
Marc