FastCube VCL is a tool for effective data analysis
FastCube VCL is a set of components for implementation in-memory data cube, OLAP operations, can be used for creating pivot table reports. It supports Delphi 7-XE8, C++Builder 2005-XE8, Embarcadero RAD Studio 10 - 11 and Lazarus.
Your customers will no longer need Excel-tables for multi-dimensional data analysis and cross-tab reporting!
- FastCube components can be built into the interface of host applications
- FastCube end users do not require high programming skills to build reports
- FastCube is a set of OLAP Desktop components for Delphi/C++Builder/Lazarus
- Connection to data-bases can be not only through the standard ADO or BDE components but also through any component based on TDataSet
- Instant downloading and handling of data arrays
- Ready-made templates can be built for summary tables. It is posible to prohibit users from modifying the schema
- All FastCube's settings may be accessed both programmatically and by the end user
- FastCube's data can be saved in a compact format for data exchange and data storage
Key features:
- Instant data slice creation. Data sources schemas or SQL queries
- Unlimited number of measures in a summary table
- Possible to minimize measurements as a whole as well as separate values
- Possible to control the display of totals
- Control of axis sorting (according to measurement value or data)
- Control of each level of measurement sorting (line of sorting)
- Saving of templates (schemas) and data itself for future use
Data analysis
- All basic statistical operations (count, sum, minimum, maximum, average, variance, etc.)
- Special functions (number of unique values, first value, list of unique values)
- Filters for measured values
- Calculated data (based on FastScript)
- Calculated filters for values when calculating data (based on FastScript)
Interface features
- Possible to use data of Date, Time and Row type
- Automatic component layout of date and time
- Calculated filters for numeric data by using output formatting
- Possible to put data into table columns or table rows, as well as on any level of measurements
- Numeric data display control by using output formatting
- Numeric data output as a value or as percent (in a row, column, group or table total)
- Conditional highlighting of cell value in a slices (in a range)
Data view
- Export of FastCube's slices to Excel, Word or HTML
- Copying of a highlighted range to the clipboard
- Reviewing and exporting slices cell details
- Cube's/data cube's export to XML formats : XML for Analysis, xml-msdata, ms rowset or DataPacket
- Printing by means of FastReport
- Graph construction by means of TeeChart
Amit Deb