nextanalytics

Hands up who remembers OLAP@Work? If you do you’ve been working with Analysis Services for a long time, back when it was still OLAP Services… for those of you who don’t, it was one of about four options you had if you wanted a client tool circa 1999; it was an Excel addin and it was pretty good. Anyway, I’ve just seen this article on Intelligent Enterprise on what Ward Yaternick, the guy who founded OLAP@Work, has been up to since leaving Business Objects (which bought and eventually killed OLAP@Work):
http://www.intelligententerprise.com/blog/archives/2008/06/bi_innovation_f.html

He’s been working on something called nextanalytics:
http://www.nextanalytics.com/

Poking around on the site it looks quite interesting; certainly there are lots of mentions of MDX so I guess it supports Analysis Services as a data source (although it supports a lot of other data sources too). The key thing is that it allows you to create complex queries and calculations using a scripting language. Clearly this scripting language allows you to do the same kind of things you can do with MDX and indeed one particular entry on the nextanalytics blog caught my eye:
http://www.nextanalytics.com/component/option,com_myblog/Itemid,342/show,Can-a-business-intelligence-product-be-used-to-answer-analytic-questions-.html/

I was about to leave a comment when I saw that Mosha had beaten me to it. Mosha’s right that contrary to what the original entry says, what Ward is describing is certainly possible in MDX, but Ward also has a point that it’s not something that someone with an average knowledge of MDX could accomplish. Can nextanalytics prove itself to be easier to use than MDX? Time will tell. I’ll have to download the open source version of it (available here: http://www.codeplex.com/nextanalyticsOS) to try it out. When I have a spare moment, of course, which at the current rate is going to be some time next year.

Excel 2007 Workarounds

Interesting post here from Allan Folting on the Excel blog discussing some workarounds for common problems that arise when using Excel 2007 as a client tool for AS2005:
It explains why you can’t select individual calculated members on non-measures dimensions, which in my opinion is the biggest barrier for the use of Excel 2007 as a front end because it effectively rules out the use of time utility dimensions. The workaround discussed is to use an older version of the pivot table but you lose as much as you gain from doing this; luckily a ‘future solution’ is promised. I guess this will come in a future service pack for Excel because apparently (changing the subject slightly) we’re not getting a SP3 since not enough people have asked for it (see here for more details). Pretty stupid, eh? Esepcially given the fact that SP2 was a bit of a disaster from an Analysis Services point of view with a whole load of bugs and performance regressions appearing. If you’d like to see a SP3 then vote here on Connect:
 
Last of all, talking of Excel 2007 BI, it seems like you can now put Excel directly on top of SAP Netweaver BI:
Good from the point of view of industry-wide support for MDX, I suppose, but on the other hand it does eat away at one of the unique selling points of the MS BI stack.
 

Panorama: One Year On

After the Proclarity acquisition last year many people, myself included, thought the writing was on the wall for Panorama: after all the two companies’ product lines were very similar and if Proclarity was going to be supplied by Microsoft then there wasn’t going to be much point in looking at Panorama any more. However, one of the things that surprised me at the Microsoft BI Conference a few months back was the big display that Panorama put on. A big stand in a central location with leggy girls luring the attendees (at least the male ones) to it, a party at the top of the Space Needle – this was a company that was not dead, or at least making a pretty big effort to show that it wasn’t dead.

Of course the real test is whether the software is any good or not. In keeping with their bullish mood Panorama were handing out DVDs with their Novaview suite pre-installed on a virtual machine (you can download it here: http://challenge.panorama.com/forms/default.aspx) and since it was a while since I’d last seen what they’d got to offer (and after some encouragement from their marketing department) I was curious to check it out. After a lot of false starts surrounding licence keys etc and help from Panorama – and I have to say that in my experience their pre-sales support has always been very good – I got it running on my laptop and thought I’d share my impressions here.

I have to admit I was disappointed with the Novaview Desktop tool at first: it didn’t look as if anything had changed in the last few years. The UI looks very outdated in a VB6 way and while it’s easier to use than I remember, I’m still not convinced that it’s as intuitive as it should be. Even worse, within a few minutes of using it I got one of those unhandled (although unfatal) error messages that Panorama was always famous for – which simply isn’t acceptable today. These might be purely cosmetic points but users are more interested in this type of thing than some obscure aspect of MDX generation. After a bit more time though I felt more positive. For the power user it does pretty much everything that you’d ever want it to do, such as enter your own MDX, do writeback, advanced filtering, creating calculations; in fact it clearly does what every demanding customer has ever wanted it to do so it’s more than likely able to meet any obscure querying requirements you have.

I took my misgivings back to Panorama and they told me that the desktop client will be dropped in the next release, due Q1 2008, and from that point there will only be an AJAX-based zero-footprint client and a rich client based on Adobe Flex. It’s interesting that the latter is not based on .NET or even Silverlight; not only a move away from the desktop, which is only to be expected, but a move away from the Microsoft dev platform which I suppose makes sense given Panorama’s repositioning of itself away from being a purely Microsoft partner to working with SAP as well. Presumably it will have much the same capabilities as the current desktop client but look rather better… 

In the meantime, the comparison between Novaview Desktop and ProClarity Desktop is one that has been made a lot in the past and is probably worth making again. In terms of querying functionality they’re neck-and-neck but in my opinion Proclarity is easier to use and looks marginally better, although it is still falls way short of what I’d expect from a modern BI tool. The problem with the Proclarity Desktop tool is that is has it has been declared dead by Microsoft: the last official release was made late last year and it seems there’s no place for a rich client in the bright shiny web-enabled PerformancePoint future. I’ve heard various rumours about it such as that it was going to be turned into an Excel addin or, more recently that it was going to be rewritten in .NET, but that lack of any clear direction from Microsoft on its future is a bit frustrating. I suspect that Microsoft have decided that Excel is the only desktop tool anyone is going to need, but I think there’s still a role for a dedicated client for power users and I know a lot of other Proclarity users feel the same way. If you’re in the market for a full-featured AS desktop tool then there’s little point in going with Proclarity Desktop now, so Novaview wins by default given that there’s a clear roadmap for its future.

As far as the web-based querying and dashboarding functionality goes there is clear competition with what Panorama and PerformancePoint have to offer. A lot of companies will simply go with the Microsoft offering simply because it’s from Microsoft, and that’s a perfectly valid decision; anyway, given the lineage of the product it’s going to be a lot better than a typical Microsoft version 1.0. Why choose Panorama then? Panorama claim to be a lot more scaleable on the web than the old Proclarity equivalents; it’s probably too early to tell whether the same will be true of PerformancePoint though. The cross-platform capabilities will probably be the key: from what I’ve seen in my Analysis Services consultancy work, a lot of companies using AS also use SAP BW and a common front-end for both could be an enticing prospect. I’m also told that Panorama will be building functionality behind PerformancePoint to enable import of data from other platforms and in front of it to enable integration with other applications and business processes – the kind of value-add stuff that Microsoft can’t offer because of its longer release cycles and limitations on who they can partner with.

So, it looks like Panorama have got a future after all. Just as the Microsoft’s entry into the OLAP server market didn’t lead to the immediate bloodbath among rival OLAP vendors that many predicted, so its entry into the client tool market hasn’t (yet) killed off the old third-party client tools market. The delay in getting PerformancePoint released after the Proclarity acquisition and the fact that most companies are a long way from rolling Office 2007 onto their desktops means that companies like Panorama have had a chance to work out a survival strategy – and the choice this means can only be a good thing for us end users.

Resurrect the XMLA Council!

A few weeks ago I had an interesting email conversation with Nick Goodman and Julian Hyde after Nick noticed that the XMLA Council’s web site which used to be at www.xmla.org now redirects to a site ‘brought to you by Simba Technologies’. Now I have nothing against Simba – in fact they have a number of interesting products – but the lack of an independent web site highlights the fact that the XMLA Council is in effect dead, having not met (so I understand) for several years now. A few days later I saw Andrew Wiles had blogged on this topic too:
http://andrewwiles.spaces.live.com/blog/cns!43141EE7B38A8A7A!199.entry

As Andrew points out, at present XMLA interoperability is something of a myth. There are a few tools that do manage it such as Rex which, unlike Mosha, I was able to use successfully against AS2005 as well as Mondrian although it’s probably not worth the bother (it’s nowhere near as good as SQL Management Studio for running MDX queries). JPivot is another open source tool that claims to work against AS and Mondrian but although I know other people have got it working against AS2K (see for example here: http://forums.pentaho.org/showthread.php?t=49954) and AS2005 I’ve never been able to do so against AS2005 despite several hours of effort. The only commercial product that works against multiple platforms that I’ve had experience of is Panorama (though I know there are others out there), and as this blog entry suggests it’s been a hard slog for them to work with SAP’s bizarre implementation of MDX.

I guess what happened with the XMLA Council is that like a lot of initiatives like this there was an initial burst of enthusiasm that dissipated once its ideals came into conflict with the demands of real-world product development. I know it’s pie-in-the-sky to expect perfect cross-platform interoperability but I think the present situation could be made a lot better and I think the time has come to resurrect the XMLA Council – and I think it’s up to Microsoft to take the lead on this. I don’t want to suggest that Microsoft have some kind of moral obligation to do this as de facto owners of the spec, rather that while everyone would benefit from increased interoperability Microsoft would benefit most. The first reason why is that the XMLA-compatible client tool market is dominated by tools that work against AS and which are sold by Microsoft partners, and they would be able to expand their potential customer base to support other servers like SAP BW and Essbase. More importantly though, the client tool that everyone really wants to use is Excel and if it were possible to hook Excel 2007 up to other OLAP engines then it would cement its position as the BI client tool of choice. Reporting Services’ support for SAP BW and Essbase shows that Microsoft are interested in supporting competing OLAP tools so is it unrealistic to expect Excel could support the same platforms?

Intelligencia OLAP Controls

Andrew Wiles announced yesterday the availability of a beta version of his new MDX query builder component, ‘Intelligencia OLAP Controls’:
I had a quick demo of it this morning and I was very impressed. It has some really quite clever ideas in it such as the spreadsheet-based calculation functionality, and while it doesn’t do absolutely everything I’d like (it is still a beta, after all) it does an awful lot and Andrew is very open to feedback for what needs to be added. If you’re interested in checking it out you can download it here:
 
The product is aimed at ISVs, in-house developers and consultants who want to incorporate MDX querying functionality in their own products. I’ll be blunt: the company that really should be looking at this, and perhaps licensing it for use in Katmai and/or future versions of Office, is Microsoft. The control’s Office 2007 look-and-feel gives a tantalising glimpse of what a power user would want to see in Excel when connecting to AS and it puts the Reporting Services MDX query builder to shame.

DS Panel

It’s Day 0 of the BI Conference, I haven’t even registered and I’m already busy… This morning I went to a presentation by DS Panel (the guys who brought you the Santa Dashboard a few months back). They’ve been around in the Microsoft BI world a long time but for some reason I’d never seen their stuff so I was curious to check it out.
 
Now the question that I’ve been asking all third-party tool vendors, and which I’m sure all prospective customers are asking too, is why should I buy from you when PerformancePoint is just around the corner? For DS Panel and others about 80% of what they do is what all AS client tools do and certainly what PerformancePoint is going to do, so it’s the details, the unique features and the quality of execution that’s important. DS Panel have a new release of their core dashboarding product, DSP Performance Canvas (see http://www.prweb.com/releases/2007/05/prweb524461.htm for the press release, http://www.dspanel.com for the company home page) and it certainly looks pretty and seems easy to use; their use of AJAX means it’s extremely responsive for a web app too. What caught my eye was their integration with various enterprise search engines, something I blogged about a while ago although I’m a bit more positive about the idea than I was then. They also have a cool solution for dashboarding on mobile devices, which I’ve not seen anyone else do, and where their use of sparklines is really effective; and a few other nice features such as the ability to add annotations to specific slices of data. Overall definitely worth checking out if you’re in the market for a dashboard application, need easy Sharepoint integration, and can’t wait for PerformancePoint to be released or reach a useable level of maturity.
 
Hmm, now time for me to go over to the conference centre and register. There will be a lot more blogging to come over the next few days: more product reviews, reports of presentations and maybe even another podcast!

Silverlight

Reading all the fuss about the Silverlight announcement (see http://www.microsoft.com/presspass/press/2007/apr07/04-15WPFEPR.mspx) makes me wonder how long it’s going to be before we have a Microsoft BI client tool that makes use of it. I’m seeing more and more of Crystal Xcelsius in the marketplace (which is based on Flash, which Silverlight is competing with) and business people seem to be very impressed with some of the wizzy animations you can do with it – see, for example, Janne Pyykkö’s demo here http://jpbi.blogspot.com/2007/04/crystal-xcelcius-playful-3d-demo.html. Surely it can only be a matter of time…?
 
UPDATE: James Wakefield has just sent me this link to an article he wrote on hooking Xcelsius up to any XMLA compliant OLAP database:

White Paper on Designing Cubes for Excel 2007

There’s a new white paper available on designing cubes for use with Excel 2007:
 

Microcharts 1.1

I blogged about Microcharts last year, but I’ve just heard that version 1.1 has been released and one of the new features is the ability to use them in server-based reporting tools like Reporting Services, as well as in Excel. Take a look at the following two videos which showcase the products:
 
There’s also a good article on building a dashboard on Adventure Works in Excel 2007 that has some good examples of how to use the new AS cube spreadsheet functions like CubeMember:
 
I see Nick Barclay has already worked out how to use them in PerformancePoint scorecards:
 
Before we get all excited about Excel 2007 as a client tool, I thought I’d also point out this recent post from Marco Russo highlighting a massive drawback with using it on cubes that have time utility dimensions:
What an absolute howler, especially given that I remember Excel 2000 had the same problem and it got fixed in a later release (either XP or 2003) after a lot of complaining. Top priority for SP1 please! 

Performance Management Early Start Initiative

Again via Ben Tamblyn, news of the Performance Management ‘Early Start’ programme for partners:
You can sign up for it here:
…and download other useful stuff to do with PerformancePoint etc.