- FlexPivot for WinForms Overview
- Introduction to FlexPivot
- Key Features
- FlexPivot Architecture
- Upgrading from Old PivotPage to New PivotPage
- Adding Data to FlexPivot Application
- Design Time Support through Smart Tag
- Quick Start: FlexPivot for WinForms
- Using FlexPivotPage ToolStrip
- Data Blending Features
- FlexPivot Cube
- Export
- Task-Based Help
- Walkthrough
- DataEngine Overview
- FlexPivotSlicer Overview
Using C1DataEngine
The C1DataEngine can be used independently for data blending and analysis by executing queries. A query takes data from base tables or from other queries, performs operations on that data such as joining multiple tables, filtering, calculations, grouping, aggregation, and saves results as a new table in the DataEngine.
Query results can then be used in various ways including but not limited to:
- Showing results in a grid (for example, aggregation results, for analysis)
- Feeding results to FlexPivot for analysis (for example, joining several tables so FlexPivot can analyze the joined table)
- Further programmatically transform the results to perform any batch tasks on data
The unique advantage of using DataEngine queries compared with other programming techniques is their exceptional performance. A query can often process millions of records in a second or less. In addition, DataEngine queries support custom operations, which allows you to create user-specific queries for both simple and group operations (aggregation).
type=note
Refer to the product sample DataEngineQueries sample at the following location in your system to see the C1DataEngine in full action.
C:\...\Documents\ComponentOne Samples\WinForms\C1FlexPivot\CS or VB\DataEngineQueries.