February 2008
It's not uncommon for MDX programmers to create an elegant calculated member, only to discover that it's so slow that it can't be used in queries against a full data set. Learn why performance problems can occur and ways to work around those problems.
SQL Server Magazine
March 2007
Sometimes you need creative solutions to Reporting Services’ limitations when working with Analysis Services. Here’s a three-part fix that uses in-the-box features to create a solution that resides entirely in the report presentation layer.
SQL Server Magazine
May 2002
April's column showed how to summ the suppressed values in the Product dimension of FoodMart's Sales cube. Here's what the MDX for the Suppressed Unit Sales calculated measure looks like if you add an ALL OTHER BRAND record to each product subcategory.
SQL Server Magazine
April 2002
Learn how to provide analysts with the summarized information they need while hiding confidential details.
SQL Server Magazine
June 2001
You can vary the accuracy of displayed numbers on a cell-by-cell basis by defining multiple calculated cells on the same range of cells. Learn how in this column.
SQL Server Magazine
Add these Headlines to your Website