Browsing Analysis Services cubes is typically done by power users in SQL Server Management Studio or Excel. However, because of a requirement stating that intranet and non-intranet users need to be able to access and browse an OLAP cube I had to go out there and try to find the best OLAP browser on the market. The client had been using Dundas OLAP Services with mixed success, and had purchased PerformancePoint with ProClarity but never used it because of infrastructure issues. That is why they used Dundas as an interim solution. Dundas’s OLAP Services is a user-friendly tool, but tis performance is not ideal when it comes to large grids, so my client wanted something combining Dundas’s usability with Excel’s performance, which could be used both internally and externally.
I contacted Microsoft with a question: “What tools can I use?” They came back to me with the following suggestions:
- IntelliMax Solutions OLAP Browser (an Australian partner)
- BI Companion
I added PerformancePoint to the list, as well as Radar-Soft’s OLAP Browser, so my final list was:
- BI Companion
A sales guy told me that they will organise an online demo for me, and then if I am interested, they will organise an evaluation installation of their product on our servers. That just happened half an hour ago and it immediately became apparent that the product lack one critical piece of functionality – it does not support attribute hierarchies. So, I cannot use anything but user-defined custom hierarchies, because according to the support person, including attribute hierarchies make the grids and reports “too big”. I, however, definitely need these big grids/reports. Otherwise, the tool is nice and simple with very obvious support for Custom Data – you can define this property from the UI, which makes it easier to work on non-Kerberos enabled environments. It also should integrate with PerformancePoint and Reporting Services, but I did not test those parts, because of the aforementioned problem with attribute hierarchies.
They were very friendly and responsive. I got an evaluation install, tried it out and it worked fine, apart from a small bug with non-aggregatable dimension hierarchies, which they fixed immediately. I was quite impressed with the product. It seemed to perform slightly better than Dundas, but it also was slightly less user-friendly. The interface imitates Cube Browser and is very feature-rich. Unfortunately, the HTML version did not work with Firefox, so they suggested using a SilverLight version, which was not supported by my client. As one of my requirements was cross-browser operability (IE and Firefox at least), BI Companion became a no-go-to for me.
Panorama’s NovaView product competed with PerformancePoint as a dashboard creation tool and I have no idea why Microsoft recommended a competitor. I contacted their reseller in Australia and the sales person organised an online demo. I could play with their grid analytics components and it seemed OK. NovaView comes in two versions – a legacy Java version, as well as a new Flash version still in development. The Flash version is quite nice, but still harder to use than BI Companion or Dundas. As a big miss in the current version, Panorama NovaView does not let the user to add/remove dimension hierarchies from its grid columns. It can be done on rows, but not on columns, which is frustrating and ultimately a critical lack of functionality in my case. The Panorama support person told me that “they did not want to release all features yet” and that they have it going in their lab. He also advised me to use the Java version until the Flash version gets updated. I did and found out that the Java version is indeed fast, but not as fast as Excel and ProClarity. Furthermore, Panorama’s product is just too big for our needs and all of its administrative functionality, which includes user management, security and what-not, is just not necessary. Otherwise it looks nice.
The Dundas OLAP Services OLAP grid is very usable – all the users need to do is drag and drop dimension hierarchies to browse the cubes they have access to. Unfortunately, it is a bit buggy and very slow when the cells, which need to be displayed, hit the > 10 000 range. After performance testing, we found out that about 50-80% of the processing time takes place on the client machines, where the browser renders a huge HTML table. It turns out that it is not only Dundas which has the same issues. Any HTML OLAP tool I tested suffers from exactly the same problem. This includes Dundas, BI Companion and Radar-Soft. Nothing we can do. Dundas supports paging, so the results can be split in a number of pages. It performs better if that feature is turned on, but requires hacking when exporting to Excel, because in order to export the whole grid, by default the user needs to export all the pages individually and then manually concatenate them in Excel. Since the HTML table problem cannot be rectified by Dundas or us, Dundas’s OLAP Services remain what they were intended to be – an interim solution.
Dated, but FAST. ProClarity still beats all other solutions with its performance. It was as fast as Excel and much, much faster than anything else. Although it lacks the apparent user-friendliness of some of the other solutions, it does allow users to conveniently browse OLAP cubes. Furthermore, it integrates well with PerformancePoint. Unfortunately, 6.2 is its last ever version. Whether its functionality gets implemented as a part of SharePoint 2010 is still to be announced by Microsoft. By the current way things look, ProClarity is still the best solution for ad-hoc OLAP browsing. It is stable and even though its installation is not quite smooth (e.g. requires IIS to be running gin 32bit mode), it does offer what most users would feel comfortable with. Its drawbacks are: tabbed interface, no drag-drop, and outdated graphics. Not perfect, but good enough. Oh, and it works with Firefox.
The Microsoft dashboarding tool offers an Analytics Grid part, which can be used for ad-hoc analysis. Unfortunately, it does not allow the users to add more dimension hierarchies on rows or columns. What is does well is drilling up or down the hierarchies and slicing by other hierarchies. Unfortunately this is hardly enough when it comes to full-featured ad-hoc reporting.
The small OLAP browser Radar-Soft is offering seems fast at a first glance. It would have been a nice small tool if it did not have one major problem – paging. It pages everything. It even creates a number of pages within cells. This improves performance but makes it impossible to use if we want to export a whole grid to Excel. I guess that some of the paging can be disabled, but I am quite sure that, since it is HTML, it will have the aforementioned issues with performance when it comes to displaying a relatively large HTML table.
The three HTML solutions – Radar-Soft, Dundas and BI Companion all had the same issue with performance. My guess is that there is no HTML solution which is faster, because in the end it comes to browser performance rather than MDX or .NET implementation.
Panorama with its Java and Flash versions is maybe a good solution for a full-featured dashboarding and reporting, but is a massive overkill for our circumstances. Also, it is not very user-friendly and not very fast.
PerformancePoint and ProClarity are my favourite and I believe that Microsoft’s offering provides the best capabilities for our users at least until something better comes from the Microsoft workshop. These integrate nicely with SharePoint and perform very well. While PerformancePoint is very user friendly, I would not say that for ProClarity. Hopefully in the future we will see nicer OLAP browsing by Microsoft based on these two tools.
A word about SilverLight and Excel
While SilverLight OLAP browsers are available by various software houses (most notable BI Companion has one in Beta), it is a relatively new technology and was not an option for me as it was not in my client’s SOE. Also, from my testing it does not seem like it is much faster than HTML, but definitely looks nicer.
Excel is, in my opinion, the best tool for browsing OLAP cubes inside the organisation. It is fast, and provides a rich set of analytics capabilities. There are a lot of discussions about Excel as a report authoring tool on various blogs, but I believe that for ad-hoc reporting there is nothing out there which beats Excel. Despite this, I could not recommend it to my client, as the solution is exposed to external users and letting them connect to our cubes directly though Excel is just impossible considering our security infrastructure. Also, Excel Services does not provide enough ad-hoc functionality, as it does not allow users to modify the Pivot Tables.
I wish and hope that Microsoft releases a full-featured, user-friendly and performant OLAP browser as part of Visual Studio and .NET or as a part of SharePoint 2010. Such a tool is just a must and a serious miss in the Microsoft BI stack. The combination of Excel+PerformancePoint+ProClarity does the trick for now, but as ProClarity is getting discontinued, there must be something in the future toolset, which takes its place.
A few other bloggers wrote posts closely related to this topic:
Richard Lees – Which cube browser for Microsoft OLAP
Richard Lees – What’s preventing Excel from being the ubiquitous cube browser
Chris Webb – Proclarity Migration Roadmap (or lack thereof)
26 thoughts on “On the search for the perfect OLAP browser”
Hi, nice article. My company bought Dundas OLAP as well and it is sooooo sooooo slow. It is basically unusable it is so slow. it is interesting to read your analysis of the different products out there. I am glad I am not the only one who had problems. Please keep me posted on your hunt!
First and foremost I would like to congratulate you for writing such an interesting blog. I found it very informative and helpful. I wanted to point out to one fact that you might have missed during your evaluation. Panorama and Microsoft are actually very strong partners and jointly works on GTM and product strategy. You can read more what Guy Weismantel says in the official Microsoft BI Blog: “We've done a lot of work with our friends at Panorama Software over the course of the last six months or so to put together a great story for our joint customers around an end-to-end BI solution that takes advantage of their capabilities in advanced analytics, and our BI solution as delivered through Office, SharePoint, and SQL Server. This has involved working with both their senior leadership team, as well as their engineers on ways that we can fashion a clear GTM strategy together, while allowing Panorama the ability to capitalize on the super cool offerings coming up in Office 2010, SharePoint 2010, and SQL Server 2008 R2, particularly focused on Project Gemini. “ (Read more: http://blogs.msdn.com/bi/archive/2009/07/15/bringing-panorama-back-into-the-big-tent.aspx )
TP: Well, there are ways to "improve" performance. We limited the nuber of dimension hierarchies on rows/cols, enabled paging and then disabled it for the exporting to Excel functionality. They let you tweak their software, which is nice. Still, it performs just as good as BI Companion. 10% goes on the SSAS box, 10% on the IIS box and 80% on the client machine – rendering the HTML table.Me?: Yes, it was definitely a miss on my side. And that also answers my question – why Microsoft recommended Panorama NovaView. I was left with the impression that Panorama competes with Microsoft from:Panorama Positions Itself As PerformancePoint Alternativehttp://www.crn.com/software/216402736;jsessionid=YFHKJCYSLL0IJQE1GHRSKHWATMY32JVNandPanorama Software Offers Dedicated BI Option to Microsoft PerformancePoint Server and ProClarity Customershttp://www.dbta.com/Articles/Editorial/News-Flashes/Panorama-Software-Offers-Dedicated-BI-Option-to-Microsoft-PerformancePoint-Server-and-ProClarity-Customers-54358.aspx
Great topic! Wish there are more articles like this one.Tomislav Piasevolihttp://www.softpro.hr
There is one more OLAP browser.See:http://code.google.com/p/ranet-uilibrary-olap/
First off, great post. You usually can't find info like this without buying the OLAP Report.I have worked with companies that used ProClarity, Panorama, Reporting Services, PPS and Excel. Each I have found has it's pros and cons as you stated. If you are talking about just something to fire up and browse a cube, well Excel does work pretty good. If you want to do more customized analysis then I think ProClarity and Panorama's desktop clients work the best. From a dashboard and enterprise BI solution, PPS and Panorama offer pretty good out of the box functionality. I found that when a company starts to customize the tools is when you start to run into issues.Did you try Report Portal?thanks again for the article!
Frank: I haven't tried Report Portal. There is a myriad of solutions out there. My point was to just show what I experienced with a few options.
Very interesting and usefull post. I'm agree with the some of the tools you mentioned… Another point is that Panorama was bought by Microsoft… Regards,Pedrohttp://www.pedrocgd.blogspot.com
Thanks for the info. I completely agree with the Dundas Component issues. It's practically on life-support with Dundas attempting to come out with their silverlight dashboarding suite.There are so many BI tools out there and the devil is always in the detail or in the price tag. Interesting article came out from SQL Server Mag's editor choice award this year – Panorama. Guess I'll take a closer look at them as well.THanks for the article!
Galaktika Corporation announces the first stable release of Ranet.UILibrary.OLAP.Ranet.UILibrary.Olap is component library for OLAPIt provides parsing, generating and visualization of MDX language and MDX query results. Moreover it provides data input and Writeback to OLAP cube.It works under .NET and Silverlight.It includes: * MDX Document Object Model (MDX DOM) * MDX Parser * MDX Generator * Description of supported MDX Syntax * Set of OLAP visual controls for MS Analysis Services: o Dynamic Pivot Grid – Pivot Table with WriteBack ability for arbitrary MDX query o MDX Query Designer – visual MDX query builder o OLAP metadata explorer o Choice controls * Samples of use WhatsNew and other information is available at the project page:http://code.google.com/p/ranet-uilibrary-olap/
Very useful post!I’ve been searching for this kind of post for a long time.
Can anyone share additional info on the radar-soft asp.net Olap Grid Direct. Where in you don’t need an OLAP server, but you can build PIVOT table using data sources of any kind through the DataSet object or IDataReader interfaces.
The Pro-Clarity that you are testing is this the Standard or Professional edition.
It was some time ago now, but I think I created a grid with Professional and then I run it with Standard.
We are using Dundas controls which has lots of issues. Now, the company are no more into Component technology. They are now into different space.
Sadly Dundas OLAP services are no longer available for sale. It was probably the best AJAX OLAP browser I had seen. Dundas stopped selling in Oct.2010 because the technology had been acquired by Microsoft. Now it would appear that Microsoft are just sitting on it and thus depriving the development community of a decent cube browser. I wish I had know about the October deadline before as I can no longer buy a licence for it. Radar-cube doesn’t come close in my option. RIP Dundas OLAP services!
Actually, I don’t suppose anyone can sell me a licence for Dundas!??
Yes, unfortunately Dundas seemingly will go hand in hand with ProClarity in the history of BI. I’m as annoyed as you on this one. Hopefully Crescent will include an OLAP browser and will be a worthy replacement of Dundas (then it could make sense to get it canned). Also, hopefully, Crescent-Dundas will not be like PPS-ProClarity – in other words – completely different product using just some technology from the acquired one.
I’m not aware of any way to get Dundas anymore (but I could be wrong) – maybe you can try contacting Microsoft directly.
In response to your closing comments, I would like to submit Pyramid Analytics’bioXL 64-bit, thin client OLAP browser as a viable solution. Finally offering the business user access to over 90% of MS SSAS functionality, in a package that is slick, fast, and has the familiarity of an Office desktop product.
Check it out at: http://www.pyramidanalytics.com/bioXL-ad-hoc-analytics.aspx
I need a Cube browsing tool, actually in my DWH i have data for various partners, i want to create a single cube and based on the login user i want to apply some conditional filter like partner name(to protect data of other partners). could you suggest me something for same
Have you considered Cognos? You can use Cognos Analysis Studio to navigate through MSOLAP cubes as well as there own Powercubes.
Using Cognos Analysis Studio as an OLAP browser for SSAS would be a massive overkill imho. It is expensive, slow and hard to install/configure and work with. Besides, it is not very flexible and user-friendly..not even in v10.1.1.
But, I’d agree it is an option if you already have it in the enterprise.
I have been using Radarsoft for a project and there are many issues but the worst of all is that the support is really a joke. They rarely answer and the ticketing system and not even their phones. Even with such a low price, they should support their controls better.
Does anyone had such a problem?
I’ve only tried their evaluation version and also there were bugs.
The Analyzer from the Strategy Companion looks interesting. No problems with instalation, lightweght aplication, intelligent maps, 3D charts and I didn’t noticed problems with HTML slowdown. The Analyzer is described as 100% zero-footprint browser so it migh be good choice. I must admit that I only tried ev. version but it has full functionality limited only to number of reports.
It is only working for IE6 and above. Really nice product though
Comments are closed.