The power of Excel-friendly OLAP

Dick Kusleika pointed a few days ago to a paper by Charley Kyd. In it, Charley gives a convincing overview of the possibilities revealed by OLAP-powered Excel solutions. Speaking from experience, I can only attest to the amazing things this combination allows you to achieve.

I’m surprised by Charley’s statement that TM1 and PowerOLAP “return data to Excel about 100 times faster than Analysis Services does”, but then I haven’t tested either to compare it to SSAS coupled with XLCubed. This combination is so fast already that I’m not sure how a user would pick up a 100-times increase in query speed. The article is nonetheless very much worth reading, particularly if the combination of OLAP and Excel sounds new to you.

If you think you’re familiar with cubes because you’ve used Business Objects before, you may want to check out my post comparing Business Objects Universes (and cubes) to the cubes provided by Microsoft Analysis Services.

One thought on “The power of Excel-friendly OLAP

  1. Andreas Flockermann

    This is the old quarrel between MOLAP and AS cube supporters. To say MOLAP is faster than AS is not correct. It depends a lot of the type of application you build. When you build a big, attribute rich cube, based on a large data warehouse Analysis Services is much faster and scales much better than a MOLAP cube. For financial cubes, budgeting and consolidation applications where on-the-fly modeling and write back is essential MOLAP cubes are faster and provide the end user with more end user modeling features than the more IT-centered Analysis Services cube. Sometimes it makes even sense to combine both cubes. I have seen applications where TM1 cubes were uses for budgeting and Analysis Services cubes for reporting.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s