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

If you use SQL Prompt v3 and/or SQL Refactor like me (they are very useful), you will appreciate this hint on how to correctly enable SQL Server Management Studio add-in menus on a non-admin user account. You have to run this command within each non-admin  Read more

I just read this updated paper on MDX performance hints. The section Calculation Non Empty Behavior is very interesting because it clarified me some doubt I had using the Non Empty Behavior property for a measure. The lesson I learnt is that it is better  Read more

I recently noted a behavior of named sets (specifically, the resolution order) that can be not so intuitive. When you define a named set on the cube, it has the same behavior of a session-scoped named set (the one you create with CREATE SESSION SET statement  Read more