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

There is a new paper on project REAL available: this one cover the hardware class tuning for an Analysis Services database of hundreds of Gb. My first impression is good: it is useful to have a reference for benchmark analysis.  Read more

I just posted this bug on connect.microsoft.com – there is an issue when you use unary operator in a parent-child dimension combined with a many-to-many relationship. The problem is that the ‘+’ operator on non-leaf nodes seems to not consider the children  Read more

Two days ago I did the 70-445 exam in beta (TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance). I cannot talk about the exam content, but I think I can talk about the exam in general. As usual, an exam allows you to  Read more