Chris Webb's BI Blog

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

Archive for June 2007

Microsoft buys Stratature

with one comment

Microsoft have been on a bit of a buying spree this week: after the Dundas deal they’ve now gone and bought the MDM vendor Stratature. Take a look at Stratature’s site for more details:
Jamie Thomson has some extra information here:
 
Yet another step closer to Microsoft having a complete BI stack…

Written by Chris Webb

June 7, 2007 at 11:55 pm

Posted in On the internet

SQL2008 Webcasts

leave a comment »

Via Euan Garden, here are some upcoming webcasts on new SQL2008 (Katmai) functionality:
…including one on new dimension design features in AS.

Written by Chris Webb

June 5, 2007 at 7:05 am

Posted in On the internet

Katmai Public CTP / Dundas Deal

with 2 comments

I’m not at TechEd so this is second-hand news, but two big announcements: first of all, the first public CTP of Katmai is available for download on Connect; secondly, and more interestingly, a deal has been done where Microsoft has licensed Dundas’ data visualisation components. Russell Christopher has the best breakdown of this deal I’ve seen so far here:
He’s right in wondering whether the OLAP component is part of this deal – that’s the big question from the AS point of view.
 
UPDATE: see Russell’s comment below – the OLAP components (http://www.dundas.com/Products/Chart/NET/OLAP/index.aspx) are part of the deal! For me, the obvious use is as a replacement for OWC, not just instead BI Development Studio but as a free component that anyone developing a thick/thin client for Analysis Services can use. Next question: does licensing the components mean that Microsoft can now give them away for free like this? Or can it only use them embedded in its own products?

Written by Chris Webb

June 4, 2007 at 9:38 pm

Posted in On the internet

Generating Excel 2007 workbooks linked to SSAS using SSRS and OfficeWriter

with 2 comments

Here’s the second of my (paid-for) articles for the folks at Softartisans:

http://officewriter.softartisans.com/officewriter-410.aspx

This time they wanted me to write something about using OfficeWriter with Analysis Services, and after a bit of thinking I came up with the idea of trying to generate Excel workbooks using OfficeWriter and Reporting Services that use the new Excel 2007 cube functions so that they have live links back to Analysis Services. After a lot of sweat I got it to work, and I have to thank Excel MVP Charley Kyd (the guy behind the Excel BI site http://www.exceluser.com/) for giving me the solution to the problem of OfficeWriter writing values to the cell Value rather than Formula property. Hopefully this is the sort of thing that could be made easier when/if OfficeWriter gets integrated with SSRS in Katmai.

Written by Chris Webb

June 2, 2007 at 10:12 pm

Posted in Uncategorized

Book Review: The Rational Guide to Business Scorecard Manager 2005, by Nick Barclay and Adrian Downes

leave a comment »

I’ve got an admission to make: I’ve never really done anything seriously with Business Scorecard Manager (perhaps European businesses are less interested in formal methodologies like the Balanced Scorecard?), so when Nick Barclay asked me if I’d like a free copy of his new book about it I was very interested to see it so I could get up to speed. Having been a long-time reader of his blog (http://nickbarclay.blogspot.com/) and also having recently started reading his co-author Adrian Downes’ blog (http://adriandownes.blogspot.com/), I had high expectations since both are among the best Microsoft BI-related blogs out there and I wasn’t disappointed.

BSM2005 isn’t a massive topic, and as such is an ideal fit for the Rational Guide series where books are limited to 224 pages in length to make sure they’re as concise as possible. In a world where most IT books seem to be doorstop-sized this is a welcome move, and although Nick and Adrian have sidestepped this constraint by making a couple of extra chapters download-only the book is very to-the-point without descending to Books Online territory. The technical side of things is handled with great clarity and there’s also a healthy amount of discussion of the theory of performance management too. The text is clearly laid out with a lot of illustrations and all processes are broken up into numbered steps making it all very readable.

The one obvious (and probably unfair, but it’s what everyone will be thinking) criticism that can be made about this book is that it’s about BSM2005 rather than the forthcoming PerformancePoint. Hopefully the authors are planning to update it as soon as PerformancePoint gets released, whenever that will be - it seems like the entire Microsoft BI world has been holding its breathe waiting for PerformancePoint for so long we’re in danger of turning blue and fainting. Apart from that, if you’re about to start a project involving BSM2005 I can’t imagine a better resource to have on your desk.

You can buy it from Amazon UK here.

Written by Chris Webb

June 1, 2007 at 4:49 pm

Posted in Books

Follow

Get every new post delivered to your Inbox.

Join 3,071 other followers