Query Using Aggregate or Detail Data

View previous topic View next topic Go down

Query Using Aggregate or Detail Data

Post  jimbo1580 on Tue Dec 08, 2009 3:23 pm

I have recently been doing some research regarding when it is acceptable to build aggregate tables in addition to the detail fact tables. A couple articles I have read mentioned tools that can issues queries that determine whether there is an aggregate table that can be used to answer the issued query or if it should retrieve data from the detailed fact table. The articles didn't mention specific tools. Is this a capability of some BI tools out there?

jimbo1580

Posts : 23
Join date : 2009-04-30

View user profile

Back to top Go down

Re: Query Using Aggregate or Detail Data

Post  ngalemmo on Tue Apr 06, 2010 3:47 pm

Business Objects provides aggregate awareness and will use an aggregate table if it is appropriate for the query being asked. It's a bit tricky to set up however. Other BI tools provide similar functionality (I believe Cognos and Microstrategy do, but I do not know first-hand).
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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