Free olap software for windows

Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Service Pack 3 With OLAP Services (Intel) 1.0 provides you a powerful tool that addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 since their ship date. Because SQL Server Service Packs are cumulative, SP3 includes all fixes from previously released Service Packs, and can be applied to an original installation or to one where Service Pack 1 (SP1) or Service Pack 2 (SP2) was previously applied. SP3, for SQL Server 7.0 and MSDE 1.0, is in two parts to reduce the size of downloads: Database Components and OLAP Services Components.

Requirements:

• Windows NT for Intel,
• Microsoft SQL Server 7.0 and/or Microsoft Database Edition (MSDE) 1.0

SparkMaker is an add-in for Microsoft Office that allows you create your own sparklines in Word, Excel, PowerPoint, or HTML docs SparkMaker is an add-in for Microsoft Office that allows you create your own sparklines in Word, Excel, PowerPoint, or HTML documents.
New dialog
Version 4 of SparkMaker is based on a completely new creation process for
sparklines: a single dialog is provided which minimizes click activity. All
variants of sparklines are designed with this dialog, either as sparkline
formulae in Excel or as static sparklines in any Office document (Word,
PowerPoint, Excel). The result of our redesign is a dialog 60% smaller than
before which ensures 60% more focus on the essential process of creating
information dense data representations with sparklines.
Improved preview function
Usability in SparkMaker 4 is further increased through a new preview field
which is now available for sparkline functions, too. While you define any
type of sparkline, you will see - at all times - an exact representation of
your forthcoming sparkline based on current settings.
Tickering sparklines
For those who want to go beyond static displays of sparklines, SparkMaker
offers a built-in ticker feature: it exports selected sparklines to an HTML
ticker which users can easily integrate into Intranets or other web publications. This feature can help raising awareness for your data.
Information in a sparklined ticker is distributed in a non-intrusive way
using only a small portion of the current screen real estate. For more
details see http://www.bissantz.com/sparkmaker/ticker_en.asp.
Office 2007 support
SparkMaker 4 seamlessly integrates into heterogeneous IT business
environments, since it supports all currently relevant Office versions:
Office XP, Office 2003 and the brand-new Office 2007 suite.
Improved Performance
Technical efficiency for reporting has been improved with new algorithms
that provide faster calculation of multiple sparklines in Excel sheets and
avoid unnecessary recalculations.
SparkMaker for Excel-based OLAP front-ends
You are using an OLAP database to conveniently store your data instead of
creating numberless Excel sheets? Or you employ a data warehouse based on
OLAP technology to realize analyses of your business data? In case you are
using an Excel front-end to access your OLAP database, you should use
SparkMaker to enhance reports and analyses which you create from your OLAP database. All sparkline functions can read data from cells which display
data from your OLAP database. For more information on supported OLAP
databases check here.
Main features:
- Supports various sparkline types: bars, lines, winner/loser (whiskers), pies
- Creates sparklines directly in your Excel, Word, and PowerPoint documents
- Generates sparklines either textually using TrueType Fonts or as vector-based images (Enhanced Metafile Format)
- User-defined functions for dynamic sparkline updates in Excel XP, 2003 and 2007
- Flexible scaling of sparklines
- Additional statistical information: standard deviation, trend
- Multiple formatting options, like color and landmark values
- New: now also available in sparkline functions
- Allows for high quality print-outs
- Exports to popular bitmap image file formats: BMP, GIF, JPG, PNG, TIFF
- Supports Microsoft Office 2000, Office XP, Office 2003 and Office 2007
System requirements:
- Microsoft .NET Framework 2.0
Version restrictions:
- 30-day trial
- The remaining functionality of an expired trial version of SparkMaker 4 constitutes the Free edition of SparkMaker: it is free of charge for private, academic and commercial purposes.

Dataset Report Express Edition 2009 is known as a useful reporting tool of the Business Intelligence Suite Dataset Report Entreprise Edition, which is limited to SQL Server. Dataset Report Entreprise Edition can access SQL Server, Oracle, DB2, AS400, Excel and ODBC.

The reports, cubes and queries generated with the Express Edition can be used through the web with the Entreprise Edition. Dataset Report Express Edition exploits your enterprise data by producing reports in PDF, HTML format and office automation documents.

Major Features:

1. Key Points
   • Exploits your enterprise data by producing reports (in PDF and HTML format), web pages and office automation documents.
   • Creates dynamic cross-tables (note that an OLAP engine is included).
   • Customizes your reports, enabling you to add your enterprise's look and feel, insert pictures, graphs and cross-tables.
   • Circulates business information both internally and externally.
   • Accesses information via your computer, mobile phone or PA.
   • Generates applications from your business intelligence information.
2. Key Benefits
   • Fully integrates with the Internet for Online Reporting.
   • Easily integrates with the major Office applications on the market.
   • Brings you easy access to data sources.
   • Facilitates the distribution and sharing of your enterprise documents.
   • Provides you with a flexible tool to enable you to query all your data.
   • Automates Scheduled Tasks.
   • Generates real-time cubes - multi-dimensional data views to enable you to interactively examine the results in various dimensions of the data.