Part of Ultimate OLAP for Silverlight

OLAP for Silverlight

OLAP analysis without the cubes. Create interactive tables, charts, and reports using ComponentOne OLAP™ for Silverlight. This suite of Silverlight controls provides analytical processing features similar to those found in Microsoft Excel Pivot Tables and Pivot Charts. Drag-and-drop views give you real-time information, insights, and results in seconds.

Why use OLAP for Silverlight?

  • Four unique controls you can embed into your own app thus delivering the ad-hoc analysis and your app all in one solution
  • 99% development time savings; you only need to connect to a data source
  • Zero code maintenance; analyze your data without writing or re-writing code
  • Endless data views for your end-users

What's Inside OLAP for Silverlight?

OLAP for Silverlight includes four unique controls for developing your ad-hoc business analysis apps. Plus, get over 60 other UI controls with Studio for Silverlight. Below are the highlights, see the full feature list for more information.

  • C1OlapPanel


    Provides the raw data for the analysis using a DataSource property as well as a drag-and-drop interface for defining custom views of the data. The panel is visually similar to the Microsoft Excel Pivot Table UI. See the full feature list for details on supported functionality.

  • C1OlapGrid


    Extends the C1FlexGrid control and provides pivot tables with 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 details for any given cell.

  • C1OlapChart


    Extends the C1Chart control and provides automatic data binding to C1OlapPanel objects, automatic tooltips, 5 chart types and palette selection.

  • C1OlapPage


    Groups the panel, chart, and grid in one easy-to-use tabbed interface with a complete menu. Just drop the page control and set the data source. You can develop your own custom interface using only the basic controls instead of the C1OlapPage.

  • Studio for Silverlight

    OLAP for Silverlight also includes the entire Studio for Silverlight control suite. Add over 60 UI components to your toolbox and take your applications to the next level. With advanced data visualization, editing, layout and navigation controls, Studio for Silverlight will make your OLAP apps shine.

Features and Highlights

Code-free Data Analysis

To create the simplest OLAP application, just create an empty Silverlight application, drop the C1OlapPage control on the page, and connect to a data source. It’s that easy. Run your application and go. Code-free Data Analysis

Dynamic Views

Dynamically create data views by dragging fields into the row, column and value lists. This will give you a summary of your data. You can also summarize your data by modifying the filters. The UI is similar to Microsoft Excel. Dynamic Views

Subtotals and Grand Totals

The OLAP Grid automatically calculates grand totals for each slice of your data. If you measure multiple dimensions the OLAP Grid can also calculate subtotals with collapsible headers. Subtotals and Grand Totals

Multiple Value Fields

You may add as many value fields to a view as you want. This enables users to aggregate totals for multiple measures from the data set. For example, create a view that compares both total revenue and cost side-by-side. Multiple Value Fields

Conditional Formatting

Simple properties make it easy to apply conditional formatting to the C1OlapGrid. Conditional format thresholds may be specified as absolute values or as percentages. Make certain values stand out to draw attention. For example, apply a unique style for values in the top 10% and another style for values in the bottom 10%. Conditional Formatting

OLAP Charting

The C1OlapChart control is used to display OLAP charts. It supports five different chart types (Bar, Column, Area, Line and Scatter), automatic tooltips, stacking and palette selection. OLAP Charting

Print Reports

Directly print the C1OlapGrid and C1OlapChart together 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. Print Reports


To narrow down the data pool, use the filter feature. You can filter on multiple fields. Just right-click on the field you would like to filter and select Field Settings. From the Field Settings dialog box, you can create your custom text filter. No coding required. The filter settings get saved with the OLAP view so they are there the next time you load the view. Filtering

Totals and Aggregates

Choose from many different aggregations for the totals (Value field). Choose from Sum, Count, Average, Maximum, Minimum, First, Last, Variance, Standard Deviation, and Variance Population. Totals and Aggregates

Data Formatting

Format the value field in the Field Settings dialog. Select from decimal, currency, and percentage formats; or create custom format strings. Data Formatting

View Underlying Records

You can see the underlying records behind each aggregated value in the OLAP grid by double-clicking any cell. View Underlying Records

Undo/Redo History Support

As you make changes to the OLAP view you can undo and redo steps. Undo/Redo History Support

Save/Load Views

ReadXml and WriteXml methods allow you to persist views to files and streams. These methods make it very easy to implement predefined views and expose them in a menu so your end-user can select them. Save/Load Views

Customizable User Interface

OLAP for Silverlight exposes most of the components it contains, which makes customization straightforward. You can add, remove or change the elements from the Menu, the TabControl, and you can also add other elements to the page in addition to the C1OlapPanel, C1OlapGrid and C1OlapChart. Customizable User Interface

Over 50 Additional UI Components

ComponentOne OLAP™ for Silverlight includes Studio for Silverlight. Complete your application with rich editors, layout controls, advanced navigation and more. Over 50 Additional UI Components


Whether you are a customer or just trying us out, we stand behind you. Valuable learning resources such as samples, videos, and forums are free and just a click away.

Ready to start your 30-day, risk-free trial?

Includes free technical support.

Ready to buy?

All licenses are developer-based and there are no limits on the distribution of applications–unlimited, royalty-free, run-time distribution.


Need help deciding?

Chat with sales, call or email. We're here to answer all your questions.

1.800.858.2739 | 412.681.4343

Chat with Sales