---

Please note: This page has been retired.

We no longer sell Contour Components products, please visit their web site instead:

• http://www.contourcomponents.com

To view alternative products, please see the following:

Other information on this page is shown for historical reference only and may have changed considerably since.

---

Summary

ContourCube by Contour Components

URLs: contourcube, contour-components, contour components, contourcomponents

Add analytical and interactive reporting functionality. ContourCube is a high-performance OLAP component for rapid development of Internet, client-server and desktop business intelligence applications. ContourCube allows end users to perform OLAP and statistical analyses using current data from any relational database. ContourCube provides a highly dynamic interface for interactive data analysis, sophisticated analytical, statistical, reporting and graphing features. ContourCube performs OLAP operations on hundreds of thousands of records without an OLAP server.

ContourCube is a high-performance OLAP component for interactive reporting and data analysis. It offers embeddable OLAP technology for all Windows and web applications based on relational data. Application powered with ContourCube allows users to create numerous nice-formed screen and printable reports in a minute. User can interact with data: slice and dice, drill down and roll up, pivot with sub-second response times and without additional server.

ContourCube enables you to embed reach Business Intelligence functionality into native windows or web applications and distribute this application royalty-free. Embedded OLAP is easy to install, zero administration and low cost. ContourCube can get data from any data source of your application via ADO, BDE, ODBC and unbound data source, so you can just drop ContourCube onto a form in your project, link it to your data and get all of new opportunities of embedded OLAP.

There are three editions of ContourCube for developers using different environments:

ContourCube ActiveX - For MS Visual Basic, MS Visual C++, MS Access, MS Visual FoxPro, MS Internet Explorer, Borland Delphi, Power Builder

ContourCube VCL - For Borland C++ Builder developers

ContourCube .NET - For MS Visual Studio .NET 2005 and Visual Studio 2008 developers

ContourCube Benefits:

Interactive data analysis and reporting with sub-second response times

ContourCube allows your users to analyze data, build and print reports interactively simply with a click and drag&drop (with sub-second response times). Users can dynamically interact with data: move rows and columns, filter data, drill-down, roll-up, pivot table and get all possible reports from one dataset. ContourCube will make millions of calculations simultaneously and show new subtotals and totals instantly.

Embeddable OLAP for any database application

ContourCube allows you to integrate OLAP functionality into your General Ledger, ERP, CRM and all other database applications. No additional multidimensional database system (OLAP server) is required. Just substitute the ordinal grid to ContourCube and link it to your data source. You don't need hard programming of hundreds of reports for your application anymore. Your users will be impressed with the way your native windows or web application enables them to understand their data. You will save time and leave your competitors behind. Distribution of this functionality in your application is royalty-free. Embedded OLAP is easy to install, zero administration and not expensive.

Affordable Web based OLAP solution

ContourCube allows you to create affordable Web based OLAP solutions. You can place ContourCube on a Web page, link it to Contour microcube or directly to a corporate data source and all your users will get highly interactive reports from anywhere without additional software and training. Only one license for unlimited numbers of users is needed. It's very suitable solution for creating public information sites and extranet or internet corporate reporting systems.

Rich multidimensional calculations

ContourCube provides rich built-in calculation algorithms palette for business and statistical reports. This palette was based on experience of our users and includes all popular algorithms:

Sum

Count algorithms

Percentage algorithms

Weighted average

Last algorithm for balance sheet and inventory reports

And many others

You can also create your custom calculations using the powerful multidimensional formula language. ContourCube allows you to add calculated fields and edit formulae at runtime dynamically, so users can make OLAP calculations in a manner similar to the use of Excel.

High quality data visualization

ContourCube provides tools for report formatting at design-time and for producing presentation quality reports at run-time. Developer and user can change all colors and fonts and add Titles and Headers containing explanations as well as Footers with footnotes. Header and Footer have RTF formating and allow you to format texts in MS Word style.

Conditional formatting allows developers and users to define conditional colors and fonts of table elements in cascading stylesheets which can make reports far clearer. You can use this feature to create Executive Information systems providing data to decision makers in a simple and convenient form.

Reports distribution technology

Contour microcube contains an extremely compact, well formed report that enables you to rapidly deploy business intelligence applications and information delivery systems to distribute reports to a wide range of users via extranet, intranet, internet and e-mail.

ContourCube Usage scenarios

Web based OLAP solution for public or corporate users

Embedded OLAP in your database application for rich data visualization, interactive reporting and analysis

Enterprise-wide information delivery solutions

Special Analytical applications

ContourCube Main Features Include

Interactive data analysis and reporting features

Processing millions of rows with sub-second response times

Dynamic data filtering, pivoting, drill-down and roll-up

Interactive drill-down into multiple detail levels

Show/hide detail levels in summary views

Interactive filtering of dimension data values

Sorting table by dimension members or facts values

