Microsoft OLAP Technical Info (articles, whitepapers etc)

Table of content Whitepapers collections MDX Solving Business Problems with Analysis Services Performance and Scalability Performance Scalability General Programming DSO ADOMD ADOMD.NET Building Web Applications Security Office XML for Analysis Whitepapers on microsoft.com Analysis Services collection http://www.microsoft.com/sql/evaluation/bi/bianalysis.asp Microsoft Analysis Services Operation Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx Integrating Analysis Services with Reporting Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp Analysis Services Whitepaper - This white paper from Datapro Information Services, a subsidiary of Gartner Group, Inc., details the features offered with Analysis Services, provides readers with an overview of PivotTable Service, reveals how Analysis Services and PivotTable Service combine to provide client access to data, and gives users an analysis of how these tools stack up against the competition. http://www.microsoft.com/sql/evaluation/compare/analysisservicesWP.asp Solving Business Problems with Analysis Services OLAP and GIS - Analysis Services and MapPoint - by Mosha Pasumansky http://www.mosha.com/msolap/articles/mapinfo.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 Performance and Scalability Performance Microsoft SQL Server 2000 Analysis Services Performance Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx Series of articles by Bill Pearson about optimizations in Analysys Services http://www.sql-server-performance.com/bill_pearson.asp Inside OLAP Engine: Cache prefetching http://www.mosha.com/msolap/articles/cache_prefetching.htm Using Partitions in a Microsoft SQL Server 2000 Data Warehouse http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/partitionsindw.asp Optimizing Cube Performance Using Microsoft SQL Server 2000 Analysis Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapunisys.asp Cube Partitioning Tests - by Herts Chen http://www.winnetmag.com/SQLServer/Article/ArticleID/41231/SQLServer_41231.html Improving Analysis Services Query Performance http://www.winnetmag.com/SQLServer/Article/ArticleID/41230/SQLServer_41230.html Handling Large databases with MS OLAP tools http://www.claritycon.com/our_activities/publications_detail/9-23-2000.htm 23 Business Intelligence Tips http://www.winnetmag.com/SQLServer/Article/ArticleID/41531/SQLServer_41531.html OLAP Performance http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7638 OLAP Services: Performance Implications of the Architecture http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/dnolap/html/olapperf.asp Optimizing Cell Writeback in Microsoft SQL Server 2000 Analysis Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_CellWriteback.asp Optimizing Cube Performance with OLAP Services http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9140 Optimizing your cube schema http://www.sqlservercentral.com/columnists/dchurch/optimizingyourcubesschema.asp OLAP Distinct Counts and Performance Analysis http://msdn.microsoft.com/SQL/sqlwarehouse/AnalysisServices/default.aspx?pull=/library/en-us/dnsql2k/html/sql_olapdistinctcount.asp Tips for Optimizing SQL Server OLAP/Analysis Services/Data Warehouse Performance http://www.sql-server-performance.com/olap_performance.asp Performance of BI Systems Built with Microsoft SQL Server Accelerator for Business Intelligence http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ssabiper.mspx Using Microsoft Analysis Services 2000, SQL Server Accelerator for Business Intelligence schema, and Unisys ES7000 Server http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_olapdistinctcount.asp Scalability Creating Large-Scale, Highly Available OLAP Sites http://www.microsoft.com/sql/evaluation/BI/CreatingOLAPsites.asp Performance Tuning Analysis Services - SQL Server 2000 Resource Kit http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2661.mspx Microsoft SQL Server 2000 (64-bit) Analysis Services: Why Migrate, and What to Expect If You Do http://www.microsoft.com/technet/prodtechnol/sql/2000/evaluate/ansvcs64.mspx The Advantages of 64-bit to SQL Server 2000 Enterprise Edition Business Intelligence Customers http://www.microsoft.com/technet/prodtechnol/sql/2000/evaluate/64btdwc4.mspx How to build cluster on Analysis Services 2000 http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q308023 T3 Project - Enterprise Scale Business Intelligence http://www.microsoft.com/sql/evaluation/BI/terabytecube.asp Terabyte Data Warehouse on the Microsoft SQL Server 2000 platform http://www.systemonline.cz/site/data-warehousing/terabyte-e.htm Connection Pooling with Microsoft SQL Server 2000 Analysis Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_connpooling.asp Microsoft Demonstrates Performance and Value Advantages of SQL Server 7.0 Enterprise Edition for Terabyte-Scale Business Problems http://www.microsoft.com/PressPass/press/1999/Mar99/SQLEntpr.asp General Microsoft Analysis Services Operation Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx Introduction to Analysis Services - by William Pearson (series of articles) http://www.databasejournal.com/article.php/1459531/ Analysis Services 2000 Internals - PPT by Tom Conlon, Sasha Berger and Mosha Pasumansky http://www.only4gurus.com/v3/download.asp?ID=107 Cubes in Real World - SQL Server 2000 Resource Kit http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2261.mspx Best practices for Business Intelligence using the Microsoft Data Warehousing Framework http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_analservbp.asp Choosing Dimension Types in SQL Server 2000 Analysis Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/dimmsdn.asp Improved Web connectivity in Analysis Services 2000 SP3 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.asp Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework http://msdn.microsoft.com/SQL/default.aspx?pull=/library/en-us/dnsql2k/html/sql_analservbp.asp The reality of Real Time OLAP http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_analservbp.asp Data Warehouse design considerations http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_dwdesign.asp SQL Server 2000 Analysis Services Compared with Hyperion Essbase 6.5 http://www.microsoft.com/sql/evaluation/compare/hyperion.asp Registry Entries for Microsoft Analysis Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_anservregsettings.asp Articles in SQL Magazine about Analysis Services http://www.sqlmag.com/Articles/Index.cfm?DepartmentID=737 A deeper look at Drillthrough - By Russ Whitney for SQL Magazine http://www.sqlmag.com/Articles/Index.cfm?ArticleID=40382 Using Microsoft Analysis Services 2000, SQL Server Accelerator for Business Intelligence schema http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_olapdistinctcount.asp Using Microsoft Analysis Services with IBM databases http://www.microsoft.com/sql/evaluation/compare/ibm/UsingMSSS-ASwIBM-DBs.pdf Understanding the OLAP Services Query Log http://www.mosha.com/msolap/articles/querylog.htm Analysis Services Drill-Through [sqlmag.com] Analysis Services Actions [sqlmag.com] Microsoft SQL Server 2000 as a Dimensionally Friendly System http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/kimballcriteria.asp Designing Reports with the Microsoft® Excel Add-in for SQL Server Analysis Services http://www.microsoft.no/portfolio/pptdownload/Partners/Whitepapers/ExcelAddInWP_Final.doc Programming Programming Analysis Services Applications http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/printro_5vqr.asp How to implement Analysis Services's drillthrough and actions for Web applications - by Dan Fox http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/olapfordevelopers.asp Using Data Definition Language with SQL Server 2000 Analysis Services Client Applications http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anserddl.mspx Writing back Time http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/writingbacktime.asp DSO Programming OLAP Databases from Microsoft Access Using DSO http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_AccessDSO.asp Developing Effective Decision Support Objects (DSO) Solutions with Microsoft SQL Server 2000 Analysis Services http://msdn.microsoft.com/library/default.asp?URL=/library/techart/dsosql.htm Collaboration through DSO - by Russ Whitney http://www.winnetmag.com/SQLServer/Article/ArticleID/38905/SQLServer_38905.html ADOMD Manipulate and Query OLAP Data Using ADOMD and MDX Part 1 http://www.microsoft.com/msj/0899/mdx/mdx.aspx Manipulate and Query OLAP Data Using ADOMD and MDX Part 2 http://www.microsoft.com/msj/0999/mdx/mdx.aspx Put OLAP and ADO MD to Work http://www.only4gurus.com/v2/preview.asp?ID=2837 USING MDX and ADOMD to Access Microsoft OLAP Data Introduction http://www.topxml.com/conference/wrox/2000_vegas/text/sakhr_olap.pdf Implementing OLAP in Delphi applications http://www.olap.ru/desc/microsoft/odelphi.asp Accessing OLAP using ASP.NET http://www.aspfree.com/c/a/MS-SQL-Server/Accessing-OLAP-using-ASP-dot-NET/ ADOMD.NET ADOMD.NET Samples http://www.microsoft.com/downloads/details.aspx?FamilyID=790d631b-bff9-4f4a-b648-e9209e6ac8ad&DisplayLang=en Developing client applications with ADOMD.NET http://www.only4gurus.com/v2/download.asp?ID=3265 ASP.NET CellSetGrid control using ADOMD.NET by Richard Tkachuk http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm Building Web applications Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx Accessing SQL Server 2000 Data Warehouses over the Web http://www.osborne.com/database_erp/0072126191/0072126191_ch07.pdf ASP.NET as client for Business Intelligence http://www.businessintelligence.com/ex/asp/code.52/xe/article.htm Connection Pooling with Microsoft SQL Server 2000 Analysis Services http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_connpooling.asp Middle-tier applications and Analysis Services - WebCast by Microsoft Support http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fen%2Ftranscripts%2Fwctd120503.asp Thin OLAP by Chris Harrington http://www.activeinterface.com/thinolap/thinolap.asp XML for Analysis XML for Analysis council web site http://www.xmla.org Implementing XML for Analysis SDK 1.1 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/implementxap.asp XML for Analysis SDK 1.1 http://www.microsoft.com/downloads/details.aspx?FamilyId=7564A3FD-4729-4B09-9EE7-5E71140186EE&displaylang=en WSDL(s) for XML/A The case for XML for Analysis http://www.digitalaspects.com/The%20case%20for%20XML%20for%20Analysis.pdf OLEDB driver for XMLA - enables XMLA support in OLEDB for OLAP compliant applications http://www.digitalaspects.com/xmlatoodbo.php XMLA performance whitepaper http://www.intellimerce.com/ftp/papers/How%20to%20Squish%20them%20XMLA%20Streams.pdf Web-enable Your Business Intelligence Using XML/A and ASP.NET http://www.devx.com/xml/Article/15491/0/page/1 Thin OLAP by Chris Harrington http://www.activeinterface.com/thinolap.html XML for Analysis specification 1.0 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxmlspec/html/xmlanalysis.asp Visual Studio® .NET Web Control for Business Intelligence http://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en Visual Studio® .NET Web Control for Business Intelligence (Japanese version) http://www.microsoft.com/japan/solutions/bi/techinfo/bicontrol/

Last updated: 06/27/08.