When should i use Cubes

View previous topic View next topic Go down

When should i use Cubes

Post  dwcurious on 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

View user profile

Back to top Go down

Re: When should i use Cubes

Post  chumeniuk on 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

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