Agregate Best Practice

View previous topic View next topic Go down

Agregate Best Practice

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

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


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

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