ComponentOne OLAP for Silverlight provides OLAP analysis without the cubes. You can create interactive tables, charts and reports with functionality similar to those found in Excel pivot tables and pivot charts. And with drag and drop views you can get real-time information, insights and results in seconds.

ComponentOne OLAP for Silverlight includes:

• 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.
• C1OlapGrid - Displays OLAP tables. It extends the C1FlexGrid control and provides automatic data binding to C1OlapPanel objects and more.
• C1OlapChart - Displays OLAP charts. It extends the C1Chart control and provides automatic data binding to C1OlapPanel objects and more.
• C1OlapPage - Groups Panel, Chart, and the Grid in one easy-to-use tabbed interface. Just drop the page control and set the data source.

In addition OLAP for Silverlight includes Studio for Silverlight. Complete your application with rich editors, layout controls, advanced navigation and more.

Features

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.

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 summarise your data by modifying the filters. The UI is similar to Microsoft Excel.

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.

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.

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

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.

Print Reports

Directly print the C1OlapGrid and C1OlapChart together in a single report. Users can customise scaling, page margins, headers and footers, and insert time stamps, page counts and a title for the report.

Filtering

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.

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.

Data Formatting

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

View Underlying Records

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

Undo/Redo History Support

As you make changes to the OLAP view you can undo and redo steps.

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.

Customisable User Interface

OLAP for Silverlight exposes most of the components it contains, which makes customisation 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.

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.

Subscriptions

ComponentOne Standard Support

ComponentOne Standard Support is a one year subscription included in the purchase of the product and can be renewed once the year's subscription is up. Standard support provides:

• Product updates - for the period of your subscription you will receive any updates for the products you hold licenses for
• Email support - submit an incident through email
• Online support - submit an incident through the Web and receive an email response
• Knowledgebase access - provides access to key documents on all products
• Forum access - provide comments and share knowledge in the ComponentOne forums
• Email project for analysis

ComponentOne Platinum Support

ComponentOne Platinum Support is an optional purchase. Platinum support provides:

• 24 hour FastTrack response (excludes weekends and US holidays) - submit issues to ComponentOne and ComponentOne will attempt to provide a resolution within 24 hours
• Phone support - talk directly to ComponentOne to get your issues solved
• Pre-release access to software - get access to ComponentOne beta software releases

Product Licensing

The product is licensed per-developer for up to three machines with the exception of SharePoint products which are licensed per server. Licenses may be transferred from one developer to another or from one server to another. The original copy must be removed completely from the original developer machine or from the original server. Applications built using the components may be distributed royalty-free.

A licence includes one year of free upgrades including bug fixes and new features. Products may continue to be used after one year but updates will not be available unless the subscription is renewed. Source code is not included with products unless explicitly stated in the product feature list. Exceptions are the source for the Report Designer application which is included in the ComponentOne Studio Reporting Edition and the source code included with the Studio Source Code Edition products.

System requirements:

System requirements for ComponentOne OLAP for Silverlight include the following:

• Microsoft Silverlight 4.0
• Microsoft Visual Studio 2010