Best olap software for free download

RadarCube is a powerful NET Windows Forms OLAP control entirely authored in C# 2.0. Having an excellent performance it allows to work with databases with millions records. RadarCube has a splendid user interface and powerful API designed to create true OLAP applications.

Key features:
- One or several tables/views /stored procedures described in a DataSet object.
- A set of standard aggregation functions like Sum, Count, Distinct Count, Min, Max so on. Custom aggregation functions.
- Hierarchies of three types:
-- Parent-child hierarchies (both balanced and unbalanced);
-- Multilevel hierarchies (both regular and ragged);
-- Mixed from all previous types.
- An ability to create calculated measures, dimensions, hierarchies and hierarchy levels.
- Calculated members of hierarchies.
- Auto conversion of the DateTime fields into multilevel hierarchies. Any conversion algorithms.
- Unicode support.
- Several types of drilling down: to the nearest successor, to the next level, to the next hierarchy.
- Hierarchy members grouping (including multilevel and parent-child hierarchies).
- Separate sorting of different hierarchy levels.
- Ascending or descending sorting based on the column values in the grid.
- Filtering of hierarchy members with or without applying these filters to the OLAP calculations.
- Ability to place pictures into grid cells, and automatically position picture and text within the cell, depending on the parameters defined by a programmer.
- A complete control over the cells contents, ability of custom drawing within the cells.
- Ability to change the context menus in the grid.
- Auto sizing of the cell depending on their contents.
- The IListSource interface implementation which allows OLAP Grid to be used as the data source for the components working with data (for example, Chart or export).
- Allows exporting grid data to MS Excel, BMP, TXT, HTML, JPG, GIF, PDF, and so on.
- An ability to edit OLAP data.

Related software: olap, pivot, windows, forms, business, intelligence, owc, cube, crosstab, windows forms, business intelligence, …

HierCube Library is a set of VCL components designed to create fast, handy, and powerful OLAP-applications in different IDE. The library has its own OLAP-engine made using MOLAP-principle, and allows you making OLAP-views "on the fly", not wasting time and memory for intermediate calculations. Calculations performance doesn't depend on the cube capacity and the depth of hierarchical dimensions. For example, one million records fact table is processed for less than a second. No OLAP server required.
Main features:
- 100% Unicode support
- "Star" or "Snowflake" schemas support
- Hierarchical dimensions of any nesting level, defined with "Parent-Child" relations
- Several flat dimensions grouped into a hierarchical one (composite or multilevel dimension).
- Dimension filters: allows to exclude any members from the current OLAP-view
- Dimension groups: allows to gather any members into a single group during.
- History of OLAP-views: allows "undo", "redo" operations during OLAP-analysis
- Three types of calculated summaries: see data that you really want.
- Different aggregate functions and sub-functions: using different functions to display cube data. Sub-functions display the final result in different ways like displaying % value instead of the function value.
- Supersaturated cubes: no need to group records in the SQL-queries.
- Saving/Restoring: allows to save all cube and/or all OLAP-views in a disk file and restore it back later on.
- Fact table editing: allows to use HierCube library to create cross tabulated tables.
- Displaying current OLAP-slice in a diagram.
- Dimension attributes: displaying additional information given from the dimension table from any member.
- No standard problems of "sparse" multidimensional cubes like "database explosion" or "cube sparsity".
- Vast export functionality: copying to Clipboard, exporting in the most common formats: PDF, RTF, HTML, XLS, CSV, BMP, WMF, and other.
- Easy localization.

Related software: olap, component, engine, grid, application, view, cross, tabulated, table, molap, principle, hiercube, radarsoft, aggregate, server, composite, dimension, multilevel, pivot, olap-component, olap-engine, olap-grid, olap-application, olap-view, cross tabulated table, molap-principle, olap-server, composite dimension, multilevel dimension, …

