Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

nextanalytics

with 2 comments

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.

Written by Chris Webb

June 3, 2008 at 11:28 pm

Posted in Client Tools

2 Responses

Subscribe to comments with RSS.

  1. Olap@Work. Blimey, yeah, I remember that. Good memories from circa 2000.
     

    Jamie

    June 3, 2008 at 11:54 pm

  2. 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: http://sqlblog.com/blogs/mosha/archive/2008/06/08/mdx-answer-to-nextanalytics-challenge.aspx.
     
    The nextanalytics flavor of it can be found at: http://www.nextanalytics.com/public/Examples/MDX-Challenge.html
     
    If you (or anyone) have any comments or questions, please don\’t hesitate to ask.
     
    Ward (CTO nextanalytics)

    ward

    June 11, 2008 at 6:28 pm


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

Follow

Get every new post delivered to your Inbox.

Join 2,868 other followers

%d bloggers like this: