I’ve been so busy in the last weeks that I wasn’t able to blog about PASS Summit 2009, so here’s a short recap. I and Alberto presented the SQLBI Methodology in a 75 minutes slot. The room was full, there were about 200 people and no sits available. We  Read more

The project codenamed Gemini has an official name now: PowerPivot . The complete name should be “PowerPivot for Excel 2010”, but PowerPivot is simpler. I didn’t like that name yesterday, but today it seems better. Microsoft announced this name at the  Read more

A few months ago I wrote about a possible bug using both DirectSlice and MeasureExpression . A few days ago, Edward Melomed answered that the behavior we observed was not a bug but by design: you can read the complete answer on Connect . The key point  Read more

This is the type of blog posts you write after you spent hours on a stupid issue and you want to remind what’s happened. And may be it will help someone else in the future. Scenario: you have a MOSS 2007 with SSRS 2008 in SharePoint integrated mode. You  Read more

I already talked about the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book I wrote with Chris and Alberto . We found several posts around the blogosphere and I'd like to keep track of them - I'll try to update this post whenever  Read more

In these days, I’m starting to use Gemini and I’m discussing about it in dedicated CTP newsgroups. I recently wrote a message that I’d like to share here, but not before some considerations. First of all, like Chris said , Gemini is less than a threat  Read more

Using SSAS 2005/2008, there is no way to apply security to DRILLTHROUGH actions, so we cannot decide whether a specific user is authorized or not to perform a specific action. This is a “by design” behavior, since DRILLTHROUGH actions are initiated at  Read more

I and Alberto will present the SQLBI Methodology session at PASS Summit 2009 . After the very good feedback we got at the European PASS Conference 2009 , we will have the big opportunity to discuss this methodology in front of a broader audience. In the  Read more

A few days ago, I talked about Oslo and metadata issues with BI stack . I got several comments and the discussions it's interesting, but as I said it is too early now to use Oslo - but it could be a foundation for a future product. As a side note, today  Read more

We (I found the issue, Chris created the repro) detected a possible bug using DirectSlice and MeasureExpression. We just posted it here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=455732 The issue could be very dangerous  Read more