Comparison of FastCube 2 VCL vs FMX

Features FastCube 2 VCL FastCube FMX

Data sources:

 

 

  • relational database (TDataSet)

+

+

  • saved cube

+

+

  • user data

+

+

  • append data to a cube loaded from the data source and / or from a saved cube

+

+

  • data scheme with multiple database table

+

+

Data processing:

 

 

  • type conversion during the load process

+

+

  • automatic creation of Year, Month, Day of week, etc dimensions for Date and Time fields

+

+

  • user dimensions

+

+

  • grouping of dimension members

+

+

  • simultaneous calculation of multiple measures

+

+

  • measures built on dimensions

+

+

  • calculated measures

+ (*)

+ (*)

  • sort by measure value

+

+

  • standard statistical functions for measures and totals

+

+

  • additional totals

+

+

  • instant grid transposition

+

+

  • ranks

+

+

  • Top N

+

+

 

 

 

Data filtering:

 

 

  • simultaneous filtering of several values

+

+

  • simultaneous filters of sveral fields

+

+

  • single value filter (radio filter)

+

+

  • filter with dependency on other active filters

+

+

  • central filter management for several slices

+

+

Data representation:

 

 

  • showing dimensions without active measures

+

+

  • drill-up / drill-down of dimension members

+

+

  • drill-though

+

+

  • unlimited position of "Measures" field in the grid

+

+

  • showing measure as percent by column / row

+

+

  • tree like axes representation

+

+

  • conditional data highlight (color, gradient, icon, bar-chart)

+

+

  • hide of zero colimns / rows

+

+

  • user formats for dimensions and measures

+

+

  • automatic calculation of statistical functions for selected data

+

+

  • charts

+ (**)

+ (**)

Data save/export:

 

 

  • own compact cube fromat (data + scheme + filters) using XML

+

+

  • save scheme separately from the data

+

+

  • export to Excel, HTML, ODT, XML

+

+

  • export cube to DBF

+

+

  • copy the selected cells to the clipboard

+

+

  • generate reports

+ (***)

+ (***)

Integration

 

 

  • FastScript

+

+

  • TeeChart/TAChart

+

+

  • FastReport

+

+

IDE support

Delphi 7 – XE8,

Lazarus 1.0+

Delphi XE4 - XE8

OS support

Windows 32/64 + Mac OS X (only Lazarus)

Windows 32/64 + Mac OS X

 

* - only FastScript integration

** - only TeeChart/TAChart integration

*** - only FastReport integration