Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release.  In this book you will learn about the entire Microsoft BI stack from a bunch of experts that work with me (Brian Knight, myself, Adam Jorgensen, Patrick LeBlanc, and Mike Davis).… Read more

Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.  The benefits of creating attribute relationships are multifold.  It can reduce storage space, speed up processing time, improve query performance, and allow usage of member properties. 

So how do attribute relationships work?  The simplest… Read more

In this quick post I wanted to provide some code that's been useful to me recently.  This MDX statement creates a named set of the Top 20 products and then aggregates on a selected measure.  Commonly though you may want to return an aggregation on those Top 20 products but… Read more

Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built in.  In this example a named set has been added and the requirement is to bring back the top 10 product sales and display the… Read more

In a previous post I wrote about getting started with PerformancePoint 2010.  In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010.  Your next steps are to configure PerformancePoint which you can find a good guide on TechNet for.  Some of these steps… Read more