Features
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.
Intuitive User Interface
The C1OlapPage control groups all the controls (C1OlapPanel, C1OlapGrid, C1OlapChart, and C1OlapPrintDocument) in one easy-to-use tabbed interface. The UI is similar to Microsoft Excel.
OLAP Grid View
The C1OlapGrid control is used to display 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.
Preview Underlying Records
You can see the underlying records behind each cell in the OLAP grid by right-clicking the cell with your mouse pointer.
OLAP Chart View
The C1OlapChart control is used to display OLAP charts. It extends the C1Chart control and provides automatic data binding to C1OlapPanel objects, automatic tooltips, chart type, and palette selection.
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.
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.
Targeted Data with 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.
Supports Formatting
Select from decimal, currency, and percentage formats; or create custom format strings.
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.
Supports Predefined 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 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.