When should i use Cubes
2 posters
Page 1 of 1
When should i use Cubes
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
Re: When should i use Cubes
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
Similar topics
» one or three cubes
» Drill down in cubes
» Criteria for defining OLAP cubes
» Cubes on OLTP
» Filters in SSAS Cubes
» Drill down in cubes
» Criteria for defining OLAP cubes
» Cubes on OLTP
» Filters in SSAS Cubes
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum