Click here to Skip to main content
13,449,448 members (42,912 online)
Click here to Skip to main content
Add your own
alternative version


2 bookmarked
Posted 9 Feb 2011

Analyzing Data Shouldn’t be Rocket Science: OLAP for Silverlight

, 9 Feb 2011
Learn how to perform OLAP analysis on plain data (no need to setup SQL cubes on your server). With ComponentOne OLAP™ for Silverlight Beta you have the tools to create interactive tables, charts, and reports. Drag-and-drop views give you real-time information, insights, and results in seconds.

Editorial Note

This article is in the Product Showcase section for our sponsors at CodeProject. These articles are intended to provide you with information on products and services that we consider useful and of value to developers.

So, what exactly are OLAP tools? OLAP means "online analytical processing". It refers to technologies that enable the dynamic visualization and analysis of data. These tools allow users to redefine these grouping criteria dynamically (on-line), making it easy to perform ad-hoc analysis on the data and discover hidden patterns.

Rather than summarizing data in spreadsheets, which can be tedious, repetitive, and error-prone; add OLAP tools your business solution. OLAP tools help discover new trends and drive efficiency with faster data analysis. For example, consider the following table:

Oct 2007Product ANorth12
Oct 2007Product BNorth15
Oct 2007Product CSouth4
Oct 2007Product ASouth3
Nov 2007Product ASouth6
Nov 2007Product CNorth8
Nov 2007Product ANorth10
Nov 2007Product BNorth3

Now suppose you were asked to analyze this data and answer questions such as: Are sales going up or down? Which products are most popular in each region? In order to answer these simple questions, you would have to summarize the data to obtain tables such as this:

Product A22931
Product B18018
Product C8412

Here, each cell represents a calculation of several cells from the original data source, where one or more value fields are summarized or grouped. This can be done in a spreadsheet program like Microsoft Excel, but the work is tedious, repetitive, and error-prone. If you wrote a custom application you would have to spend a lot of time maintaining new views to answer an unlimited number of questions the user may have.

OLAP tools allow users to define the views they want interactively, in ad-hoc fashion. They can use pre-defined views or create and save new ones. Any changes to the underlying data are reflected automatically in the views, and users can create and share reports showing these views. In short, OLAP is a tool that provides flexible and efficient data analysis.

OLAP for Silverlight

ComponentOne has recently unveiled a new suite of Silverlight UI controls which provide analytical processing features similar to those found in Microsoft Excel Pivot Tables and Pivot Charts. ComponentOne OLAP for Silverlight takes raw data in any format and provides an easy-to-use interface so users can quickly and intuitively create summaries that display the data in different ways, uncovering trends and providing valuable insights interactively. As the user modifies the way in which he wants to see the data, OLAP for Silverlight instantly provides pivot grids and charts (and soon reporting) that can be saved and exported. With drag-and-drop views, you get real-time information, insights, and results in seconds.


OLAP for Silverlight includes four key controls:

  • The C1OlapPanel is the core of the product. It takes raw data as input, and its OLAP engine provides custom views summarizing the data according to criteria provided by the user. The C1OlapPanel also provides the familiar, Excel-like drag and drop interface that allows users to check which fields from their data source they want to summarize in the row, column and values field boxes.
  • The C1OlapGrid control is used to display OLAP pivot tables. It extends the C1FlexGrid control and provides automatic data binding to C1OlapPanel objects, grouped row and column headers, as well as custom behaviors for resizing columns, copying data to the clipboard, and showing underlying details for any given cell.
  • The C1OlapChart provides charts for the OLAP data. It extends the C1Chart control and provides automatic tooltips, five different chart types and 22 palette selections.


  • The C1OlapPage control provides the complete OLAP user interface by combining all of the C1Olap controls, plus a menu and table displaying raw data. The menu is customizable and includes built-in commands for the following: opening and saving views, undo and redo actions, grid settings, chart settings, and reporting options. To create the simplest OLAP application, just drop the C1OlapPage control on the page and connect to a data source. It's that easy. Or you can use the separate controls to build your own UI. For instance, you can hide the C1OlapPanel portion from end-users and give them a preset collection of views to see for more efficient usage.

Features, Features, and More Features

OLAP for Silverlight was designed to give you the custom views you need to analyze your data. This section showcases some of the popular features.

Subtotals and Grand Totals

You can summarize multiple fields across rows and down columns. When you do this, the C1OlapGrid will automatically calculate grand totals and subtotals for each slice of your data. Users can collapse groups displaying only the subtotal value.



The C1OlapPage has a new Report menu item allowing users to print or open the Document Options window. Directly print the C1OlapGrid and/or C1OlapChart in a single report. Users can customize scaling, page margins, headers and footers, and insert time stamps, page counts and a title for the report.


Plus More

  • Filtering: Filter the data pool on multiple fields.
  • Data Formatting: Format values for dates, currencies, percentages, etc.
  • Built-in Conditional Formatting: Highlight highs and lows
  • Totals and Aggregates: Calculate not just sums but also counts, averages and more!
  • Date/Time Grouping: Automatically group DateTime values per years, months, days, etc.
  • Undo/Redo History: Built-in functionality for the C1OlapPage control.
  • Save/Load Views: Persist views in local storage.

Download Free Trial

This first official release of OLAP for Silverlight is scheduled for mid-March, 2011. You can download the Beta now; it’s completely free to use and try. Download the controls which support Silverlight 4.

To learn more, visit the OLAP for Silverlight product page. Here you'll find PDF documentation, the forum link, and more feature screenshots.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Greg Lutz
Product Manager ComponentOne
United States United States
I am the ComponentOne product manager for Studio for WPF, Silverlight, Windows Phone and WinRT XAML. You'll find me blogging about these awesome XAML technologies and speaking around the country at various code camps, techfests and tradeshows.

You may also be interested in...


Comments and Discussions

Bugcan't print charts in correct scale Pin
John_C29-Feb-12 0:35
memberJohn_C29-Feb-12 0:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180318.3 | Last Updated 9 Feb 2011
Article Copyright 2011 by Greg Lutz
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid