I have tables of raw data, each of which need to be "data warehoused" into usable data for reports, lookups, etc.

What are the best strategies to do this with in MM?

I have a dozen or so aggregate/warehouse tables I need to create, which have much simple processing - i.e. just using a view to pull some aggregate data, and saving it to an aggregate/warehouse table. And each one is built off the previous one. Would I create an event object which sequentially opened each business object?

That seems like overkill. I really just need to open a view, save it to table1. Open the next view based on table1 and some other table, and save it to table2. Open the next view based on table2 and some other table, and save it to table3. What's the MM way to do this? Create a business object for each view? Seems like a lot of overhead.

Anyone's advice/experience would be appreciated.

Thanks,

David