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
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
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 interfaceFull 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.
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.
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.
