Agregate Best Practice

View previous topic View next topic Go down

Agregate Best Practice

Post  dbadwh on Sat Oct 08, 2011 1:30 pm

Hi,
We have a requirement to load the data every 2 hours for day trend analysis for sales. Is it it best to have the pre-calculated data and kpi's in tables are to move it to cubes? What is the best practice?


Last edited by dbadwh on Wed Oct 12, 2011 12:19 pm; edited 1 time in total

dbadwh

Posts : 31
Join date : 2011-09-30

View user profile

Back to top Go down

Re: Agregate Best Practice

Post  John Simon on Sun Oct 09, 2011 5:07 pm

Put it in a cube and have your cube partitioned by day. That way you can reprocess quickly.

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.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