Software Products to work with Analysis Services

Table of content Microsoft software Standalone OLAP Clients Excel Add-Ins Thin clients Office Processing Metadata scripters Local Cubes Management Documentation Collections Applications which use MS OLAP Other Microsoft software Products Microsoft Analysis Services http://www.microsoft.com/sql/evaluation/bi/bianalysis.asp Microsoft Excel PivotTables http://www.microsoft.com/excel Microsoft Office Web Components (OWC) http://www.microsoft.com/downloads/details.aspx?familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en Microsoft Office Excel Add-in for SQL Server Analysis Services http://www.microsoft.com/office/solutions/accelerators/exceladdin/default.mspx Microsoft Data Analyzer http://www.microsoft.com/office/dataanalyzer/default.asp Microsoft Office Business Scorecard Manager http://office.microsoft.com/en-us/FX012225041033.aspx Microsoft SQL Server Reporting Services http://www.microsoft.com/sql/reporting/default.asp SQL Server Accelerator for Business Intelligence http://www.microsoft.com/sql/ssabi/ Microsoft Business Intelligence Portal by Tomer Ben-Moshe http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnowc/html/odc_bip.asp Visual Studio .NET Web Control for Business Intelligence http://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en Microsoft XML for Analysis SDK http://www.microsoft.com/downloads/details.aspx?FamilyId=7564A3FD-4729-4B09-9EE7-5E71140186EE&displaylang=en ADOMD.NET http://www.microsoft.com/downloads/details.aspx?FamilyID=790D631B-BFF9-4F4A-B648-E9209E6AC8AD&displaylang=en Business Scorecards Accelerator http://www.microsoft.com/downloads/details.aspx?FamilyID=3c4a9762-646b-41bd-9d42-5765b262624b&DisplayLang=en OLAP Manager Add-In Kit http://www.microsoft.com/sql/downloads/OLAPaddin.asp DSO/XML conversion utility http://www.microsoft.com/downloads/details.aspx?FamilyID=10744518-a2be-4534-8092-6be753fcc7bf&DisplayLang=en OLAPScribe - A utility for documenting Analysis Services database http://www.microsoft.com/downloads/details.aspx?FamilyID=D763175B-4022-429F-A9D5-DFE00E8545BD&DisplayLang=en Analysis Services Parallel Processing Utility (PPU) v3 by Dave Wickert. http://www.microsoft.com/downloads/details.aspx?FamilyId=A2EEF773-6DF7-4688-8211-E02CF13CBDB4&displaylang=en Code Samples ASP.NET CellSetGrid control using ADOMD.NET by Richard Tkachuk http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm OLAP Services: Web Browser Sample http://www.microsoft.com/downloads/details.aspx?FamilyID=d13da3cd-d84e-45a1-8f12-3bfb326ea53b&DisplayLang=en SQL Server 2005 Business Intelligence Metadata Samples Toolkit http://www.microsoft.com/downloads/details.aspx?FamilyID=11DAA4D1-196D-4F2A-B18F-891579C364F4&displaylang=en Updated Samples for SQL Server 2000 Service Pack 3 http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=7824ba50-3e29-45cf-8c02-5597c014a707 Reporting Services 2000 - OLAP Sample Report http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&displaylang=en Demos and Templates for SQL Server Accelerator for BI (manufacturing vertical kit, financial services vertical kit) http://www.microsoft.com/sql/ssabi/techinfo/datamodels.asp Whitepapers & Reviews Designing Reports with the Microsoft® Excel Add-in for SQL Server Analysis Services http://www.microsoft.no/portfolio/pptdownload/Partners/Whitepapers/ExcelAddInWP_Final.doc Office Business Scorecards Accelerator – the ultimate marriage of business and intellgence. http://blogs.msdn.com/mat_stephen/archive/2005/02/17/375352.aspx Standalone OLAP Clients Analysis Tools Panorama NovaView BI Platform http://www.panoramasoftware.com Proclarity http://www.proclarity.com TemTec Executive Viewer http://www.temtec.com Cognos PowerPlay - http://www.cognos.com BusinessObjects - http://www.businessobjects.com Crystal Analysis and Reports - http://www.businessobjects.com MIS onVision - http://www.misag.com Arcplan inSight and dynaSight http://www.arcplan.com SoftPro Manager - http://www.softpro.hr SPSS Olap Hub Information Intelligence Platform - http://www.spss.com/olap_hub Targit Analysis - http://www.targit.com Databeacon - http://www.databeacon.com/ Visual Spreadsheet - http://www.tableausoftware.com/ Q4bis - http://www.q4bis.com/ Hummingbird - http://www.hummingbird.com/products/bi/index.html Vista - http://www.beyond2020.com/products/Vista.html DeltaMaster - http://www.bissantz.de/index_e.html Strategy Analyzer - http://www.strategycompanion.com USoft - http://www.u-soft.com.cn BPM applications Geac MPC (former Comshare) http://www.performance.geac.com CIP Executive Suite http://www.cip-software.com OutlookSoft EAP http://www.outlooksoft.com SysPro Business Analytics http://www.syspro.com/Products/Business%20Analytics/ CALUMO - Performance Management http://www.calumo.com Query, Reporting WebAnalyst - http://www.olapwebhouse.com/products-webanalyst.aspx DWExplorer - http://www.dwexplorer.com DataJungle Matrix - http://www.datajungle.com/products_matrix.htm WebFOCUS - http://www.informationbuilders.com/products/webfocus/ Intelligencia - http://www.it-workplace.com/ ZAP.BI Suite - http://www.zaptechnology.com DS Panel - http://www.dspanel.com Cubularity Knowledge Platform - http://www.cubularity.com IQub Browser - http://www.thebitzinc.com PolyVista - http://www.polyvista.com Analyzer Project - http://aproject.hotmail.ru/index.htm XMLABrowser and Report Portal - http://www.reportportal.com OLAP Insider - http://www.peyo-home.sk/olapinsider/index.htm IntelliBrowser - http://www.hungrydogsoftware.com/IntelliBrowser.htm OLAP X - http://www.olapxsoftware.com UniViz Analytics - http://www.unifact.com/ REX - http://sourceforge.net/projects/whex/ Sapience - http://www.sapience-bi.com/bip_deployement.htm Pivot-View - http://www.pivot-view.com/ SwiftView - http://www.swiftknowledge.com/ Controls EBlocks - http://www.eblocks.com ChartFX - http://www.softwarefx.com/extensions/olap SnowflakeNET - http://www.intellimerce.com CellSetGrid (Beta) - http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm Dundas - http://www.dundas.com/products/chart/dundasolap/ Omnsys Power Gauge - http://www.omnisys.co.il/ITSolutions/main.asp?lngCategoryID=1735 Excel Add-Ins Products Microsoft Office Excel Add-in for SQL Server Analysis Services http://www.microsoft.com/office/solutions/accelerators/exceladdin/default.mspx XLCubed http://www.xlcubed.com IntelligentApps http://www.intelligentapps.com MIS Plain http://www.misag.com BIXL http://www.bixl.com QBEX http://www.advanceinfo.com/qbex Visual OLAP http://www.visualolap.com O2OLAP http://www.o2olap.com OLAP NaviGo http://www.olapnavigo.com Panorama NovaView Excel http://www.panoramasoftware.com CALUMO - For Excel http://www.calumo.com Code Samples Extending Excel OLAP Functionality http://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 Chester http://www.tomchester.net/articlesdownloads/excel_mdx_applet.html Reviews Nigel Pendse's review in OLAP Report http://www.olapreport.com/products/OLAP_spreadsheets.htm Microsoft Analysis Services + Full Function Excel Add-Ins. The Perfect Combination - whitepaper by Nigel Pendse http://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 Sample http://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 Intelligence http://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en XMLA Browser by XMLA Consulting Inc http://www.xmlabrowser.com ASP.NET controls http://www.eblocks.com Office Using Microsoft Office XP as a BI Client http://msdn.microsoft.com/library/default.asp?url=/servers/books/sqlserver/using.asp Code Walkthrough: Data Drillthrough from the OWC PivotTable Component http://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 2002 http://msdn.microsoft.com/library/?url=/library/en-us/dnexcl2k2/html/odc_excelsqlxml.asp Exploring Microsoft Data Analyzer Programmability http://msdn.microsoft.com/library/?url=/library/en-us/dnoxpta/html/odc_daprog.asp Using the Microsoft Data Analyzer ActiveX Control in Web Pages http://msdn.microsoft.com/library/?url=/library/en-us/dnoxpta/html/odc_dawebctrl.asp Max3API Library VBA Code Sample Reference for Microsoft Data Analyzer http://msdn.microsoft.com/library/?url=/library/en-us/dnmda/html/odc_daref.asp MdhInterfacesLib Library VBA Code Sample Reference for Microsoft Data Analyzer http://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 results http://msdn.microsoft.com/library/default.asp?url=/library/en-us/Dnmap02/html/Map_olap.asp Portfolio Analyzer OLAP Extensions http://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 Processing Analysis Services Parallel Processing Utility (PPU) v3 by Dave Wickert. This utility allows you to process Analysis Services objects (cubes, partitions and dimensions) in parallel. Complete source (VB6) is included. This updates the version that was shipped with the SQL Server 2000 Resource Kit. http://www.microsoft.com/downloads/details.aspx?FamilyId=A2EEF773-6DF7-4688-8211-E02CF13CBDB4&displaylang=en DSOCtrl by Darren Green - This is small ActiveX DLL which Darren Green has written to help with processing OLAP Cubes & Dimensions. This can be used from VB, ActiveX Script, T-SQL or ASP. Metadata scripters OLAPWebhouse XMLBuilder http://www.olapwebhouse.com/products-xmlbuilder.aspx Microsoft SQL Server 2000 Resource Kit  - Meta Data Scripter The DSO/XML Conversion Utility is designed to convert Decision Support Objects (DSO) metadata and objects to/from XML. The DSO object model is an API for creating/modifying Analysis Services objects and this tool is a mechanism for building XML-based “scripts” based on Analysis Services objects. These scripts form a robust data definition language (DDL) for Analysis Services. http://www.microsoft.com/downloads/details.aspx?FamilyID=10744518-a2be-4534-8092-6be753fcc7bf&DisplayLang=en XML Builder - http:///www.olapwebhouse.com - XML Builder is a fully packaged product that comes with the following features: An MS Analysis Services Wizard to script MS OLAP Structure or create structure from saved scripts A DTS Custom Task to easily deploy and automate the creation or edition of MS OLAP Structures from XML scripts A standalone dll, that you can extend or simply put in your custom developments A command line utility A Retro-documentation utility Local cubes Rubik http://www.solgenia.com/USA/Solutions/Sheets/SheetRubik.htm www.localcubetask.com - The Local Cube Task automates the creation of local cube files. You can create local cubes with different subsets of server cube data. You can create different local cubes for different users. Because it is integrated with DTS, the process of creating up-to-date local cube files becomes a regular part of loading the data mart. You can schedule the creation of local cubes with the Local Cube Task while working with the OLAP Client Manager inside of the Analysis Manager. Management Gestio AppManager for AS - http://www.gestio.org/default.aspx?tabid=90 Documentation OLAPScribe - A utility for documenting Analysis Services database http://www.microsoft.com/downloads/details.aspx?FamilyID=D763175B-4022-429F-A9D5-DFE00E8545BD&DisplayLang=en Cube Documentation Tool - By Tom Chester. Works with Excel 2000 and Excel XP, must enable macros, requires DSO (126k) http://www.tomchester.net/ArticlesDownloads/Doc_Tool.xls Migration from Essbase CubePort - http://www.exologic.com/products.htm Collections Microsoft SQL Server 2000 Resource Kit  Analysis Services Thin Web Client Browser Catalog Explorer Meta Data Scripter WINSIGHT Distinct Count UDF UDF Library XML OLAP meta-data import/export utility Automated generation of *.XLS, *.GIF, *.HTM or *.TXT files based on the results of an MDX query. Microsoft OLAP Solutions Book Web site Partition Explorer 1.1 Security Manager 1.0 Excel Spreadsheet with Write-back v2 Symmetry Corporation Tip #25 - Utility to disable levels of dimensions in a virtual cube Tip #24 - Sets up table-driven cell level security Tip #12 - Converts a hierarchy file in a tree format to a parent-child format Applications Internet Traffic Analyzing System http://www.dataart.com/software-outsourcing/technical-capabilities/products/internet-traffic/default.htm Unsorted/Unclear http://www.greerinfo.com/tools/glreporting.html

Last updated: 01/10/08.