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

The Microsoft Business Intelligence Conference 2007 website is now live. The conference is scheduled on May 9-11, 2007, in Seattle, WA. It’s not a “traditional” Microsoft technical conference like TechEd and PDC: it’s targeted more on project managers,  Read more

When you create a linked measure group into a cube, the cube you are creating inherits properties of original measures by copying values into the new cube. If you change the format string into the original cube, you don’t modify automatically the linked  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 like to see measures organized in  Read more

This is the news for 2007: the Microsoft Business Intelligence Conference will be in Seattle, May 9-11 (I got the link thanks to Chris Webb’s post ). I suppose we will see PerformancePoint Server in action and may be some anticipation of Katmai. I’m curious  Read more