MDX

MDX MDX Essentials - by William Pearson (series of articles) http://www.databasejournal.com/article.php/1459531/ MDX in Analysis Services Series of Tutorials - by William Pearson (series of articles) http://www.databasejournal.com/article.php/1459531/ MDX for Everyone - by Mosha Pasumansky http://www.mosha.com/msolap/articles/MDXForEveryone.htm Writing multiselect friendly MDX calculations - by Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxmultiselectcalcs.htm Using Linear Regressions MDX functions for forecasting - by Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxlinreg.htm Performance of aggregating data from lower levels in MDX - by Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxperformanceofaggregation.htm Recursion in MDX - How deep can it go - by Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxdepthofrecursion.htm Changes in Yukon MDX Part I - by Rob Zare and Mosha Pasumansky http://www.mosha.com/msolap/ppt/Yukon_MDX_I.zip Loading Aggregate Data in AS2005 - by Richard Tkachuk http://www.sqlserveranalysisservices.com/OLAPPapers/Loading%20Aggregate%20Data%20in%20AS2005v2.htm Inventory Management in AS2005 - by Richard Tkachuk http://www.sqlserveranalysisservices.com/OLAPPapers/InventoryManagement%20in%20AS2005v2.htm Cell Annotations in AS2005 - by Richard Tkachuk and Mosha Pasumansky http://www.sqlserveranalysisservices.com/OLAPPapers/Cell%20Annotations%20in%20AS2005v1.htm Business case solutions using MDX - SQL Server 2000 Resource Kit http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2361.mspx Introduction to MDX Scripting in Microsoft SQL Server 2005 Beta 2 http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/IMDXSMSS05.asp Comparing members in MDX - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxcomparingmembers.htm Comparing levels in MDX and CONDITIONs vs. SCOPEs in cell calculations - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxcomparinglevels.htm Converting string to number in MDX or StrToValue vs. Val - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxconvertstringtonumber.htm MDX Missing Members Mode in AS2005 - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxmissingmembersmode.htm TechNet Support WebCast: Common MDX mistakes and solutions in Microsoft SQL Server 2000 Analysis Services - http://support.microsoft.com/default.aspx?kbid=886991 MDX praclets by BI Practices team http://blogs.msdn.com/bi_systems/category/4401.aspx Rock solid MDX - by Russ Whitney http://www.sqlmag.com/Articles/Index.cfm?ArticleID=38005 MDX by example - by Russ Whitney http://www.winnetmag.com/SQLServer/Article/ArticleID/22994/SQLServer_22994.html MDX in Analysis Services Series (Database Journal) http://www.databasejournal.com/news/article.php/1550061 Introduction to MDX http://www.sqlservercentral.com/columnists/khenry/introductiontomdx.asp Member properties Boot Camp - by Russ Whitney for SQL Magazine http://www.sqlmag.com/Articles/Index.cfm?ArticleID=39384 Using Member Properties - by Tom Chester http://www.tomchester.net/articlesdownloads/salesper.html Understanding Analysis Services Calculated Cells - by Tom Chester http://www.tomchester.net/articlesdownloads/passnews/calculatedcells.html Programming OLAP with MDX - By Mark Whitehorn http://www.appdevadvisor.co.uk/Readers/Columns/Main.htm Minimize uncertainty with OLAP - by Eugene Asahara (mostly about writeback) http://businessintelligenceadvisor.com/doc/06882 Indispensable Calculated Members [sqlmag.com] Diving into MDX Queries [sqlmag.com] Getting to Know OLAP and MDX [sqlmag.com] The Power of Calculated Cells [sqlmag.com] MDX Functions What are the most popular MDX Functions - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxpopularfunctions.htm MDX Functions in AS2005 - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxfunctionsas2005.htm CrossJoin and NonEmptyCrossJoin - By Russ Whitney in the SQL Magazine http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26100 Solving Business Problems with Analysis Services Cell Annotations http://www.sqlserveranalysisservices.com/OLAPPapers/Cell%20Annotations%20in%20AS2005v1.htm Semiadditive Measures and Inventory Snapshots - by Amir Netz http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/semiadd2.asp Business case solutions using MDX - SQL Server 2000 Resource Kit http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2361.mspx Solving Nonleaf Data Problems - by Brian Altmann http://www.geocities.com/brianaltmann/mdxtopic-nonleaf.html Filling out revised forecasts with calculated cells - by Brian Altmann http://www.geocities.com/brianaltmann/mdxtopic-forecast.html Getting Time right in Analysis Services - by Tom Chester for SQL Junkies Web site http://www.sqljunkies.com/Article/D1E44392-592C-40DB-B80D-F20D60951395.scuk About Time - by Brian Altmann http://www.geocities.com/brianaltmann/olaptopic-time.html Financial Reporting with Analysis Services - by Yoram Levin http://www.winnetmag.com/SQLServer/Article/ArticleID/41783/SQLServer_41783.html The art of Cube Design to build better forecasting cubes - by Russ Whitney http://www.winnetmag.com/SQLServer/Article/ArticleID/41215/SQLServer_41215.html Analyzing Money - by Russ Whitney http://www.winnetmag.com/SQLServer/Article/ArticleID/38905/SQLServer_38905.html DISTINCT COUNT, Basket Analysis, and Solving the Multiple Selection of Members Problem http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/distinct2.asp Importing and Analyzing Event Log http://www.sqlservercentral.com/columnists/gciubuc/importingandanalyzingeventlogs.asp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Last updated: 12/03/07.