Comparing Oracle 11g OLAP Option and SSAS

Written by Vincent Rainardi on 27 December 2010. Posted in Design

For my next DWBI project, I’m thinking about implementing Oracle 11g OLAP option instead of SSAS, so I’m comparing them.

1.Browsability: users can use OBI (e.g. Answers), BO (since 9i AW/2003), Excel or other tool to browse Oracle OLAP. Users are not expected to use SQL to query the cube. In AS now we have Crescent to look forward to. In the mean time we could use Tableau (see Jen’s session in SQLBits 8), Strategy Companion, CubePlayer or Excel 2010.

Comparing Oracle 11g OLAP Option and SSAS

Similar Articles