FastCube VCL

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 - 10.4 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

New FastCube VCL Features   Choose edition