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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Agregate Best Practice

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Agregate Best Practice Empty Agregate Best Practice

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

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

http://jsimonbi.wordpress.com

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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