Hierarchical filtering for navigation in thousands of dimension members

Instant switching between ascending and descending sort orders

Automatic sizing of columns and rows to fit values into cells

Header and footer in RTF format

Exporting reports into HTML format, showing reports in Excel and Word

Presentation quality colored or grayscale reports generated with zero programming

Print preview with Zoom, Scale and Fit to Page

Web based OLAP features

Allows you to create web-based OLAP solutions

Users can view and interact with reports stored on Web sites

Reads data and report definitions via HTTP and FTP

Calculations features

Multiple aggregation functions: Sum, Min, Max, Count, and many others

Calculated facts, based on predefined functions or user-defined formulae

Powerful multidimensional Formula language allows you to operate with Totals, Subtotals and any elements of cube data

Conditional operators, built-in functions, user-defined functions and constants in formulae

Multiple calculated facts can be based on other calculated facts

Allows user to interactively add and edit formula facts at runtime like in Excel

Several percentage calculation algorithms: by totals, subtotals, or grand totals

The unique "LAST" aggregation algorithm allows to analyze stocks, inventory stock, balance sheets, loan balance and other datasheets with balance carried forward

Advanced dynamic Ranking

Breaking date and time fields into series dimensions (Year, Quarter, Month, Week, Ten-Day Period, Day of Month, Day Of Week, Time, Hour, Minute, Second )

Rich set of dynamically calculated statistical functions: Average, Variance, Standard Deviation, Root Mean Square, Variance Ratio

Data visualization features

Allows to change all appearance properties at design time and at runtime

Conditional style rules grouped in cascaded stylesheets allow users to highlight various data

Runtime editors for connection settings, fields used, report layout, header and footer, styles and rules

Professional looking toolbar with source code included

Report distribution features

Generates extremely compact microcubes for persistent data storage

Microcube data is compressed from 10 to 1000 times, and generates low traffic while transferring by email or internet and can be saved for offline working

Contour microcube contains not only data but all report layout settings and is a universal mobile report container

Any ContourCube-powered tool and application can exchange reports stored in microcubes

Microcube allows you to develop corporate and public information delivery systems

What's new in ContourCube 4.0?

Support for .NET 2.0 - 3.5 (Visual Studio 2005 - 2008)

Dimensions Tree View

Filtering Dimensions by Fact Values

"Total-Including" reports

Unbalanced Hierarchy

Hierarchy Objects

Hidden Dimensions

New Export Features

Remastered Look and Feel

Automatic Color Gradient on Dimensions

What’s new in ContourCube V3.0.5?

Added tooltips for the buttons in the Print Preview window

Added procedure to copy dimension collapse states onto another view

Added new export procedure that saves report with tree axes

Fixed: Misplaced rows in UI when scrolling with page down

Fixed: SUM and MIN facts may be faulty depending on their order in code

Fixed: Percentage values take wrong format when exported to Excel

Fixed: Multiple processes saving microcube may conflict

Fixed error in sorting table by fact values

Fixed paths to sample microcubes located on the web

What’s new in ContourCube V3.0.4?

Bugs fixed:

OnFiltered event fires too much on every filter operation

Changing dimension format on active cube does not affect filter lists

WildcardMatch pattern processing error: unclosed braces encountered in wildcard expression lead to access violation error

Outside area height calculated incorrectly in Multiline mode

Null values in dimensions cause runtime error "Unsupported field type"

Changing fact visibility also changes its position in the facts list

Changes:

Implemented highlighting filtered dimensions in italic when using XP themes

What’s new in ContourCube V3.0.3?

Optimized the grid redraw code for faster operation

Added locale selection to ContourCube ActiveX

Implemented charset customization for exported documents

Improved charting interface API for easier recognition of Totals sections

Added charting example for C#.NET 2005

What’s new in ContourCube V3.0.2?

ContourCube.NET 3.0.2.05 & ContourCube VCL 3.0.2.07:

Added new OnActionWait item for export operations (useful for progress bar while exporting reports)

Switching between single value and multiple values mode for dimensions available on active slices

Implemented hidden dimensions with filtering on live cube – a “must have” feature for analysts

Added new sample on how to create new slices and views

ContourCube ActiveX 3.0.2.07:

Added new OnActionWait item for export operations (useful for progress bar while exporting reports)

Switching between single value and multiple values mode for dimensions available on active slices

Implemented hidden dimensions with filtering on live cube – a “must have” feature for analysts

Ensured compatibility with WoW subsystem in 64bit systems

Enabled programmatic resize of dimension width

Enabled changing the property pages’ title at runtime

Added new example of hiding outside dimensions in a live cube

What's New in ContourCube V3.0.1?

ContourCube .NET V3.0.1:

The .NET Help collection for ContourCube now appears at the top level of the help system

Added "forward" trending functions in the Formula language

Added extended attributes for cube fields

Implemented public API for working with clipboard

