Marco Russo's Blog
View full profileDo more with less: the missing feature in Excel Services
A little background: in these days I’m preparing sessions for some upcoming conferences in Italy (despite the English titles, most of the sessions will be in Italian: Microsoft SharePoint & Office Conference 2010 next week and Microsoft SQL Server Read more
Discount offer on Expert Cube Development book
This post is just a commercial – but, you know, when you write a book, there is no conflict of interests in promoting it! If you still don’t have our Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book, you can get 25% off the Read more
And finally the "by design" issue has been fixed.
You know, selecting calculated members in Excel is not an option. I talked about this issue more than three years ago for the first time: http://sqlblog.com/blogs/marco_russo/archive/2007/01/31/excel-2007-pivottable-with-calculated-members.aspx http://sqlblog.com/blogs/marco_russo/archive/2007/03/07/ssas-2005-sp2-breaks-excel-calculated-member-selection.aspx Read more
How to relate tables in DAX without using relationships
UPDATE 2017-07-12: please note this article was written in 2010, there are now better ways to obtain the same result. Please read these articles: Physical and Virtual Relationships in DAX and Propagate filters using TREATAS in DAX PowerPivot supports Read more
Avoiding calculated column in DAX
A calculated column is a DAX expression which is evaluated when the PowerPivot workbook is updated. It is very useful, but there are cases where you want to delay calculation at query time. For example: You want to make part of the calculation depending Read more
Table Denormalization Study in PowerPivot
I recently talked about memory usage in PowerPivot and previously I wrote about difference modeling options using table normalization or not . Thus, I wondered whether table normalization is a good practice for performance and memory or not. The short Read more
SQL Search experience
I started using SQL Search (a free product from RedGate) several weeks ago, while it was still in beta. Now that the product has been released and is freely downloadable, I can say it has being really useful since the first beta. My common need is to Read more
PowerPivot Profiler
Denny Lee described how to open a trace file in PowerPivot for Excel . It is something that is very important because the SSAS engine which runs PowerPivot runs inside the Excel process and doesn’t have an external connection (thus, also SQL Profiler Read more
Memory Considerations about PowerPivot for Excel
PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of Excel. Especially with Read more
ABC Analysis in PowerPivot
The calculation for ABC analysis can be made in PowerPivot using calculated columns. In this way each row can have an attribute with the appropriate ABC class. The ABC calculation has to be made considering a particular grouping and sort order. For example, Read more