http://www.sqlservercentral.com/Content tagged Analysis Services, MDX posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.http://www.sqlservercentral.com/redirect/articles/63526/2008/07/11http://www.sqlservercentral.com/redirect/articles/63526/This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.http://www.sqlservercentral.com/redirect/articles/62567/2008/05/02http://www.sqlservercentral.com/redirect/articles/62567/Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.http://www.sqlservercentral.com/redirect/articles/62767/2008/04/18http://www.sqlservercentral.com/redirect/articles/62767/SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.http://www.sqlservercentral.com/articles/MDX/61825/2008/02/20http://www.sqlservercentral.com/articles/MDX/61825/Learn how to use an Analysis Services cube as a data source by using parameterized MDX queries, as well as how to localize label strings in a report, in SQL Server 2005.http://www.sqlservercentral.com/redirect/articles/61742/2008/01/07http://www.sqlservercentral.com/redirect/articles/61742/Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples.http://www.sqlservercentral.com/redirect/articles/61729/2008/01/04http://www.sqlservercentral.com/redirect/articles/61729/