Datamarts to create aggregate/summary tables at higher levels of a hierarchies. Addition of Indexes to tables for faster execution of queries. Factors to DECIDE on aggregate tables If a large SET of reports need to be viewed at a level(a level that is higher than that of the existing Fact tables USED by those reports) then it is worth creating aggregate tables at that level. Or if a report is huge and it is critical for the business DECISIONS then it is worth creating the aggregate tables for that report

Datamarts to create aggregate/summary tables at higher levels of a hierarchies. Addition of Indexes to tables for faster execution of queries. Factors to decide on aggregate tables If a large set of reports need to be viewed at a level(a level that is higher than that of the existing Fact tables used by those reports) then it is worth creating aggregate tables at that level. Or if a report is huge and it is critical for the business decisions then it is worth creating the aggregate tables for that report