Chris Webb's BI Blog

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

Archive for June 2007

BI Survey

leave a comment »

It’s BI Survey time again! Wasn’t it the OLAP Survey last year? Anyway, it always makes for a fascinating read when it comes out. Here’s the blurb:
 
We would very much welcome your participation in The BI Survey. This is the largest independent survey of OLAP users worldwide. The Survey will obtain input from a large number of users to better understand their buying decisions, the implementation cycle and the business success achieved. Both business and technical respondents are welcome.

 The BI Survey is strictly independent. While vendors assist by inviting users to participate in the Survey, the vendors do not sponsor the survey, nor influence the questionnaire design or survey results. As a participant, you will not only have the opportunity to ensure your experiences are included in the analyses, but you will also receive a summary of the results from the full survey. You will also have a chance of winning one of ten $50 Amazon vouchers. Click here to complete the survey on-line:

Written by Chris Webb

June 15, 2007 at 6:20 am

Posted in On the internet

Top Ten Best Practices for Processing and Querying AS

leave a comment »

Two excellent new papers published today, on best practices for AS processing and query performance:
There’s a lot of useful information in both which isn’t present in the AS Performance Guide or in other sources.

Written by Chris Webb

June 11, 2007 at 5:33 pm

Posted in Analysis Services

Reporting Services, MDX and Aggregated Values

with 2 comments

Undoubtedly the best time to find out about an undocumented change in functionality in a product is halfway through a demo of said functionality to a large group of people. This happened to me last week: I was teaching my MDX course (written on the last CTP of SP2) and had just finished my speech on all the rubbish aspects of Reporting Services/Analysis Services integration and was trying to show how Reporting Services automatically filtered out all but the lowest level of granularity of data from an MDX query (see Teo Lachev’s post here: http://prologika.com/CS/blogs/blog/archive/2006/02/08/853.aspx and Reed Jacobsen’s posts here: http://sqljunkies.com/WebLog/hitachiconsulting/archive/2006/08/07/22359.aspx and here: http://sqljunkies.com/WebLog/hitachiconsulting/archive/2006/08/04/22346.aspx for details) when I found that it wasn’t doing it any more. Later on I emailed Teo to ask if he knew anything about this change – he didn’t but he asked the RS dev team and they gave him some details (he then blogged about it here: http://prologika.com/CS/blogs/blog/archive/2007/06/10/aggregate-rows-and-sp2.aspx). So, a small victory for the people – Reporting Services now no longer tries to force its own aggregation functionality on you and you always see the full results of your query, unless you’re already using the RS Aggregate function in your reports. This is apparently in response to customer demand. Just be sure to check any existing RS/AS reports you’ve got in production to make sure they’re not displaying extra rows now!

I’m now hopeful that the message will get through about the other stupid restrictions that RS places on AS data sources, such as only being able to put the measures dimension on columns. I’ve not kept up with the changes in RS2008 as much as I should (Teo again has a good overview of what’s coming here: http://prologika.com/CS/blogs/blog/archive/2007/06/09/teched-2007-us-memoirs.aspx) but I’ve not heard that these restrictions will be lifted. The problem is of course that RS expects to do all the aggregation of data itself, but the RS dev team don’t seem to understand that if I’m using AS then I will have designed all my aggregation business logic into my cubes and dimensions and I couldn’t care less about what RS can do in this area (for an example of their mindset, see the somewhat patronising comments on this posting on Connect from last year: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125414).

While we’re talking about Katmai I might as well mention why I’ve not blogged about the new AS features in it – it’s because there aren’t all that many. You’ve probably already read Mosha’s post about the attribute relationship designer (http://sqlblog.com/blogs/mosha/archive/2007/06/07/katmai-june-ctp-attribute-relationships-tab.aspx); Vidas Matelis has covered the other cube design wizard changes here: http://www.ssas-info.com/VidasMatelisBlog/?p=22#more-22. More features will come in later CTPS but overall it’s really going to be all about performance improvements and manageability, and while I know a bit about some of the planned features it’s too early to blog about them because it’s too early to say what’s going to actually get included. Suffice to say that for the serious AS developer there are going to be some very welcome improvements but there won’t be anything that excites the marketing people.

Written by Chris Webb

June 11, 2007 at 2:04 pm

Posted in Reporting Services

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

Follow

Get every new post delivered to your Inbox.

Join 3,301 other followers