 |
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.
The special cache mechanisms and visual improvements allow working with databases
containing up to 1,000,000 records (and in the case of MSAS version - practically
with bases of any size), and with dimensions of many a thousand members.
|
 Saving and restoring the
current OLAP slice.
|
 Handy integration with
charting and other third-party components.
RadarCube may serve as data source for other controls - in this case RadarCube provides
its current Cellset as source data. The data can be exposed in different modes -
see the RadarCube documentation for details.
|
 Export the Cellset to the
most popular formats, like PDF, HTML, GIF, XLS etc.
In addition to copying to the Clipboard, RadarCube allows exporting OLAP Grid contents
into many other popular formats.
RadarCube has lots of options for tuning its appearance and changing the contents
of cells upon export, enabling/disabling paging and many other things.
|
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.
Both Direct and MSAS versions allow creating additional calculated members inside
any hierarchy. These members come very handy for, say, displaying some intermediate
results. The algorithms of calculating such members are implemented programmatically
in the appropriate control's event handlers.
For the MSAS version, there's also an option of creating calculated hierarchy members
through the end-user interface, with MDX expressions.
|
 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.
It is possible to programmatically change the contents of OLAP Grid cells, change
the cell text, insert images and icons into cells and even arbitrary HTML or ASP.NET
fragments. OLAP Grid will automatically adjust the size of the cell to its contents,
whatever it is.
|
 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.
RadarCube offers an advanced system of context menus that grants a user a quick
access to all control's options. But more that that: any additional functions may
be implemented into RadarCube programmatically and then accessed via the context
menu.
|
 Easy localization. It is
possible to localize the evaluation version as well.
RadarCube's interface is very convenient for localization - all the lines visible
for an end user, can be translated into any language. Besides, the translation made
by one user is also available to the rest of them, and is included into the next
version of RadarCube. Thus, at the moment RadarCube is translated - fully or partially
- into more than 20 languages.
By default, RadarCube uses the preferred language of the end-user's browser - but
there is an option of strictly defining the main language for RadarCube.
|
 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.
RadarCube OLAP Grid Direct-version satisfies the "medium trust" specification that
allows using it on most shared hostings provided by ISP, without any additional
setting of security policy.
|
MSAS version specific features
 Support of the MSAS Actions.
RadarCube supports MSAS Actions, such as URL, Drillthrough, Rowset etc. All these
actions are interpreted according to their description in the MSAS Cube, and are
accessible through the context menus of the corresponding RadarCube cells.
|
 Support of Time intelligence
features.
In the MSAS-versions for the data cells that deal with time measurement there is
an option of using the "Time Intelligence" features - a powerful means for statistical
analysis of Time series. It can be accumulating amounts, moving average or evaluating
values growth in comparison to the previous period, etc.
The Time Intelligence function is available through the context menu of data cells.
As many other things in RadarCube, the items in the Time Intelligence menu can be
tuned programmatically.
|
 Browsing results of arbitrary
MDX squeries.
Not only can RadarCube be used as a tool for browsing a multidimensional cube, but
it can also display the results of any MDX-queries. In that case, the Grid doesn't
support such operations as drilling, pivoting, sorting, grouping, and filtering,
but as always you can change a cell's contents and its look and feel, as well as
fix the row/column headers.
|
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.
|
|
Download evaluation version
OLAP Chart for ASP.NET
ASP.NET version history
License agreement
Purchase OLAP Grid
Watch videos
Try OLAP Grid
online
July 22, 2010
RadarCube for WPF beta is here
The new RadarCube for WPF version has started.
July 14, 2010
RadarCube ASP.NET 2.44.3
May 5, 2010
New Silverlight add-on for RadarCube ASP.NET
March 30, 2010
Designing the Cube with the Cube Creation Wizard
December 16, 2009
Creating custom Time Intelligence
November 26, 2009
Creating the correct Cube structure
September 30, 2009
RadarCube Request tracker
August 24, 2009
Customizing the toolbox in Ria OLAP controls
June 3, 2009
Customizing RadarCube for ASP.NET
May 8, 2009
Hierarchy members' attributes
February 10, 2009
Initialization of the OLAP-slice view
|
|