Client Tools


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):

He’s been working on something called nextanalytics:

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:,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: 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.

2 thoughts on “nextanalytics

  1. Hi Chris,
    Thanks for taking a few minutes to comment on nextanalytics.
    You may have already noticed, but I posted an example nextanalytics script that compares to what Mosha posted in MDX.
    Mosha\’s can be found at:
    The nextanalytics flavor of it can be found at:
    If you (or anyone) have any comments or questions, please don\’t hesitate to ask.
    Ward (CTO nextanalytics)

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.