In what scnearios would you modify the Auto Partition properties in cube
Estimated number of consolidated rows
Desired partition size
Number of passes
Anyone
You need to read this: http://public.dhe.ibm.com/software/dw/dm/cognos/modeling/powerplay_transformer/transformer_in_production.pdf
Start with page 13, where you will get as much details about auto-partitions as you need, I hope.