Archive for July, 2011

Analysis Services: What are the best practices for grouping measures ?

You’ll find in the following post some general considerations to have in mind when designing cubes about how to dispatch indicators into groups to suite the end-user needs and the consequences of these choices.

Lately, a colleague of mine at Avanade was embarrassed because his customer wanted to visually group and mix heterogeneous kind of indicators into same folders so that he’ll later find them easily into his pivot table into Excel.

As a good practices follower he designed his data warehouse and cube by respecting multidimensional modeling, commonly approved, best practices and putted all the measures that share the same grain into a single fact table and into the same measure group…. which, as he discovered it later, is not necessarily the organization that the end-user have in mind for his data when it comes to build analysis reports.

My colleague first thought was to rely on the “display folder” and “associated measure group” properties to fill the end-user need. The drawback is that what is defined in a measure group stays in the measure group and a fact table cannot lead to more than one measure group.

So as it comes that he was unable to easily answer the requirements, he asked me for advises on how to handle the situation. Here is what we can say…

Read the rest of this entry »

Advertisements

Comments (2)

Hello world! (How original)

First, welcome to this blog.

My intention here is to blog on anything related to Microsoft SQL Server, from a BI point of view, that I think may be of some interest for anyone out there.

But let me first introduce myself. During the ten past years I’ve worked with all versions of SQL Server starting with SQL Server 6.5. I have an extensive experience on data warehousing and multidimensional modeling. Along the years I’ve worked on a lot of projects for diverse customers in several functional fields from oil and gas to luxury, retail or manufacturing.

As of now, I’m working for Avanade, a joint-venture between Microsoft and Accenture. Avanade is a great company to work for and has been recognized several time as a top employer (just go the website if you want to learn more) and Microsoft partner of the year. I Hold here a Senior Manager and BI Solution Architect role.

To get back to this blog, I’ll cover here SQL Server news as they are announced by Microsoft … and SQL Server Codename Denali CTP3 should be out very soon and made public, allowing me to discuss here a lot of information that are actually under NDA 🙂

I’ll also cover some technical details of a data warehouse implementation as my customers are always keen to push our skills and MS products to their ultimate limit!

So here we go …

Leave a Comment

« Newer Posts