Implemented auto-height on grid rows

Implemented wraparound indexing for all collections and view/grid cell coordinates

Allowed to use local (not stored in a style holder) styles in formatting rules

New Demos: DateDiff (Illustrates new date diff functions of theFormula language) , Feeder (Implements an easy direct feed data interface)

ContourCube ActiveX V3.0.1:

Added "forward" trending functions in the Formula language

Added IContourView::FactsByState() method

Added extended attributes for cube fields

Implemented IExtendedAttributes for IField

Implemented public API for working with clipboard

Implemented auto-height on grid rows

Implemented wraparound indexing for all collections and view/grid cell coordinates

Allowed to use local (not stored in a style holder) styles in formatting rules

New Demos:DateDiff (Illustrates new date diff functions of theFormula language) and Feeder (Implements an easy direct feed data interface)

What's New in ContourCube V3.0?

VS 2005 enabled .NET edition: New ContourCube.NET for Windows forms enables development of native .NET Business Intelligence applications. ContourCube.NET is tested with both Microsoft® Visual Studio .NET 2003 and 2005 and brings its extremely high performance to this platform

Wrapping long strings. Programmatic control of the report witdth. Long dimension members occupying all the space in width, in ContourCube 3.0 are wrapped. Programmatic field width adjustment improves the control over report appearance in application forms, exported and printed documents

Date arithmetics for sophisticated date-aware business calculations: A large set of functions for date-dependent calculations make critical business algorithms easier. Write custom functions referring to the number of days in given year or month, current date / time, and much more. With those functions it became possible, for example, to get averages by all days in year rather than only days with data

Trend functions: A number of positional functions for fast trending calculations, running sums and other recursive computings. To get three major business values like trend from previous period, from same period of the last year, and from the very first year is just matter of a simple formula with new trend functions

Flat appearance for web applications: ContourCube 3.0 has a switchable flat grid appearance designed specially for web applications

XP style look & feel. Support of Windows XP themes: For Windows applications, ContourCube 3.0 offers dynamic support of XP-style look and feel and appearance themes, ideal for applications running on Microsoft Windows® XP and 2003

Wrapping outside area. Display of outside fields in multiple rows or vertically. In real life OLAP cubes, where a lot of unused dimensions may occupy too much space, ContourCube 3.0 offers control over their arrangement: one may put fields horizontally, in multiple rows or even vertically, improving report navigation and lisibility

Dynamic captions:Making cube fields behave as list boxes: This feature switches cube dimension to look and behave just like usual dropdown list boxes: selecting a value in such dimension changes its caption and unselects all previously checked items

Clipboard copy: Like plain data grids, ContourCube 3.0 supports selection of data cells with mouse or keyboard and copying it to Windows clipboard. Copied data then ideally pastes into any text or spreadsheet application like Microsoft® Excel.

Direct data access: New data feeder interface enables loading data from multiple source databases, with no need of copying entire record sets to client computer, which reduces the total memory used to build a cube

Add analytical and interactive reporting functionality.

Evals & Downloads: Read the ContourCube VCL 4 help file, Read the ContourCube ActiveX 4 Help File, Read the ContourCube .NET 4 Help File, Read the ContourCube Support Plans Comparison, Read the ContourCube V4 License Agreement

Operating System for Deployment: Windows XP, Windows Server 2003, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class, ActiveX OCX, VCL

Built Using: Borland(R) C++ Builder[TM] 5

General: Internet Enhanced, Includes Digital Signature

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio 6.0, Microsoft Visual Studio 97, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic 6.0, Microsoft Visual Basic 5.0, Microsoft Visual Basic 4.0, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ 6.0, Microsoft Visual C++ 5.0, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Office 2007, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000, Microsoft Access 2003, Microsoft Access 2002, Microsoft Access 2000, Microsoft Access 97, Microsoft SQL Server 2000, Microsoft SQL Server 7.0, Microsoft Outlook 2002, Microsoft Outlook 2000, Microsoft Internet Information Server 5.0, Microsoft Internet Information Server 4.0, Microsoft Internet Explorer 7.0, Microsoft Internet Explorer 6.0, Microsoft Internet Explorer 5.5, Microsoft Internet Explorer 5.0, Netscape Navigator, C++Builder 6, C++Builder 5, C++Builder 4, Delphi 8.0, Delphi 7.0, Delphi 5.0, Delphi 4.0, Delphi 3.0, Delphi 2.0, Sybase PowerBuilder 8.0, Sybase PowerBuilder 6.0, .NET Framework 3.5, .NET Framework 3.0, IBM DB2 8.x

Product Class: Business Components

Keywords: contourcube, contour components, contourcomponents, contourcube olap, contour cube olap, contourcube 4, contour cube 4

Contour Components

On-Line Analytical OLAP analysis analyze analyse

Reporting Reports Report

Database DB Reporting Report reports