http://www.sqlmag.com/authors/author/author/5777661/rss/5777661en-USFri, 25 May 2012 08:57:17 GMTFri, 25 May 2012 08:57:17 GMThttp://www.sqlmag.com/article/quering/create-calculated-members-that-are-elegant-and-perform-wellIt’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.]]>Paul GoldyFri, 25 Jan 2008 00:00:00 GMThttp://www.sqlmag.com/article/quering/create-calculated-members-that-are-elegant-and-perform-wellhttp://www.sqlmag.com/article/reporting2/following-the-rules-with-reporting-servicesSometimes 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.]]>Paul GoldyFri, 23 Feb 2007 00:00:00 GMThttp://www.sqlmag.com/article/reporting2/following-the-rules-with-reporting-serviceshttp://www.sqlmag.com/article/quering/april-2002-mdx-puzzle-solution-revealedApril’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.]]>Paul GoldyWed, 24 Apr 2002 00:00:00 GMThttp://www.sqlmag.com/article/quering/april-2002-mdx-puzzle-solution-revealedhttp://www.sqlmag.com/article/database-development/the-non-visible-levelLearn how to provide analysts with the summarized information they need while hiding confidential details.]]>Paul GoldyWed, 27 Mar 2002 00:00:00 GMThttp://www.sqlmag.com/article/database-development/the-non-visible-levelhttp://www.sqlmag.com/article/microsoft-management-console-mmc/scaling-and-decimal-accuracyYou 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.]]>Paul GoldyWed, 23 May 2001 00:00:00 GMThttp://www.sqlmag.com/article/microsoft-management-console-mmc/scaling-and-decimal-accuracy