An OLAP Control/Component by Radar-Soft, L.L.C.

RadarCube ASP.NET Direct V1.40.2

RadarCube Direct is a set of components for using by software developers, and designed to create fast, comfortable, and powerful OLAP-applications. RadarCube allows to form OLAP-views "on-the-fly", not wasting time and memory for intermediate calculations. And for all that the performance of calculating almost doesn't depend on capacity of the cube and depth of hierarchical dimensions. The engine processes the fact table holding one million of records for less than a single second.

Main features:

• Royalty free!
  
• 100% managed code, entirely written in C# 2.0.


• Supports IE 5.5 or above, Firefox 1.1 or above, Opera 9.0 or above.


• Supports the client-side operating systems: Windows (all versions), Linux, Mac OS.
  
• Requires no OLAP-servers to work. An ability to create any multidimensional cube in run time or design time, using the minimum web-server memory.
  
• One or several tables/views /stored procedures described in a DataSet object can be used as a data source. Also direct working with the components supporting the IDbCommand interface is possible to speed up the data fetching.
  
• A set of standard aggregation functions like Sum, Count, Distinct Count, Min, Max, Biased or Unbiased Variance, Median and so on. Custom aggregation functions can also be used instead or along with.


• Numbers, strings or dates can be used as measure values.


• All entities of modern industrial OLAP-servers are supported: dimensions, hierarchies, hierarchy levels and their relations.


• 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 from the fact table rows as well as from the rows of any related dimension table, that is connected to the fact table through the foreign key.
  
• An ability to create additional calculated measures using the values of any other cube cell.
  
• Calculated members of hierarchies.
  
• Hierarchy attributes which store additional information about hierarchy members.
  


• Auto conversion of the DateTime fields into multilevel hierarchies. Any conversion algorithms.

DHTML visualization

• 100% AJAX.


• Web parts support.


• Time intelligence support.


• Fixed columns/rows headers on scrolling the grid.


• An ability to simultaneously display a set of measures and measure show modes in the Grid.


• Interactive drill-down support of all types of hierarchies separately for every grid cell.


• Saving and restoring the current OLAP slice.


• Supports member grouping on any hierarchy level without changing the hierarchy levels structure.


• Supports separate hierarchy or dimension sorting on any level. An ability to override any sorting method.


• Supports ascending or descending sorting based on any column value in the OLAP grid.
  


• An ability of a hierarchy page-viewing. This allows to significantly cut down the network traffic and make the OLAP analysis easier and faster.


• Supports filtering of any set of hierarchy members with or without applying these filters to the OLAP calculations.


• Supports the 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.


• An ability to display in the grid not only the values of the measures, but a percent value in terms of totals, subtotals, or grand totals. An ability to create your own context-sensitive rules on measure displaying (for example, a cumulative sum of measure values for time dimensions, and just its value in all other cases).


• The image drawing in any grid cell, the auto positioning of a picture in a cell, depending on the parameters assigned by a programmer.


• A complete data output control.


• Supports the custom popup menus in the grid.


• Handy integration with charting and other third-party components.


• The flexible export to the following formats: BMP, CSV, GIF, HTML, JPEG, PDF, PNG, TIFF, TXT, XLS, XML.


• Easy localization. It is possible to localize the evaluation version as well.

Technical Information

Component Type - Contains the following types of components...

• .Net Class Library  • ASP.Net Web Control

For more information about this product please visit the