Sometimes there is a simple way to solve an issue. For example, if you want to color all measures (including calculated measures) in red when the value is negative, you can simply write: SCOPE( Measures.AllMembers ); FORE_COLOR(THIS) = IIF( Measures.CurrentMember…  Read more

I fixed an issue of the DateTool dimension I presented in a previous post. The DateTool was unusable on OWC 11, which is the component used by BI Dev Studio and SQL Server Management Studio to browse a cube. I…  Read more

Thanks to a comment sent by a reader of my M2M paper, I just found a possible bug (or “not supported by design feature”) of the CREATE LOCAL CUBE mdx statement. In short, it seems that a simple many-to-many dimension…  Read more

We (I found the issue, Chris created the repro) detected a possible bug using DirectSlice and MeasureExpression.We just posted it here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=455732 The issue could be very dangerous resulting in wrong query results on cells affected by DirectSlice property and MeasureExpression,…  Read more

UPDATE: This blog post is still good for learning DAX principles, but a better description of many-to-many patterns is available on The Many-to-Many Revolution whitepaper that is available here: http://www.sqlbi.com/articles/many2many/ – please download it and use the pattern described there to…  Read more

As you might already know, I and Alberto Ferrari are writing a book about PowerPivot 2010 for Excel. The official title is Microsoft PowerPivot for Excel 2010: Give Your Data Meaning and you can already order it on Amazon! However,…  Read more

Last week I’ve been at Microsoft BI Conference and I presented an interactive session about PowerPivot DAX Patterns. Unfortunately only the breakout session were recorded and available on TechEd Online. The room was full and there were probably many other…  Read more

I will be a speaker at PASS Summit 2010 (November 8-11, 2010 – Seattle, WA) and sessions have been published yesterday. I am currently writing the last chapter of the book about PowerPivot that will be available in September, so…  Read more

After the successful first edition in Amsterdam of the PowerPivot Workshop in December, we are planning to repeat this 2-day intensive course on PowerPivot in several other European countries (we are also evaluating one or two possible dates in US…  Read more

The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and…  Read more