OLAP for WinForms

Easy to Use Pivot Grids and Charts for Instant Data Analysis

Discover new trends and drive efficiency with essential data analysis and charting. Rather than summarising data in spreadsheets, which can be tedious, repetitive, and error-prone; make ComponentOne OLAP for WinForms your business solution. These controls provides analytical processing features similar to those found in Microsoft Excel Pivot Tables and Pivot Charts. With drag-and-drop views, you get real-time information, insights, and results in seconds. Only available as part of Studio for WinForms, Studio Enterprise or Ultimate.

OLAP for WinForms Features and Highlights

Save Time and Deliver Endless Views for Users

Deliver endless views to end users without writing or re-writing code. Typically when a user needs a new report they ask the developer to make one. With an OLAP solution they can build the report themselves and save it for future runs of the application. ComponentOne OLAP saves developers time while giving more power to the end user.

Code-free Data Analysis

To create the simplest OLAP
application, just create a new Windows Forms application,
drop the C1OlapPage control on the form, and connect to a
database. It's that easy. Run your application and go.

Drag-and-drop Views

Easily create data views by
dragging a field into the list. This will give you a summary
of your data. You can also summarise your data by modifying
the parameters.

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 Charts

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.

Reports are a Click Away

Effortlessly print and email
reports. The C1OlapPrintDocument component is used to create
reports based on OLAP views. It extends the PrintDocument
class and provides properties that allow you to specify
content and formatting for showing OLAP grids, charts, and
the raw data used to create the report. There's a convenient
"Report" button that previews your data in a built-in
report. You can change the page orientation, and print the
report or export to PDF.

Filtering

To narrow down the data
analysis, 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.

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 cell in the OLAP grid by right-clicking
the cell with your mouse pointer.

Data Transferrable to Excel

You may want to copy some or
all the data to Excel so you can perform additional data
analysis including regressions, create customised
reports by annotating the data, or adding custom charts.
The C1OlapGrid control supports the clipboard by
default, so you can simply select the data you are
interested in, press CTRL+C to copy the data, and then
paste it directly into an Excel sheet. The row and
column headers are included with the data.

Save and 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 WinForms exposes most
of the components it contains, which makes customisation
straightforward. You can add, remove or change the elements
from the ToolStrip, from the TabControl, and show status
messages using the LabelStatus property. You can also add
other elements to the page in addition to the C1OlapPage.