I just downloaded and tried the CalendarTransform component for SSIS that Microsoft realesed with a shared source permissive license . It’s a useful data flow transformation component that is able to generate apparently all of the attributes you can desire  Read more

A few days ago I have encountered a system error deploying a SSAS project that involves role member. The error message is too generic and it hides the real cause of the problem that is very hard to find. The problem itself is really simple: if you try  Read more

Microsoft released a new release of Excel AddIn for SQL Server Analysis Services : it’s the version 1.5 which is compatible with Analysis Services 2005, compatible in the sense that it fully navigates attributes and hierarchies in a meaningful way. Unfortunately,  Read more

I just received a copy of Applied Microsoft Analysis Services , by Teo Lachev . I have to be honest: I already read drafts of this book through this year because I’ve been one of the reviewer. As I said to Teo, I didn’t realized before that this would’ve  Read more

Microsoft release KpiUtil , a tool that should facilitate the move of KPIs between Business Scorecard Manager 2005 and Analysis Services 2005. It could be useful…  Read more

Today I lost a lot of time digging on this problem so a I hope post about this will save time of other developers! I wanted to import the UDM into a model for Report Builder. You have to do these steps: go into SQL Server Management Studio connect to  Read more

The SQL Server 2005 Feature Pack is freely downloadable and contains a set of useful tools for SQL Server 2005: many items are for compatibility issues (DTS/DSO/DMO backward compatibility), but there are data mining viewer controls and JDBC drivers for  Read more

As you already know, the DTS migration wizard of SSIS 2005 doesn’t migrate Data Transformation Task in a Data Flow component, but instead it uses to encapsulate each Transformation Task into a legacy embedded DTS 2000 package. Now, you can imagine my  Read more

Today I discovered that you can have a working AS2000 database without repository data relative to structure internals to that database (cubes and dimensions). Just to explain how it works. You have a “Foodmart 2000” database Into the Olap Data directory,  Read more

Recently I discovered that a very large dimension could be loaded more effectively by SSAS2005 if it is designed as a snowflake schema instead than as a singular table (star schema). I have to say that I’m a strong supporter of star schema, but these  Read more