FastCube

FastCube is the solution allowing without excess costs of forces and time to analyze data, to receive pivot tables (cuts of data), to construct reports and diagrams. This means of online analytical processing of data bulks.

2019: FastCube.Net of version 2019.2

On February 22, 2019 the library of operational data analysis FastCube.Net of version 2019.2 is provided. FastCube is intended for the desktop OLAP analysis. Components of data access, processing and storage of structured data and also visualization of already processed information are a part of FastCube.Net.

The main component of library — the crosstable allows to perform filtering (filtering), sorting (sorting), deepening (drill-down), generalization (drill-up), detailing (drill-through), turn of data (pivoting) and many other things.

In version 2019.2:

• BeforeProgress event for grid is added;
• Elements are added to the CubeGrid context menu;
• The CubeGrid.FilterManager property is added
• The classes UniqueValuesFieldFilterDataProvider, CubeFilterPopup and FilterOrderedRecordSet are added
• Export to Excel of 2007 big tables is considerably accelerated, memory consumption is reduced;
• Cleaning of a cut resets heading of the Indicators field;
• Localization of a form of progress is corrected;
• Localization errors are corrected.

About the Product

FastCube.Net supports: Net Framework 4. Belongs to the class Desktop OLAP. It is compatible to FastCube 2 VCL.

The FastCube components are built in the interface of the created applications. FastCube use by the end user does not require qualification of the programmer. FastCube is delivered in the form of a set of components for the Visual Studio.

Connection to databases is performed not only through conventional components of access of data. There is a possibility of creation of ready templates (schemes) for pivot tables. There is a possibility of prohibition of change of the scheme by the user.

All settings can be made both manually by the user in run-time, and programmatically. Data and settings can be saved in the compact format compatible to FastCube VCL 2.

Key features

• Creation of a cut of data "on the fly". It is enough to specify data source (the table or the SQL query)
• Unlimited number of indicators in the pivot table
• Supports the main statistical transactions for aggregation of data (the counter, the amount, at least, a maximum, an average, dispersion, an average weighed, etc.)
• Additional statistical transactions: list of values, the first/last met
• Possibility of measure calculation taking into account uniqueness of a field (basic or other)
• Possibility of creation of indicators (except traditional numerical) type Date, Time and the Line
• Filters for measurements on the basis of unique values
• The dependent filters (considering the current data set)
• Automatic hierarchical breakdown of dates and time
• Possibility of arrangement of indicators in columns or in lines and also at any level of measurements
• The calculated indicators and filters
• Management of display of values using an output format.
• Output of indicators in the form of value, percent or a rank
• Conditional (entry into range) and unconditional (histogram, gradient...) selection of data
• Treelike (compact) and standard display of axes of the pivot table
• Turning/deployment of values, groups or measurements entirely
• Formation of the user groups
• Management of display and provision of results, additional results
• Management of sorting (on value of measurement or an indicator, the direction of sorting)
• Selection of the first N-values
• Preserving of templates (schemes) and data for the subsequent use
• Export to ODS, XLS XML HTML , etc. formats, work with a clipboard
• Viewing and export of detailing of cells of a cut
• Printing using FastReport Net
• Creation of diagrams using MsChart

2010: FastCube 1.8

For October, 2010 FastCube is the program analysis data and constructions of reports. In version 1.8 support is implemented Embarcadero RAD Studio XE. The RunScriptInDesigner property is added to TfrcCube.

Users of this version will be able to perform search in the first character in the revealing lists (the list of fields and the list of unique values). Besides, in FastCube 1.8 support of TeeChart 2010 is provided, drawing of illumination at the included XP styles is optimized, work with line indicators like UnicodeString. The defect when moving of the calculated indicator to area of the list of fields was corrected.