If you edit a legacy DTS package with SQL Server Management Studio, you may want to know how we can show the multi-phase data pump operations. I haven't found an option to do this with SQL Server Management Studio. However, when you need to do something,  Read more

Almost one month ago I made a post about a brand new Distinct component for SSIS made by Alberto Ferrari and freely available on SQLBI.EU . The most used way to get distinct rows in a Data Flow that I've seen is to use the Sort component, asking only  Read more

After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here , but today I found the way to reproduce the error. This is a scenario that  Read more

Alberto Ferrari has published on SQLBI.EU a Distinct component for SSIS . The big advantage is less memory used when you have few distinct values extracted from a large set of data. Component and source code are freeware. Now the challenge is: how to  Read more

Today I had a big trouble with one customer. We migrated an AS2000 solution to SSAS2005, making a lifting to dimensions just to consolidate into attributes what were indipendent dimensions in the old cube. One of the old dimensions contained only one  Read more

This is the paper we waited for a long long time: the Analysis Services 2005 Performance Guide is available for download from MSDN downloads. This paper is 120 pages of really precious informations. I don't have time to read all now, but I have found  Read more

I wrote a simple C# class that is useful to manage custom MDX scripts (like custom members definitions) on existing cubes, without the need of a new deployment. I named it MdxScriptUpdater and it is freely available here: http://www.sqlbi.eu/mdxscriptupdater.aspx  Read more

Thanks to Microsoft support for Analysis Services (one of my customers opened an incident), I just discovered an issue that is not indexed anywhere in Google, so I write a post hoping to save time of the next unlucky user... I you use HTTP access to Analysis  Read more

Almost ten years ago (...ouch!) I visited Australia and I had a real love for Sydney. I got these memories tonight because I found a detailed list when I was looking for some existing request for new features in Reporting Services. One is the Rich TextBox  Read more

Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Moreover, Excel 2007 offers a good MDX quality of the produced query against Analysis  Read more