Category Archives: Toolbox

Oracle Essbase 9.3 Developer Certified Expert

It’s official, I am now an Oracle Essbase 9.3 Developer Certified Expert:-) After several years working with Microsoft Analysis Services, I decided to invest some time in learning more about Essbase. I have to say it has been a fascinating experience, both with regards to the platform’s endless possibilities and the quality of Oracle’s training program. I definitely should now update my post on Cubes & Universes;-)

The (Steep) SQL Server 2005 Learning Curve

Stephen Swoyer has published a brief analysis at TDWI on why the SQL Server installed base seems to be growing relatively slowly. Bottom line: the learning curve is steep and corporations cannot easily replace prior SQL Server versions running mission-critical applications.
You’ve got to love his quote of Adam Machanic (SQL Server MVP) saying that “comparing DTS to SSIS… would be like comparing a pea shooter to a neutron bomb[…]”. I’ve been rather more involved with Analysis Services than Integration Services, but this is exactly the way I’ve felt about the OLAP side of things…
As far as desktop data management goes, the big news with Microsoft’s latest release has got to be the free SQL Server Express Edition. From a data storage & processing standpoint, this is a interesting alternative to Microsoft Access. You may still need the latter (or another Office component such as Excel) as a graphical interface into your data, but if you’re expecting your requirements to grow, this will be much easier to scale to an enterprise version when required.

Updated: Learning curve or not, this version of Microsoft’s database offering is worth the effort, according to some.

Cubes and Universes

Mark Miller recently posted a link to a whitepaper comparing the BI offerings from Business Objects and Microsoft. This is something I had been looking for for quite a while and I think it does a good job of presenting a comparative history of both platforms. The content remain fairly high level, though. What I’d like to do here is to discuss some of the conceptual differences between a Business Objects (BO) universe and a Microsoft SQL Server Analysis Services (SSAS) cube.

As you read through this brief comparison, please keep in mind the following:

Continue reading