[转]OLAP相关的软件资源列表

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. ProcessOLAP70 by Greg Steinkuhler - This program is yet another tool to process OLAP Dimensions and Cubes.  Is is the one that is used here at Microsoft ITG.  This utility can be used with the AT command as well.
• ProcessOLAPDb by Michael Yocca - This is a simple utility for processing an OLAP database.  The advantage to using this utility is the fact that it can be launched anywhere including a SQL Job, task scheduler, AT command, DOS batch file etc. -->

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

Code Samples  

• Analysis Services Writeback Sample (Q299797)