Analysis VCL

High-speed OLAP cube engine for fast big data analysis and generation of tables with graphs and diagrams

Analysis VCL instantly processes arrays and transforms database information into compact and generalized reports. Integrate the OLAP library into your project, prepare the data (or several sets) that your users will need for analysis, and get BI in your application.

Cross table

Cross table

The Analysis VCL consists of a cross-table—an interactive tool for data presentation and analysis. In the upper and left parts of the table, there are multi-level headers filled with the values of the dimensions. The central part of the table displays the values of the indicators. The cross-table consists of many areas: the header of the cross-table, the area of the filter fields, the vertical and horizontal headers of the dimensions, the vertical and horizontal header of the cross-table, the data area, the field list, the list of Top-N filters, the area of aggregate calculations for the selected cells, and scale control.

Sorting

Sorting

The data in the cross-table is displayed in a strictly sorted order, regardless of their original order in the source data. The sorting order can be either ascending or descending. For numeric and time-based values, the order means their natural order of succession. For string values, the alphabetical order of succession is applied.

Each dimension of the cross-table can have its sorting order of values. By default, ascending sorting is applied. You can change the sorting order of a dimension by double-clicking on the dimension header or selecting an option in the context menu.

Features and Benefits

Embedding in the interface
Full customization and integration into the interface of your business application.
Data sources
Connection to databases takes place not only through standard ADO and BDE components but also through any built based on TDataSet.
Visual results
To create graphs and charts based on table slices, you can use TeeChart (both from RAD Studio and the commercial edition of TeeChart Pro).
Global filter
Use one data cube for synchronous analysis based on various criteria, built on independent filters.
Graphics core
GDI is used to create graphic elements, render text, and manage graphics.
Source code
This set of components includes source codes. Maximum convenience for companies wishing to adapt the code to their needs.

Conditional data selection

The cross-table allows you to set a special display style for certain indicator values. For example, you can highlight data that falls within a certain range or goes beyond its boundaries. The highlighting rule allows you to process indicator values as values, text, dates, or NULL. Depending on the type of processing, you can apply different condition options. For processing values, you can use "greater than" and "less than" operations, and for text processing, substring inclusion or exclusion operations are available.

The display style of the condition is set in the editor. You can choose the background fill variant, text color, and text style. For a solid fill, it is enough to set only the "Fill Color 1", and for gradient fills, you also need to specify the "Fill Color 2". In addition to conditional cell highlighting, you can apply one of four types of highlighting to all values. In this case, each cell will be highlighted depending on its value.

Conditional data selection

Data presentation

You can export any slices from the OLAP cube to the following formats: Excel and Word (XLS, XML, XML for Analysis, xml-msdata, ms rowset, DataPacket compatible with Embarcadero's ClientDataset), as well as HTML (table and Excel Worksheet HTML). Flexible component settings will allow you to choose features such as: repeating axis values for each row/column, selecting the output file to display the grid, and much more.

Data presentation

FastScript formulas

Analysis VCL uses FastScript to perform non-standard calculations. Using scripts, you can calculate indicators and filters. You can set data processing after or simultaneously with standard indicators.

For indicators, you can set filters specified by the script. This filter is used if it is necessary to calculate indicators not for all rows of the original data set, but only for selected ones. The calculation filter can be applied to both measures based on standard aggregate functions and calculated measures.

FastScript formulas

Ultimate VCL

This set of components is part of the Ultimate solution, with which you can create your business projects on all familiar VCL, Lazarus, and FMX platforms. Additionally, the package includes FastScript for fast processing of scripts of any complexity, as well as the visual SQL query builder FastQueryBuilder. In addition, you will have access to client-server reporting tools on VCL and Lazarus.

Delivery options

Ultimate
from $1,299

Features

FastReport Engine
VCL components
FMX components
Lazarus components
OLAP features
OLAP aggregation functions
Data connections
Reporting features
Report objects
Barcodes
Charts
Printing
Export in formats
Source Code
Convertors from
Transports
Plugin FastConverter .FP3
Buy
Optimum VCL
from $899

Features

FastReport Engine
VCL components
FMX components
Lazarus components
OLAP features
OLAP aggregation functions
Data connections
Reporting features
Report objects
Barcodes
Charts
Printing
Export in formats
Source Code
Convertors from
Transports
Plugin FastConverter .FP3
Buy
Reporting VCL
from $499

Features

FastReport Engine
VCL components
FMX components
Lazarus components
OLAP features
OLAP aggregation functions
Data connections
Reporting features
Report objects
Barcodes
Charts
Printing
Export in formats
Source Code
Convertors from
Transports
Plugin FastConverter .FP3
Buy
Analysis VCL
from $399

Features

FastReport Engine
VCL components
FMX components
Lazarus components
OLAP features
OLAP aggregation functions
Data connections
Reporting features
Report objects
Barcodes
Charts
Printing
Export in formats
Source Code
Convertors from
Transports
Plugin FastConverter .FP3
Buy
Fast Reports
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314

© 1998-2024 Fast Reports Inc.
Trustpilot