Search
English
RadarCube OLAP Grid and OLAP Chart for ASP.NET and Silverlight: overview

It's the best choice for your BI-portal. Extremely powerful and high-speed, yet wonderfully flexible when it comes to customizing, our OLAP controls will add to your web-based Business Intelligence application the unsurpassable facilities of our OLAP solution, the best in its class.

Our product is a full-function set of OLAP controls, visualizing OLAP data both as table and as chart. HTML and Silverlight visualization, compatibility with almost any database or Microsoft Analysis Services server as data source, amazing performance and convenience, the maximum range of options - all this is at the service of analysts and OLAP-analysis experts.

Our controls are almost 10 MB of source codes, a few hundred thousand pages' text, almost five years of developing - we've done it all for you. Appreciate our solution at its true value, see our videos, illustrating our control's facilities, test it online or download the full-function evaluation version.

 

 

Data source and export features

Supports any kind of data sources, like database, file etc. Supports Sql Server Analysis Services cubes as a multidimensional data source.
Supports large-size databases and cubes.
Saving and restoring the current OLAP slice.
Handy integration with charting and other third-party components.
Export the Cellset to the most popular formats, like PDF, HTML, GIF, XLS etc.

 

OLAP-specific features

The calculated measures of a few different types (row-table based measures, custom-aggregated measures and measures based on other Cube cells).
Calculated hierarchy members.
Attributes which store additional information about hierarchy members.
Hierarchies of three types:
  • Attribute (or flat) hierarchies
  • Parent-Child hierarchies
  • Multilevel hierarchies
Interactive drill-down support of all types of hierarchies separately for every hierarchy member.
Different measure display modes simultaneously (values, per cents from various totals etc).
Member grouping on any hierarchy level.
Separate hierarchy or dimension customizable sorting on any level.
Ascending or descending sorting based on any column value in the OLAP grid.
Filtering of any set of hierarchy members with or without applying these filters in the OLAP calculations.
Context 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.
Threshold visual filtering feature.
Supports the Writeback (the Cube cells editing) option.
Supports the Drillthrough (browsing the relational data aggregated into the Cube cell) option.

 

Appearance

HTML or Silverlight OLAP Grid visualization.
Full control over the OLAP Grid cell's content.
Fixed columns/headers on scrolling the Grid. Automatical cell ajustment by content. An option of changing the width of columns.
Hierarchies' page-viewing mode. This feature allows to significantly lessen the network traffic and make the OLAP analysis easier.
Customizable context menus in the Grid.
Easy localization. It is possible to localize the evaluation version as well.
Supports end-user comments on Grid cells.
Cells' coloring, depending on their values, with the use of different patterns.
Context formatting, selecting and copying to Clipboard.
Visualizing OLAP-slice both in the text and graphic versions.

 

OLAP Chart features

Modifications of color, form and OLAP Chart element size depending on the values of different measures. Discreet and continuous color modifications.
Areas, Lines, Splines, Bars, Pies and Points data visualization modes.
Numerical X and Y axes for visualizing the correlation between two measures.
Displaying an arbitrary number of levels in a multi-level hierarchy.
Grouping a few measures in a single diagram.

 

Direct version specific features

Auto conversion of the DateTime fields into flat or multilevel hierarchies.
Medium trust compliance.

 

MSAS version specific features

Support of the MSAS Actions.
Support of Time intelligence features.
Browsing results of arbitrary MDX squeries.

 

Clean ASP.NET solution

Our control is installed on a pure ASP.NET platform and does not require installation of any additional library, like ASP.NET AJAX, ASP.NET Toolkit etc. The control may be installed on ASP.NET 3.5 or higher.

 

ASP.NET or Silverlight visualization

For and end-user our OLAP control may be visualized in two variants: either using a standard HTML-code or as a Silverlight application embedded in ASP.NET control. The HTML-form of the control is more universal, while the Silverlight-form has a modern touch and is more interactive.

 

100% AJAX

Whatever visualization form you use, the control is 100% AJAX-enabled - almost all the queries to the server are sent in the callback mode. At the same time the control is fully compatible with the ASP.NET AJAX library (though it doesn't require its installation), and is able to operate in that environment.

 

Different data sources

For a data source the control supports the MSAS server version 2000 or higher or any other database that has a NET provider. Due to the special cache technology the control is able to operate with the bases of up to 1,000,000 records, and in case it's an MSAS-version - with databases of practically unlimited size. It's the only control that is able to fetch data from several database tables and support both "Star" and "Snowflake" schemas on the MOLAP-core level.

Be careful! The commercial version of the control is shipped in two versions: Direct (for working with databases) and MSAS (for working with the Microsoft Analysis Services server). Make sure you've ordered the correct version!

 

Usability

In addition to the flexible settings, the Grid has different popup menus that make it easy to access the RadarCube numerous functions. The menus are truly context-dependent and have unique options for each of the Grid cells, depending on both cell type and content. Also, you can easily customize any popup menu by using an appropriate event.

 

Higher security

RadarCube OLAP Grid control is fully PROTECTED. The client receives only the visualization of data - any information concerning data sources or the like does NOT get to the client.

 

OLAP Grid's 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. You can create your own sorting and context filtering. We can surely say the RaradCube is a constructor you can use to create OLAP-reports of any complexity.

 

Client requirements
  • IE6+ or Firefox 2+ for the HTML OLAP Grid.
  • Silverlight 4 runtime for the Silverlight-based controls.
Developer requirements
  • Visual Studio 2005, 2008 SP1, 2010 (recommended), Visual Web Developer.
  • NET Framework 3.5 SP1 or higher (NET 4 recommended).
  • Silverlight 4.0 runtime (Silverlight 4.0 Developer Tools recommended).
  • For RadarCube for MSAS: ADOMD.NET, Microsoft SQL Server Analysis Services OLE DB Provider.
  • To recompile RadarCube source codes (shipped with the commercial versions with source codes) Visual Studio 2010 and Silverlight 4.0 Developer Tools need to be installed.
Web server requirements
  • IIS 6+.
  • NET Framework 3.5 SP1.
  • For RadarCube for MSAS: ADOMD.NET, Microsoft SQL Server Analysis Services OLE DB Provider.
Related links

Download evaluation version


OLAP Chart for ASP.NET


ASP.NET version history


License agreement


Purchase OLAP Grid


Watch videos


Try OLAP Grid online


Hot news
Click to subscribe

 July 22, 2010

RadarCube for WPF beta is here

The new RadarCube for WPF version has started.

Details...

 

Latest versions
Click to subscribe

 July 14, 2010

RadarCube ASP.NET 2.44.3

Changes...Download...

 

Related articles
Click to subscribe

 May 5, 2010

New Silverlight add-on for RadarCube ASP.NET

Details...

 

 March 30, 2010

Designing the Cube with the Cube Creation Wizard

Details...

 

 December 16, 2009

Creating custom Time Intelligence

Details...

 

 November 26, 2009

Creating the correct Cube structure

Details...

 

 September 30, 2009

RadarCube Request tracker

Details...

 

 August 24, 2009

Customizing the toolbox in Ria OLAP controls

Details...

 

 June 3, 2009

Customizing RadarCube for ASP.NET

Details...

 

 May 8, 2009

Hierarchy members' attributes

Details...

 

 February 10, 2009

Initialization of the OLAP-slice view

Details...
More articles...
Support | Download | Purchase | Partners | Upgrade and Discount Policy | Contacts © 2005-2010 Radar-Soft, L.L.C. All rights reserved.