Soft82.com » Windows » Developer Tools » Components & Libraries » RadarCube Windows Forms Desktop OLAP 2.51.0

RadarCube Windows Forms Desktop OLAP Description

.NET Windows Forms OLAP control: relational DB high performance, rich features

RadarCube for Windows Forms is a unique Desktop OLAP component written in C# 2.0 combines unsurpassed power of the RadarCube OLAP core with easy NET Framework programming.

Data

RadarCube supports the data warehouse structure by using all its tables. RadarCube dimensions and measures structure allows the data warehouse structure to be reflected in the final OLAP-report to the full extent. Unlike the competing products, RadarCube supports such DWH structures as "star" and "snowflake", several fact tables and "parent-child" relations in the dimension tables.

In the OLAP-schema the data is organized in multilevel (for the "snowflake" schema) and the "parent-child" hierarchies. In Visual Studio you only need to create a standard DataSet and describe all tables relations and then you can use it as a data source for RadarCube. More than that, in comparison with the only table or view available in the competing products, this one allows you to save memory and reduce the time for loading data.

Performance

Despite the fact that RadarCube is 100% managed, it doesn't yield in its performance to its VCL analogues: HierCube and RadarCube for VCL. The unique technology of calculating OLAP-slices "on the fly" first implemented in HierCube and updated in RadarCube, allows calculating only the data currently displayed in the Grid, not more. Such technology saves memory and remarkably reduces an OLAP-slice calculation time. Thus, RadarCube easily operates with data warehouses containing up to several million records in the fact table, and keeps the response time within a few seconds. You can see the RadarCube benchmarks here.

Using DataSet as a data source, RadarCube is able to fetch data directly from a database using the IDbReader interfaces operating in the "Forward only" mode. In this case, the OLAP-application using RadarCube takes up approximately as much memory as it would have taken with fully filled DataSet without any OLAP-component.

The Additional OLAP Features

The power of the RadarCube core shows up not only in the unique performance and most compound OLAP structures support, but also in OLAP reports individual settings. This includes the automatic transformation of dates into flat and multilevel hierarchies, possibility to create calculated dimensions and hierarchy members, calculated measures and calculated hierarchies. For example, for the "Year" dimension you can create calculated members that show the year-to-year dynamics. For the "Account" measure, you can create calculated members to show the sub-totals by the sum of some of the expense or income items. The values of these calculated members will be adjusted to the active OLAP-slice. More than that, you can show or hide member values for particular contexts.

The OLAP Data Display Features

Even a brief overview of RadarCube features will be incomplete without mentioning the abilities of the Grid to display OLAP-slices. It allows the user to replace the content of any Grid cell, to place a picture of any size into any Grid cell, to automatically position pictures and text within a cell, to adjust the cell size to its contents, to change order of the members by simply drag-n-dropping them with the mouse, context dependent filters, members' grouping, any method of sorting including alphabetical, value dependent, or custom.

The unique features of the Grid settings include approximately 50 diverse parameters of cell appearance: background color, fonts, gradient, cell borders, rounded corners, pictures according to the cell type, standard skins, and much more. In short, you'll be able to alter all the standard drawing methods. And finally, you'll be able to customize cell context menus and use the built-in data editing.

Conditional Formatting

Like its predecessor, HierCube, RadarCube supports formatting of the cell content in accordance with its value. Context formatting can be applied to a selected area or to the whole Grid. There are different variants of formatting: you can change the background color, draw bar charts within cells, or make other amends.

RadarCube API

The RadarCube core has a detailed and well documented API which allows you to perform any OLAP-slice modifications from within your application, obtain information about any Cube or Grid cell no matter if it is actually displayed in the current Grid report. You can create your own aggregation functions with event handlers; define your own functions for calculating dimension members, define your own sorting and context filtering methods. We can surely describe RadarCube as a perfect tool to create OLAP-reports of any complexity.

Our Policy for Developers

