Wherever possible, aggregations should be done in the source system. This is likely to reduce the size of the import file meaning faster imports Questions on this topic? See 5.04-05 Pre aggregate in the source in our Planual forum.