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

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

Today I ran into a nice misfeature of SSIS that worths sharing. If I want to use SSIS to sort a flow of data, containing both lowecase and uppercase strings, I would expect a standard behaviour or, at least, something with some “common sense”. As I am  Read more