Any tips on how to use analytical functions when relevant data is scattered across multiple databases. Should the data be queued/aggregated to a separate report server at some interval, say every night?