Microsoft Analysis Services 2005

Technical articles, whitepapers Overview of Business Intelligence and Data Warehousing in SQL Server Yukon http://www.microsoft.com/technet/prodtechnol/sql/yukon/evaluate/dwsqlsy.mspx Overview of the Analysis Services Development and Management Environments http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/IMDXSMSS05.asp Analysis Services 2000 vs. 2005 - by Jaimie Basilico and Mark Frawley http://www.nysia.org/events/past/2004/2004129dbprof.pdf Migrating from Microsoft SQL Server 2000 Analysis Services to SQL Server 2005 Beta 2 Analysis Services http://www.microsoft.com/technet/prodtechnol/sql/2005/mmsqls2.mspx Analysis Services Comparison: SQL 2000 vs. SQL 2005 http://www.devx.com/dbzone/Article/21539 An Introduction to OLAP in SQL Server 2005 http://www.devx.com/dbzone/Article/21410 Real-time Business Intelligence Using Analysis Services - by Paul Sanders http://www.microsoft.com/technet/prodtechnol/sql/2005/rtbissas.mspx Data Marts and Localizing the Analytics Experience - by Craig Utley http://www.microsoft.com/technet/prodtechnol/sql/2005/solvngbp.mspx Richard Tkachuk's site http://www.sqlserveranalysisservices.com ADOMD.NET source code for querying KPIs in Ananlysis Services 2005 in ASP.NET http://www.mosha.com/msolap/articles/kpiquerying.htm Enabling Drillthrough in Analysis Services 2005 - by TK Anand - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_anservdrill.asp Analysis Services 2005 protocol - XMLA over TCP/IP - by Mosha Pasumansky - http://www.mosha.com/msolap/articles/as2005_protocol.htm UDM Introduction to the Unified Dimensional Model (UDM) - by Paul Sanders http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/IntrotoUDM.asp "UDM - the best of both worlds" - by Paul Sanders http://www.winnetmag.com/Article/ArticleID/41240/41240.html The UDM End-User Mode - by Paul Sanders http://www.winnetmag.com/SQLServer/Article/ArticleID/41241/SQLServer_41241.html MDX 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 Changes in Yukon MDX Part I - by Rob Zare and Mosha Pasumansky http://www.mosha.com/msolap/ppt/Yukon_MDX_I.zip Default members, MDX Scripts, Security, KPIs and Perspectives - by Mosha Pasumansky http://www.mosha.com/msolap/articles/cubeinit.htm Performance of multiplication in MDX - by Mosha Pasumansky http://www.mosha.com/msolap/articles/multiplication_perf.htm Loading Aggregate Data http://www.sqlserveranalysisservices.com/OLAPPapers/Loading%20Aggregate%20Data%20in%20AS2005v2.htm Inventory Management http://www.sqlserveranalysisservices.com/OLAPPapers/InventoryManagement%20in%20AS2005v2.htm Cell Annotations http://www.sqlserveranalysisservices.com/OLAPPapers/Cell%20Annotations%20in%20AS2005v1.htm MDX Missing Members Mode in AS2005 - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxmissingmembersmode.htm MDX Functions in AS2005 - By Mosha Pasumansky http://www.mosha.com/msolap/articles/mdxfunctionsas2005.htm Blogs Mosha Pasumansky (mine) blog about AS2005 http://sqljunkies.com/WebLog/mosha Chris Webb blog about MDX http://spaces.msn.com/members/cwebbbi/ Reed Jacobsen blog about Yukon BI http://sqljunkies.com/WebLog/hitachiconsulting/ Marco Russo blog about Yukon BI http://sqljunkies.com/WebLog/sqlbi

Last updated: 12/03/07.