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

When should i use Cubes

2 posters

Go down

When should i use Cubes Empty When should i use Cubes

Post  dwcurious Sat Sep 08, 2012 10:47 am

Could some one explain to be when we should go for cubes. I am confronted by this question everytime i see a non detail report and I am not sure if i shoudl use a cube

dwcurious

Posts : 20
Join date : 2011-04-14

Back to top Go down

When should i use Cubes Empty Re: When should i use Cubes

Post  chumeniuk Wed Sep 12, 2012 8:55 pm

You should consider building cubes once you have your model defined and populated. They can be leveraged for reporting and ad-hoc analysis immediately. If you are using SQL Server, they are very easy to build if you follow a star schema with conformed dimensions. The real challenge is building the hierarchies in your dimensions and setting the correct partitions and aggregation level so they perform.

chumeniuk

Posts : 3
Join date : 2010-05-17

Back to top Go down

Back to top

- Similar topics

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