OLAP for WinForms

OLAP for WinForms

OLAP analysis without the cubes. Create interactive tables, charts, and reports using ComponentOne OLAP™ for WinForms. This suite of .NET 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 WinForms?

  • Five 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

See OLAP for WinForms in Action

Video Preview

Get an overview of what OLAP is, see how easy it is to use OLAP for WinForms, specifically the C1OlapPage control, and explore the Excel-like UI.

What's Inside?

OLAP for WinForms is a stand-alone product. Below are the highlights, see the full feature list for more information. For additional downloads, visit the downloads page.

  • C1OlapPanel

    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.

  • C1OlapGrid

    C1OlapGrid

    Displays OLAP 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 details for any given cell.

  • C1OlapChart

    C1OlapChart

    Displays OLAP charts. It extends the C1Chart control and provides automatic data binding to C1OlapPanel objects, automatic tooltips, chart type and palette selection.

  • C1OlapPrintDocument

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

  • C1OlapPage

    C1OlapPage

    Groups Panel, Chart, Grid, and PrintDocument in one easy-to-use tabbed interface. 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 WinForms

    OLAP for WinForms includes all Studio for WinForms controls. Add over 65 additional Windows Forms controls to your toolbox. Use these controls to customize your OLAP app. You can implement a full Ribbon UI, add Visual Studio-like docking, gauges, embedded Help and more!

Features and Highlights

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. Code-free Data Analysis

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 summarize your data by modifying the parameters. Drag-and-drop 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 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. OLAP Charts

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. Reports are a Click Away

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

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 customized 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. Data Transferrable to Excel

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. Save and Load Views

Customizable User Interface

OLAP for WinForms exposes most of the components it contains, which makes customization 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. Customizable User Interface

What's New in OLAP for WinForms?

Studio for WinForms Included

Your OLAP for WinForms subscription now includes all Studio for WinForms controls. Add over 65 additional WinForms controls to your toolbox. Use these controls to customize your OLAP app. You can implement a full Ribbon UI, add Visual Studio-like docking, gauges, embedded Help and more!

Added Support for Multiple Value Fields

OLAP for WinForms

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.

New ChartTotals Property

This property allows you to create charts that show only totals, as opposed to creating one separate series for each column in the OlapTable. Setting ChartTotals on the C1OlapChart or C1OlapPage controls can be useful in situations where the views contain too many series to visualize in a single chart.

Added Defer Updates Option to C1OlapPanel

This checkbox has the same functionality as the one in Microsoft Excel pivot tables. It suspends the automatic updates that occur while the user modifies the view definition so the user can make extensive changes more efficiently.

Added C1OlapField Style property

This property allows you to assign style properties (such as cell background and foreground) to a specific field, customizing the way the field value appears in a C1OlapGrid. This feature can be useful in views that contain multiple value fields.

Added Conditional Formatting Properties

ComponentOne OLAP for WinForms

These properties allow you to apply conditional formatting to a field, making certain values stand out when displayed on a C1OlapGrid.

Resources

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.

Pricing

Need help deciding?

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

1.800.858.2739 | 412.681.4343 sales@componentone.com

Chat with Sales