RadarCube OLAP ASP.NET Direct is a fast, powerful and programmer-friendly ASP.NET OLAP library.

Do you want an ASP.NET control for OLAP-Analysis? Do you want a powerful OLAP library without having to install any software or any ActiveX components on the client side? Do you want to provide your clients or customers with a perfect, flawless thin OLAP client?

If you have the relatively small database and don't want to set up the dedicated OLAP server... If you want to connect directly to your relational database... If you want your thin client to be scalable enough... If you want your customers to use such OLAP functionality as Pivoting, Sorting, Grouping, Filtering, and time series analysis... And if you want all these functions to be tunable...

If you want to have multilevel dimensions in your cube... If you want the OLAP grid for ASP.NET to display the hierarchical dependencies in the Parent-Child dimensions... If want your clients to be able to use OLAP with Windows, Linux, or MAC OS... And, at last, if you don't want to pay royalty for your every single client...

Then you're looking for a perfect OLAP decision. And now it's not a dream any longer. You may consider all this to have been done. We did it. And we're happy to present you the new and long-expected product "RadarCube ASP.NET Direct", which makes the dreams come true.

Here are some key features of "RadarCube OLAP ASP NET Direct":

Key features:
· 100% managed code, entirely written in C# 2.0.
· Medium trust compliance. It can be used on most shared Windows hosting environments.
· 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.


Limitations:

· The demo string in first nine Grid cells instead of Data

What's New in This Release: [ read full changelog ]

· Bugs fixed:
· In the version 1.40.0, the drilling down doesn't work.
· Many small improvements and bugfixes in the TOLAPExport control.