Calculated cells can do more—and do it better—than calculated members
Recently, a DBA asked me why he should use a multidimensional database system such as SQL Server 2000 Analysis Services instead of just making his own set of Relational OLAP (ROLAP) tables to store the hierarchical structure of all a cube's dimensions and associated aggregations. I'm not sure whether he thought that Analysis Services is an immature product or whether he was just trying to un...