Recreating the totals at a point in time to facilitate burndown charts (like, how many bugs were active on each day last month) is very easy using the cube, and very difficult using the relational warehouse. Also, if you want to slice and dice in an ad-hoc manner using excel or other client applications, the cube is a good option.
For simple lists of the current version of work items, using the relational database can be a good option.
|