RadarCube OLAP Grid Windows Forms Desktop

If you are looking to add powerful OLAP functionality to your applications, then the NET Windows Forms OLAP control is the tool you need. This control offers superior performance for large relational databases with millions of records. With all OLAP operations available, such as drilling, pivoting, filtering, grouping, and drill through, this software is everything you need to create true OLAP applications.

One of the most notable features of this control is its splendid user interface and powerful API, designed to create applications that take full advantage of OLAP functionality. The Cube Editor allows you to quickly and easily create fully-functional OLAP cubes.

This software offers a wide range of features, including OLAP Grid and OLAP Chart visualization modes, along with the ability to work with one or several tables/views/stored procedures described in a DataSet object. The software also includes standard aggregation functions like Sum, Count, Distinct Count, Min, Max and custom aggregation functions.

Hierarchies of three types are available: Parent -child (both balanced and unbalanced), Multilevel (both regular and ragged), and Mixed from all previous types. The software also enables programmed calculated measures, dimensions, hierarchies, and hierarchy levels as well as calculated hierarchy members.

The software also offers autoconversion of DateTime fields into multilevel hierarchies with any conversion algorithms, while Unicode support is available as well. There are several types of drilling down, including the nearest successor, the next level, and the next hierarchy.

The software enables hierarchy members grouping and separate sorting of different hierarchy levels, whether ascending or descending sorting based on the column values in the grid. Hierarchy members can also be filtered with or without applying these filters to the OLAP calculations.

The software also provides extensive control over the cells' contents, with the ability of custom drawing within the cells. Custom context menus in the grid and auto-sizing of cells based on contents are also included. Additionally, the IListSource interface allows the OLAP Grid to be used as the data source for other components working with data, like Chart or export.

Finally, when using this software, you can export to MS Excel, BMP, TXT, HTML, JPG, GIF, PDF, etc., and even edit OLAP data with writeback capabilities. Overall, the NET Windows Forms OLAP control is an excellent software for adding OLAP functionality to your applications.