RadarCube is a fast and powerful ASP.NET OLAP control providing you with a unique chance of supplying the web site with the MS Analysis 2000 or 2005 client abilities. It is entirely authored in C# 2.0 and can be an excellent substitute for the OWC PivotTable control.
The main features are:
- Royalty free!
- 100% managed (C# 2.0), no ActiveX code
- All ASP.NET 2.0 advantages. 100% AJAX
- Supports IE 5.5+, Firefox 1.1+, Opera 9.0+
- Supports the Microsoft Analysis Server 2000, 2005 or local cube files using ADOMD.NET 9.0
- Two working modes: cube browsing and displaying the results of any MDX-queries.
- Ability to create additional calculated measures on the client or server side.
- Supports additional calculated members of hierarchies on the client/server side.
- Web parts support
- Drag-n-drop support (all browsers)
- Time intelligence support
- Fixed columns/rows headers on scrolling the grid (all browsers)
- Ability to simultaneously display a set of measures, named sets and KPIs in the Grid.
- Interactive drill-down support of all types of hierarchies separately for every grid cell.
- Saving and restoring the current OLAP slice.
- Member grouping on any hierarchy level without changing the hierarchy levels structure.
- Separate hierarchy or dimension sorting on any level. Ability of any sorting method overriding.
- Ascending or descending sorting based on any column value in the OLAP grid.
- Supports filtering of any set of hierarchy members with or without applying these filters in the OLAP calculations.
- Auto filtering of the hierarchy members depending on their values in the grid. An ability to select some major/minor members, either according to their rank or on the Pareto principle.
- Custom rendering in any grid cell.
- Custom popup menus in the grid (all browsers).
- Handy integration with charting and other third-party components.
- Flexible export to: BMP, CSV, GIF, HTML, JPEG, PDF, PNG, TIFF, TXT, XLS, XML.

Related software: olap, pivot, pivottable, analysis, asp.net, drilling, hierarchy, pivoting, …

Quella B.I.S. is an easy-to-use tool covering the Business Intelligence Process from Data Extraction to Analysis. As a total solution, Quella extracts transactional data from heterogeneous data sources, consolidates the extracted data and provides necessary business information to decision makers through List Reports, Charts and OLAP-Reports. Information becomes in this way easily available to decision makers throughout the organisation.

Quella is a tool that helps you to maximise the benefits of processing existing data and allows you to easily incorporate new ones. Users do not need to have data warehouse experience nor extensive knowledge in SQL-programming to fully exploit the rich functionality encapsulated in the application. Through a user-friendly interface, extracting, combining and managing data becomes an easy task. Powerful algorithms also make your data manipulation processes more efficient and flexible while build-in reporting capabilities enable you to deliver fully customised information to those who need it.

The entire process from data extraction to report generation can also be fully automated and scheduled so that once a report is implemented, human intervention can be reduced to the minimum.

Furthermore, Quella’s flexible design will ensure that any unexpected change in terms of data sources or informational needs can rapidly be incorporated into existing solutions. Information once delivered to the decision maker can be easily analysed through List Reports, Charts or OLAP-Reports. The latter are particularly powerful tools to interactively summarise, slice and filter data without the need of an OLAP-Server. All the reports are portable and therefore ideal for off-line working forces.

Quella data warehouse, reporting and data analysis package consists of two complementary computer programs:

Quella Creator: ETL-Processing, Data Warehousing, Report Desing and Creation.
Quella Cognitus: Charting, OLAP-Analysis, Spreadsheet Analysis.

Related software: business, intelligence, report, reporting, tool, olap, cube, list, chart, dss, data, analysis, decision, making, multidimensional, etl, extraction, transformation, loading, sql, meta, support, sytem, business intelligence, reporting tool, data analysis, decision making, multidimensional analysis, extraction transformation loading, meta data, decision support sytem, …

One of conditions to achieve success in business is quick data analysis that allows saving money and time. Today many companies use pivot tables which have imperfections such as lack of flexibility and integrity of dataset, intraprocess transparency. Companies should put a question if they are ready to loose competitive ability using inaccurate data or apply progressive technology. For those who are eager to increase the efficiency by applying such a technology Perpetuum Software offers OLAP ModelKit. In addition to common functionality inhered by the existing OLAP components such as accuracy and easiness of data analysis, ability for creating and treating alternative relations etc. OLAP ModelKit has its own particularities. The product is fully compatible with .NET due to 100% managed code. This component has an XP Themed appearance and an ability to use any .NET data sources (including ADO.NET and IList). OLAP ModelKit supports nested data sources. Now there is no need to prepare a special data access meeting the required calculations. This library is intended for creating and utilizing cross reports based on multiple statistical data of large volumes. Moreover, OLAP ModelKit provides an opportunity to represent the final report data not only as a table; it also allows organizing the information so to make it available for use by third party chart components. It should be mentioned such features as comprehensible User Interface. Now end users have an ability of data filtering, drilling down, rolling up, dimensional pivoting, ranking. The product allows embedding OLAP technology in all Windows applications based on relational data. It is possible to export a cross report into an Excel table, HTML or PDF. Please be advised that OLAP ModelKit 3.0 supports only .NET 2.0. If you work with .NET Framework 1.1, please use OLAP ModelKit 2.3 that is compatible with .NET 1.1 and .NET 2.0

Related software: olap, .net, pivot, table, data, cube, analytical, processing, pivot table, data cube, analytical data processing, …

Report Sharp-Shooter is a reporting component that helps you create flexible reports and easily integrate them into your Web and Win apps. It supports a variety of industry-standard export formats including PDF, HTML, Excel, Word, RTF, and more.

An advanced Master Report concept helps to save time while developing a large number of reports with the unified layout. Just create a template containing all recurring elements and use it in further reports design.

Report Sharp-Shooter offers an increased report performance. A built-in pivot table component allows dynamic data analysis and presentation in the form of OLAP reports. And a native charting component allows you to increase the graphical impact of applications with visually appealing charts and graphs.

Report Sharp-Shooter introduces an advanced concept of SideBySide band that allows placing separate report parts in parallel with horizontal shift. An intuitive end-user designer can be used for both report templates and rendered documents. A convenient Report Wizard helps to design any kind of report with a few mouse clicks. Win and Web viewers allow a user to view reports in Windows and Web applications. Give the reports a professional appearance by using a rich visual controls set, including texts, shapes and pictures. You can also use any Win Forms control as a report element. Report rendering is fully customizable thanks to support for C# and VB.NET scripting. There is no need to learn additional script languages. This grants a developer full access to all .NET Framework capabilities such as import of any project namespaces, local variables, procedures etc. Parameterized reports and subreports provide the opportunity to specify the level of detail needed for particular purposes and create a complicated hierarchy of reports.

Be advised that this component version supports only .NET 2.0. If you work with .NET Framework 1.1, please use Report Sharp-Shooter 2.3 which is compatible with .NET 1.1 and 2.0

Related software: .net, reporting, component, report, engine, generator, solution, for, .net reporting component, .net report engine, .net report generator, reporting solution for .net, …

The success of any business depends on its ability to quickly and effectively analyze changes in a business environment. The simplest solution to this task is analyzing visually displayed real-time data. You can build sophisticated charts yourself, but there's no need to reinvent the wheel if there are components already capable of performing this hard work.
Chart ModelKit by Perpetuum Software LLC is designed for .NET Win and Web Forms applications and provides a comprehensive set of 2D charts. It's possible to use any .NET data sources including ADO.NET, IList and IListSource objects. An intuitive WYSIWYG designer interface allows you to easily adjust chart elements with the mouse. It's simple to set the properties of any selected element in the Property Grid. The designer is available both at design time and run time. Create bound and unbound charts. The open object architecture of the product provides the ability to combine objects arbitrarily and thus to create unique and non-standard chart configurations or to use Instrumentation ModelKit elements for this purpose.
The rich library of the Chart ModelKit contains a comprehensive set of standard elements: axes, labels, legends, titles (etc.) and a set of available series types: Pie, Bar, Stacked Bar, Stacked100Bar, Spline, Line, Bubble, Area, Stacked Area, Stacked100Area, Stock, and Candle Stick. Such GDI+ advantages as gradient fills, anti-aliasing, alpha blending, and backgrounds are available. View charts in Windows and Web Forms apps. The product is included in the .NET ModelKit Suite package and is easily integrated into such components as Report Sharp-Shooter, Instrumentation ModelKit and OLAP ModelKit. The following export filters are offered: SVG, Flash, BMP, JPEG, GIF, PNG, TIFF.
Distribution of Chart ModelKit is royalty-free. Please be advised that Chart ModelKit 3.5 supports only .NET 2.0. If you work with .Net Framework 1.1, please use Chart ModelKit 2.3 which supports .Net 2.0 and .Net 1.1

Related software: chart, net, charting, component, pie, stock, winforms, charts, .net, graphs, financial, diagram, control, diagramming, chart net, net charting, chart component, charting component, pie chart, stock chart, winforms chart, 2d charts, .net graphs, financial charts, net diagram, winforms diagram, chart control, net diagramming, …

The ScimoreDB Parallel Server is a low cost shared-nothing clustered database system . The Database server have been designed to take advantage of parallelization over multiple servers, achieving a near linear scalability for OLAP applications. Supporting up to 512 PC's in a single database cluster, ScimoreDB offers value in terms of speed, functionality and cost.

Key features
1. Ansi SQL92 standard support.
2. Robust ACID transactions support & Safe recovery.
3. Table, row level locking.
4. Multiversion concurrency protocol, where reader transactions are never blocked.
5. Deadlock detection
6. Online/hot backups
7. .NET provider and native C++ client.

Related software: sql, acid, transaction, database, relation, distributed, parallel, rdbms, cluster, stability, performance, reliability, cost, …

Modern businesses are challenged by a host of problems that must be solved immediately or the business won't be a success. One of the most critical problems is the impossibility of making a decision without effectively processed and visually represented information. A complex approach including creation of an effective reporting system, decision support system and real-time data monitoring system is required for the problem solution. .Net ModelKit Suite is a set of components designed for data processing, analysis and visualization. These components allow developers to create sophisticated applications providing immediate decision-making support. With this package you are able to: Use Report Sharp-Shooter: a reporting component for .Net that helps you create flexible and feature-rich reports and easily integrate them into your Web and Windows applications. Create effective visualization applications displaying real-time data with the help of Instrumentation ModelKit. This product includes a rich library of ready-made controls and intuitive graphics editor that allows you to create your own instrumentation controls. Use OLAP ModelKit to perform dynamic data analysis and representation in the form of interactive pivot tables. You can increase the graphical impact of your Win or Web forms apps with visually appealing charts, graphs and digital dashboards designed with the help of Chart ModelKit and the .Net Dashboard Suite. The .NET ModelKit Suite is not simply a pack of individual products. It gives you an interconnected development framework with similar design-time and runtime customization facilities, common data management and appearance customization methods. Please be advised that the .NET ModelKit Suite 3.5 supports only .NET 2.0. If you work with .NET Framework 1.1, please use the .Net ModelKit Suite 2.3 which is compatible with .NET 1.1 and 2.0

Related software: .net, components, suite, winforms, webforms, package, .net components suite, .net components, suite of .net components, .net components package, …

DTM DB Stress is a utility for stress testing the server parts of information systems and
database applications, as well as DBMSs and servers themselves. This tool allows you to create and
configure a continuous set of requests to the server of the OLAP (query execution) and OLTP
(adding, modifying and deleting data in the database) types. At the same time, the user can
flexibly change both the number and the priority of this or that type of requests to a database or
an application.
The program is useful for any information system developer or any QA department employee who
wants to make sure the product under development can work with a large number of simultaneous
connections and concurring queries and transactions. Database administrators can use this
utility to evaluate the current performance of servers and to make plans about increasing processing power.
The stress tool supports all common database interfaces: ODBC, IDAPI, OLE DB, or even Oracle Call Interface.
A test package consists of a set of tasks. Each task is an SQL statement that will be
executed in a loop in the process of testing. Each task can be run as several copies running
simultaneously in separate threads. Tasks have different properties and priority.
DTM DB Stress is a true Win32 application, known to be compatible with the following operation systems: Windows 98 and ME, Windows 2000 family, Windows XP (Home and Professional), Windows 2003 Server family.

Related software: database, testing, stress, database testing, stress testing, database stress, …