If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in…  Read more

Today I come into a nice bug (misfeature?) of SSIS 2008 and I’d like to share it with you. Let’s start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read…  Read more

<rant mode=”funny”> Most of the time I submitted an issue to Microsoft Connect, I got a “it’s by design” answer. I’ve been always irritated by this sentence because they don’t admit in this way that they have a bug. Today,…  Read more

I just submitted a suggestion feedback to SQL Server development team. It is very bad for the user to be forced to see measures under their physical measure groups. There are a lot of reasons for which a customer would…  Read more

The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE(     ‘Product Subcategory’,     ‘Product Category’[Product Category Name] = @Category ) Depending on the client and on the driver you are using to…  Read more

Yesterday I lost at least an hour (but only for a coincidence I haven’t lose more hours) because I came across a bug of Analysis Services 2000. If you put a single quote or a double quote inside a comment, the whole…  Read more

A couple of weeks ago, I wrote a blog post about MCSM for BI certification. This raised an interesting discussion about the reasons why such a certification does not exists, whether it was really necessary, what it should include, and…  Read more

11:34

SSAS Tabular Video Course

Guided Tour of Tabular: Sample Project

…the “Friendly connection name” SqlServer is fine right now. The “Server name” we use…  Watch now

I just posted this bug on the Microsoft Connect site. Please vote it if you think it would be a useful change. This is the issue description. If you set the”Aggregation Usage” to true for an attribute of a dimension (i.e. Customer),…  Read more

I just added two suggestion items to my feedback for SSAS2005. The first suggestion is about the perspectives: it would be useful to select member filters and default members on each single perspective. Another important thing could be to be…  Read more