In This Topic
Below mentioned are some of the key features of FlexPivot that would help developers realize their complex data analysis needs.
- Multiple Value Fields
FlexPivot supports multiple fields in the Values list. Users can drag multiple fields into the Values list and see the results in grid and chart. See the topic Adding Multiple Fields in Values List to know more about this.
- Enhanced and Powerful Data Engine
FlexPivot is built with a new, powerful data engine that stores data in memory-mapped files using column-oriented technology. The C1DataEngine offers high-speed processing of very large datasets that makes it possible to reach high performance of up to hundreds of millions records in a fraction of a second. The engine also supports query operations such as Aggregation, Joins, Grouping, Filter, Unary/Binary operations, etc. See Using C1DataEngine section for an overview of query related operations.
- Enhanced User Interface
FlexPivot comes with an enhanced, Excel-like user interface (UI) offering modern color schemes in toolbar, drop-down menus, tables and charts.
- Multiple Theme Support
FlexPivot allows developers in choosing a theme that suits their application requirements. To support multiple themes, FlexPivot includes C1ThemeController support.
- Plot Information on Grid View
FlexPivot provides the FlexPivotGrid control to display data in a grid-like view. The C1FlexPivotGrid class library enables you to customize your FlexPivot application. See the FlexPivot Architecture section for an overview of the FlexPivotGrid control.
- Choose how to display the information at runtime
Use the FlexPivotPanel to determine which fields of your data source should be used to display data and how. Drag fields between the lower areas of the FlexPivotPanel to create a filter, column headers, row headers, or get the sum of values from a column or row. For more information, see FlexPivotPanel section.
- Implements C1 Controls for Customization
FlexPivot comes with C1 control support (such as check boxes, tabs and toolstrip) instead of standard Microsoft controls. This way, the FlexPivot product provides users with complete flexibility in customizing the look and feel of their application according as per their requirements.
- Query Operation Support
FlexPivot supports query operations including aggregation, joins, filters, ranges, sorting, grouping, unary and binary operations, calculated fields, projections and grouping, etc.
- Display KPI in OLAP
FlexPivot can be used to visualize the Status, Trend and Goal measures of KPI contained in an OLAP cube. See the topic Display KPI in OLAP to know more about this.
- Top N Filtering
FlexPivot can be used to filter top N and bottom N elements in a grid or chart. Refer this topic to explore more about Top N Filtering.
FlexPivot controls fully support all the features on a 64-bit OS machine.