Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Agregate Best Practice

2 posters

Go down

Agregate Best Practice Empty Agregate Best Practice

Post  dbadwh 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

Back to top Go down

Agregate Best Practice Empty Re: Agregate Best Practice

Post  John Simon 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

Back to top Go down

Back to top

- Similar topics

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