From my experience, I believe a different database/table is required for reporting :- When Volume of campaigns processed is huge, and the campaign run window overlaps the report run window. If reporting needs to consolidate results not only from CDM, but from other sources as well. If the campaign tracking reports need frequent run and the runs take long time. Thanks, Ubaid   ... View more

Hi there,   I believe the CDM schema is organised enough to start off with your reporting for campaigns. Unless you want to build cubes to incorporate data like response-feedback from channels and the take-up. I will suggest using SAS Visual Analytcs, its in memory processing and data exploration will help you with that quick analysis and on the fly reports. Plus you don't have to worry about the cubes.   Thanks, Ubaid ... View more