OLAP ModelKit pivot table is a kind of an interactive table designed to be used for statistical analysis of multiple data. The rows and columns of such interactive table are based on the data taken from several columns of an initial table or another data source. The information in pivot table cells is the data aggregated by the corresponding row and column. The formation of a pivot table presupposes the execution of the following operations:
Data grouping
Calculation of sub-group subtotals
Calculation of totals
Product Features:
Using Data Sources:
ADO.NET objects;
User-defined classes (Business Objects), IList, and IListSource;
Nested data sources.
Data Processing:
Dynamic data sorting, grouping and filtering by assigned or arbitrary conditions;
A wide range of aggregate functions such as standard deviation, estimate of standard deviation, variance, estimate of variance, median, skewness, and kurtosis, etc;
A built-in expression language allows the applying of arithmetic, logical, string operations and formatting, mathematical, strings processing, date processing functions;
Visual Studio smart tags functionality provides quick access to common component properties that can be edited on small panels appearing when a component is selected.
Data Visualization:
Support for XP styles, as well as office and smooth styles, custom drawing, and custom format;
Data representation with the help of native charting component and any third-party data visualization components;
Graphic and percentage data output;
Ability to preview and print necessary reports at any time;
HTML, Excel, and PDF Export;
Interactive grid for preview with drag-and-drop support.
Customization:
Ability to selectively change the cell style set in the style sheet for the displayed pivot table;
Ability to draw either one or another table element manually;
Ability to make custom functions and variables available in the elements expressions;
Ability to set customs rules for groupings;
Ability to assign custom aggregate functions.
OLAP ModelKit is available in the following editions:
Windows Forms Edition - designed for Windows Forms applications. It is an ideal solution for those developers who are engaged in the creation of highly effective decision support systems which provide dynamic data analysis and interactive data processing.
Professional Edition - designed for Windows Forms applications. The OLAP ModelKit professional edition comes with full source code. It is a powerful solution for .NET developers wishing to have total control over created applications.
Загрузить Trial/Demo Загружено: 377 |