Marco Russo's Blog
View full profileReport Builder trouble filtering date with UDM
Thanks to a blog reader, I just discovered that if you create a Report Builder Model from a UDM and try to create a report filtering a date field, the date you specify in the filter dialog box is inverted (months with days) when the MDX query is generated. Read more
Post SP4 hotfixes for Analysis Services 2000
I just discovered that some weeks ago Microsoft released a cumulative upgrades of hotfixes for Analysis Services 2000 released after SP4. I have to say that I noted AS 2000 is less stable after SP4 intallation (I can say that after months of use) and Read more
Alternative approach for SCD dimensions in SSIS?
Tonight I’ve studied how to improve performance of SCD transformation task of SSIS. I started from the consideration that in an actual SSIS package, the dimension processing is at least one magnitude slower than fact table processing; most of the time Read more
CalendarTransform component for SSIS
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
SSAS and role deployment
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
Christmas gift: Excel AddIn 1.5 for Analysis Services 2005
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
Applied Microsoft Analysis Services 2005
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
KpiUtil
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
Report Builder Model with UDM
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
SQL Server 2005 Feature Pack
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