RadarCube is royalty free (of course, if you don't use it to create your components for resale and are stuck to the License Agreement). By purchasing RadarCube you get the right to download new versions within a year from the purchase date, get free tech support, and a discount for purchasing our products. If for some reason you're not satisfied with the quality of the product, you can get your money back within 30 days from the purchase date.

Key Features: Cube Definition

* One or several tables/views /stored procedures described in a DataSet object can be used as a data sourse. Data fetching can be sped up by using the components implementing the IDbCommand and IDataReader interfaces.
* A standard aggregation functions set (including Sum, Count, Distinct Count, Min, Max, Biased or Unbiased Variance, Median, etc.) is avaliable. Custom aggregation functions are possible to make.
* Numbers, strings or dates can be used as measure values.
* Grouping of measures is supported.
* Three types of hierarchies:
o Parent-child hierarchies (both balanced and unbalanced);
o Multilevel hierarchies (both regular and ragged);
o Mixed from all previous types.
* Building calculated measures, dimensions, hierarchies and hierarchy levels from the fact table rows as well as from the rows of any related dimension table.
* Creation of additional calculated measures using the values of other cube cells.
* Calculated members of hierarchies.
* Hierarchy attributes which store additional information about hierarchy members.
* Auto conversion of the DateTime fields into multilevel hierarchies. Custom conversion algorithms can be used.

Key features: Data Visualization

* Unicode support.
* Simultaneous display of several different measures in the Grid.
* Simultaneous drilling down based on different parameters: up to the nearest child, up to the next level, up to the next hierarchy.
* Saving and restoring the current OLAP-slice.
* Hierarchy members grouping (including multilevel and parent-child hierarchies).
* Separate sorting on different hierarchy levels. Possibility to override any sorting method.
* Ascending or descending sorting based on the cell values in any column of the Grid.
* Filtering of hierarchy members with or without applying these filters to the OLAP calculations.
* Auto filtering of the hierarchy members depending on their values in the Grid. Major/minor members selection, either based on their rank or on the Pareto principle.
* Display in the Grid not only the values of the measures but also value percentage in totals, subtotals, or grand totals. A possibility to create your own context-sensitive rules for measure displaying.
* Placing pictures into Grid cells, and automatic positioning of pictures and texts within cells, depending on the parameters defined by a programmer.
* The full control over any Grid cells contents, ability of custom drawing within cells.
* Adjustable context menus in the Grid.
* Replacing hierarchy members by drag-n-dropping them within the Grid.
* Auto sizing of cells depending on their contents.
* Editing OLAP data directly in the Grid.
* The IListSource interface implementation. A feature which allows OLAP Grid to be used as a data source for other NET components working with data (for example, Chart or export components).
* Flexible export to MS Excel, HTML, GIF, JPG, PNG, BMP, CSV, TXT, PDF formats.
* Easy localization, even of the evaluation version.

RadarCube Windows Forms Desktop OLAP Version History

RadarCube Windows Forms Desktop OLAP Download Button For Your Site

If you want to place a Download Button for RadarCube Windows Forms Desktop OLAP on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

RadarCube Windows Forms Desktop OLAP User Reviews

New Components & Libraries Software

OWLNext May 25, 2012 A modern update and extension of Borland's Object Windows Library for writing GUI apps				Comm Operator Pal May 25, 2012 A free tool to test and debug RS232 devices that communicated with serial port, TCP/IP, UDP and
Witzend Thumbnail Image Viewer May 24, 2012 Accurately displays miniature thumbnail renderings of graphics files				PyBCI May 23, 2012 Create a Brain Comp. Interface (BCI) and herewith to get EEG data online
TMS Panels Pack May 23, 2012 A collection of panels, containers & tabs to make your applications stand out from the rest				SWI-Prolog Portable May 22, 2012 A comprehensive Free Software Prolog environment, licensed under the Lesser GNU Public License
Nevron User Interface for .NET May 22, 2012 Professional User Interface component suite for Windows Forms applications				Calibre May 21, 2012 E-book library management application
ShareWatcher May 21, 2012 ShareWatcher logs and notifies you when others access your shared folders				IntelliJ IDEA May 21, 2012 A code-centric IDE focused on developer productivity
Scikit Learn May 17, 2012 scikits.learn is a python library for machine learning				Fast File Download ActiveX May 17, 2012 An ActiveX component(ActiveX control) that can fast download files from the Internet
.Net Grid May 17, 2012 Productive and robust hierarchical grid with one of the best object models				Excel to PDF .Net May 17, 2012 A standalone component which allows any .Net application get professional export of Excel XLS files
Virtual 8085 May 16, 2012 A tool which enables students to run programs written in 8085 assembly language				dbExpress driver for MySQL May 16, 2012 A driver that provides fast access to MySQL databases.
GUI Design Studio Express May 16, 2012 A graphical user interface design tool for Microsoft Windows				PG4UW May 15, 2012 Common control program for Windows for all ELNEC programmers
dotConnect for Oracle Express Edition May 15, 2012 An enhanced ORM enabled data provider for Oracle that builds on ADO.NET				Wireless Communication Library MFC Developer May 15, 2012 Powerful C++ SDK which expands your applications with Bluetooth, IrDA, WiFi and Serial

Last 7 Days Most Downloaded Components & Libraries Products

Aircrack-ng GUI 163 downloads This is mainly just an interface tweak for Aircrack-ng				Microsoft Visual C++ 2008 Redistributable Package 61 downloads Installs runtime components of Visual C++ Libraries required to run 64-bit applications developed...
ActiveX Download Control 44 downloads Support BreakPoint download,a client ActiveX control easy to realize the download batch files from...				C++dbc 43 downloads A library to help you with database management.
Microsoft Visual C++ 2010 Service Pack 1 Compiler Update for the Windows SDK 42 downloads Restore the Visual C++ compilers and libraries that may have been removed				Windows Imaging Component 30 downloads Provides WIC-enabled applications to display and edit any image format
Grasshopper 30 downloads A Subversion reporting tool				Quake I port for Nokia Series 60 src 26 downloads Quake I port for Nokia Series 60 source code
Headers and Libraries for Windows Internet Explorer 9 23 downloads Develop Windows applications that use Windows Internet Explorer 9				Windows Std Serial Comm Lib for C/C++ 22 downloads Serial communications component C++ (.NET) library for serial/usb port programs

All Time Most Downloaded Components & Libraries Products

Aircrack-ng GUI 15,975 downloads This is mainly just an interface tweak for Aircrack-ng				Microsoft Visual C++ 2008 Redistributable Package 31,666 downloads Installs runtime components of Visual C++ Libraries required to run 64-bit applications developed...
ActiveX Download Control 22,262 downloads Support BreakPoint download,a client ActiveX control easy to realize the download batch files from...				C++dbc 16,729 downloads A library to help you with database management.
Microsoft Visual C++ 2010 Service Pack 1 Compiler Update for the Windows SDK 3,642 downloads Restore the Visual C++ compilers and libraries that may have been removed				Windows Imaging Component 35,567 downloads Provides WIC-enabled applications to display and edit any image format
Grasshopper 1,765 downloads A Subversion reporting tool				Quake I port for Nokia Series 60 src 7,846 downloads Quake I port for Nokia Series 60 source code
Headers and Libraries for Windows Internet Explorer 9 3,577 downloads Develop Windows applications that use Windows Internet Explorer 9				Windows Std Serial Comm Lib for C/C++ 11,484 downloads Serial communications component C++ (.NET) library for serial/usb port programs