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

It is finally available the SSAS 2008 book I wrote with Chris Webb and Alberto Ferrari : Expert Cube Development with Microsoft SQL Server 2008 Analysis Services . The book is also available on Amazon . You can also read a sample chapter for free. We  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

You know, today Microsoft doesn’t have a solution to handle metadata of a BI Solution. Really, they don’t have nothing to handle a single layer of the architecture like the Data Warehouse. In a (how much near?) future this gap could be filled by using  Read more