Friday, October 30, 2009

Code Samples - Analysis

Extending Excel OLAP Functionalityhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlextendolap.asp
Excel XP Add-ins - Sample code for add-ins in Excel XP by Tom Conlon as shown in TechEd presentations
Writeback sample
Drillthrough sample
Excel VBA driven applet that executes MDX queries and places results on a worksheet - By Tom Chesterhttp://www.tomchester.net/articlesdownloads/excel_mdx_applet.html
Reviews
Nigel Pendse's review in OLAP Reporthttp://www.olapreport.com/products/OLAP_spreadsheets.htm
Microsoft Analysis Services + Full Function Excel Add-Ins. The Perfect Combination - whitepaper by Nigel Pendsehttp://www.misag.com.au/include/news/Analysis%20Services.pdf
John Keeley's reviews
http://www.johnkeeley.com/excel_add-ins_functionality.htm
http://www.johnkeeley.com/excel_add-ins_speed_test.htm
Thin Clients
OLAP Services: Web Browser Samplehttp://www.microsoft.com/downloads/details.aspx?FamilyID=d13da3cd-d84e-45a1-8f12-3bfb326ea53b&DisplayLang=en
Microsoft SQL Server 2000 Resource Kit - Analysis Services Thin Web Client Browser by Richard Tkachuk
WebOLAP by Mosaic Interactive
ThinSlicer and ThinSlicer.NET - by Richard Lees http://easternmining.com.au/Default_files/Downloads.htm
IntraSight http://www.activeinterface.com/intrasight.html
Visual Studio .NET Web Control for Business Intelligencehttp://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en
XMLA Browser by XMLA Consulting Inchttp://www.xmlabrowser.com
ASP.NET controls http://www.eblocks.com
Office
Using Microsoft Office XP as a BI Clienthttp://msdn.microsoft.com/library/default.asp?url=/servers/books/sqlserver/using.asp
Code Walkthrough: Data Drillthrough from the OWC PivotTable Componenthttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnowc/html/odc_pvtdrillthrough.asp
Distributing Enterprise Data via XML with SQL Server 2000 and Excel 2002http://msdn.microsoft.com/library/?url=/library/en-us/dnexcl2k2/html/odc_excelsqlxml.asp
Exploring Microsoft Data Analyzer Programmabilityhttp://msdn.microsoft.com/library/?url=/library/en-us/dnoxpta/html/odc_daprog.asp
Using the Microsoft Data Analyzer ActiveX Control in Web Pageshttp://msdn.microsoft.com/library/?url=/library/en-us/dnoxpta/html/odc_dawebctrl.asp
Max3API Library VBA Code Sample Reference for Microsoft Data Analyzerhttp://msdn.microsoft.com/library/?url=/library/en-us/dnmda/html/odc_daref.asp
MdhInterfacesLib Library VBA Code Sample Reference for Microsoft Data Analyzerhttp://msdn.microsoft.com/library/?url=/library/en-us/dnmda/html/odc_dahierref.asp
MapPoint 2002 OLAP Wizard Add-in - This MapPoint 2002 COM add-in allows you to perform queries on OLAP cube files and create data maps from the query resultshttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/Dnmap02/html/Map_olap.asp
Portfolio Analyzer OLAP Extensionshttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/pjsdk/html/pjsdkCubesOverview_HV01096275.asp
Microsoft Office XP Web Component Toolpack
Conditional Cell Coloring
Drillthrough sample Microsoft Office XP Web Component Toolpack
Actions sample

No comments: