Search
English
RadarCube Olap Chart for Windows Forms: overview

RadarCube Olap Chart is a new OLAP component written on C# 2.0, which is to bring in the Visual Analysis technology to RadarCube users. While RadarCube Grid allows working with numbers, RadarCube OlapChart allows representing your data graphically. This gives users a unique opportunity to analyze their business data visually, dealing with charts rather than numbers, which is much easier to perceive.

Now it’s easier than ever to spot new trends and discover unknown problems in your data flow. No matter what industry you’re working in: banking, sales, insurance, marketing, or manufacturing. RadarCube OlapChart will help you gain an insight into your data and make new discoveries.


You can use the component alone or with RadarCube Grid to combine the advantages of both.


Data Source

RadarCube OlapChart can use any data source be it a relational database or a multidimensional cube. You can construct your multidimensional cube from a relational database and then display it in RadarCube OlapChart. Or you can simply connect to MS Analysis Services OLAP cube to see its multidimensional data visually.


Save Reports in file

At any stage users of the component can save the report and distribute it to another person for analysis by network or email, so when the recipient gets the file he can open it and see the same OLAP slice. This is what your users expect and they will surely be able to do it.


Filters, Groups, and Sorting

With RadarCube OlapChart you can easy select what data you want to see and what you don’t. You can apply powerful filters to anything including hierarchy members, and measure values, thus leaving out the unimportant data. You can sort the data to see, for example, the top 10 values and then you can gather the rest values into a single group, so you only have what you really need.


Modificators support

Modificators are easy and powerful options of data representation. You can choose your data be shown in different colors, using different shapes and sizes, so that you can easy distinguish them in a single graph. You can simply place a dimension or a measure on a modificator’s pane and get the graph showing different values in a different manner. For example, you might place the "Shippers" dimension on Color pane and get the OlapChart showing shippers in different colors. Or you can place the "Sales" measure on Color pane to highlight the top sales. The like can be done for Shape and Size so that you can make your data perfectly distinguished.

If a measure is placed on the Color pane, its values range is mapped to the given colors range so that it’s tremendously easy to spot the top/low values.

Zooming

It’s easy to zoom into your data, so that you take a deeper look at a certain data square. Want a little bit more details? Not a big deal – just zoom into the data you’re interested in. And all is done visually, so you don’t even need to know the exact values of your data.


Look and Feel

You can set up a look and feel of the component selecting from the standard color schemes like MS Office 2003, Windows Vista, etc., or defining your own display style. In addition to the styles you can always override the standard appearance using many painting events – an unlimited ability to make up your own special appearance.


Copy to Clipboard

Select any data range in OlapChart and copy to clipboard. Then you’ll be able to paste it in an Office program for further analysis. You can also paste the OlapChart like a picture to illustrate your investigations.


Dockable Panels

One and all aspects of analysis in RadarCube OlapChart displayed in panels can be placed in its own position on the screen, docked to another panel, organized in tabs, or minimized down to header to free the screen space. Thus every user can make up its own working space. This is very useful feature especially taking into account that the locations/conditions of the panels can be saved and then restored back when needed.


Unstructured Data Analysis

The best thing about RadarCube OlapChart is that your data can be any unstructured data source. Using the Cube Editor you can create a fully functional multidimensional model for a flat dataset. You can use the fields form the dataset to create such entities like Hierarchies, Measures, Calculated Hierarchies and Measures, and Calculated Fields. You don’t have to have all data in one table – your data source can contain as many tables as you like, which can be related to each other. Also there is a special master for auto-creating the initial cube schema.


Extract the aggregate data

At any stage of your analysis you can see the underlying data for the selected values. There are two commands for that: "Show underlying data" and "Drillthrough…" The "Drill through" operation can be performed against any data source including relational databases. It shows all records from the data source that had been counted on calculating the selected points.

Printing capabilities

You can print your report to share it with others using the built-in Print Preview window. You can tune your page/printer settings before printing. Also if you feel like sharing the report through the net or by email you can easy export it to a wide range of formats including PDF, XLS, CSV, JPG, etc.

Calculated fields

If you’re working with a relational or flat data source you can add calculated fields in the tables of the schema. This allows you to avoid creating additional fields on the database level that might lead to extra traffic. This can be very useful for creating calculated measures and hierarchies.


Calculated members

Calculated members and calculated measures can be used to provide some additional information to the hierarchy structure. This may be SubTotals, Intermediate Values, Expected Values, Moving Averages, and the like. Also calculated members can be used to provide Time Intelligence functions like Year or Quarter Increase. Calculated members can be used in any application domain which requires OLAP Analysis.


Additional advantages when working with MS Analysis Cubes

OlapChart supports the following abilities of MS Analysis Cubes. KPI (Key Performance Indicators) with the ability to switch between value/goal/status/trend/weight, Time Intelligence (through the context menu on the diagram), Actions, Translations, Drillthrough, Writeback.


Development without a single line of code

You can tune every property in design time. So you can create a full visual analysis business intelligence application without having to write a single line of code. This tremendously reduces the development time sparing your expenses.


Comprehensive API

RadarCube OlapChart has a detailed and well documented API which allows you to perform any action on the chart from your code. Though the whole application can be created in design time, sometimes some functions need to be done in run time. This is where API is needed.

Related links

Visual analysis with OLAP Chart


OLAP Chart Users Guide


FAQ


Download Desktop demo application


Download MSAS demo application


Download


Documentation 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

 June 25, 2010

RadarCube WinForms Desktop 2.31.0

Changes...Download...

 

 June 25, 2010

RadarCube WinForms MSAS 2.31.0

Changes...Download...

 

Related articles
Click to subscribe

 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...

 

 May 8, 2009

Hierarchy members' attributes

Details...

 

 February 10, 2009

Initialization of the OLAP-slice view

Details...

 

 December 19, 2008

TOLAPExport control FAQ

Details...

 

 December 3, 2008

Visual analysis with RadarCube OLAP Chart

Details...

 

 November 27, 2008

Managing the Properties of the TToolbox Panel

Details...

 

 October 29, 2008

Chart for Windows Forms. Getting Started

Details...

 

 October 23, 2008

Trend lines in OLAP Chart

Details...

 

 October 9, 2008

Saving and Restoring RadarCube data

Details...

 

 August 22, 2008

OLAP Grid User's guide

Details...

 

 August 22, 2008

OLAP Chart User's guide

Details...

 

 July 22, 2008

Creating Calculated Measures and Hierarchy Members with MDX

Details...

 

 October 29, 2007

Context filtering with RadarCube (WinForms edition)

Details...

 

 August 27, 2007

RadarCube Windows Forms Desktop: How to make the cube work faster?

Details...

 

 August 24, 2007

RadarCube Windows Forms Desktop: Creating the data source

Details...

 

 June 11, 2007

Calculated fields. Using TOLAPCube.OnCalculateFields event

Details...

 

 April 9, 2007

RadarCube Windows Forms Desktop. Getting started

Details...

 

 April 3, 2007

Types of dimensions

Details...

 

 April 2, 2007

License types for ASP.NET and Windows Forms products

Details...

 

 March 20, 2007

Using RadarCube as a data source for Data-related components

Details...

 

 March 20, 2007

Star schema

Details...

 

 March 20, 2007

Snowflake schema

Details...

 

 March 19, 2007

Locating a hierarchy member

Details...

 

 March 19, 2007

How to localize RadarCube (WindowsForms and ASP.NET)

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