Marco Russo's Blog

   View full profile
Page 62 of 711 results

Excel 2007 PivotTable with calculated members

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

Analysis Services 2005 Performance Guide

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

MdxScriptUpdater

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

Slow HTTP access to AS2000 with Win2K3 RTM without SP1

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

Reporting Services required features

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

Display the MDX query of an Excel 2007 PivotTable

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

Microsoft Business Intelligence Conference 2007 website live

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

Format String on linked measure groups

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

Improve measures display in SSAS 2005

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