MQT vs Aggregate Tables vs Cubes

Go down

MQT vs Aggregate Tables vs Cubes Empty MQT vs Aggregate Tables vs Cubes

Post  dwcurious on Mon Jun 13, 2011 8:03 am

I want to move some aggregation out of reports. Which would be a better fit? I wanted to understand why i should go for one option as compared with the other.

dwcurious

Posts : 20
Join date : 2011-04-14

Back to top Go down

MQT vs Aggregate Tables vs Cubes Empty Re: MQT vs Aggregate Tables vs Cubes

Post  dwcurious on Fri Jun 17, 2011 1:52 am

Could anyone help

dwcurious

Posts : 20
Join date : 2011-04-14

Back to top Go down

MQT vs Aggregate Tables vs Cubes Empty Re: MQT vs Aggregate Tables vs Cubes

Post  hang on Fri Jun 17, 2011 5:49 am

They serve different purposes. MQT and aggregates are purely for performance and need proper strategy for maintenance in ETL. Cubes give you performance, consistency and rich features, but using MDX and trying to get aggregates out of cubes is not for the faint-of-heart. If you like challenge, go for cubes.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

MQT vs Aggregate Tables vs Cubes Empty Re: MQT vs Aggregate Tables vs Cubes

Post  Jeff Smith on Fri Jun 17, 2011 10:39 am

I would use an MQT or aggregate table to improve performance of a report.

Aggregate tables are good when the table has history that can take a long time to recreate in an MQT and if the aggregations are built by removing dimension keys from the detailed table.

The MQT is better if it can be run in a relatively short time and if you need to roll up data to the middle of a hierarchy.

If the MQT takes to long to refresh from the source and it is rolling up the data to the middle of a hierachy, consider doing both. Create an aggregate table that is created by removing dimension keys and summing up the data and an MQT that uses the aggregate table and further aggregates the data to the middle of a hierachy.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

MQT vs Aggregate Tables vs Cubes Empty Re: MQT vs Aggregate Tables vs Cubes

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum