FastCube VCL v2.10.4 Professional for 10.4 Sydney » Developer Team - The Best Site for Developers | Developer's Paradise

FastCube VCL v2.10.4 Professional for 10.4 Sydney

FastCube VCL v2.10.4 Professional for 10.4 Sydney
FastCube VCL v2.10.4 Professional for 10.4 Sydney

FastCube is a set of OLAP Desktop components. It supports Delphi 7, 2005, 2006/Turbo, 2007, 2009, XE, XE2, 2007, 2009, XE2, XE3, XE4, XE5, XE6, C++Builder 2007, C++ Builder 2009, C++Builder XE2 - XE6, RAD Studio 2009, Embarcadero RAD Studio 10.2 Tokyo and higher and Lazarus.

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
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
Automatic component layout of date and time
Unlimited number of measures in a summary table
Possible to put data into table columns or table rows, as well as on any level of measurements
Calculated data (based on FastScript)
Calculated filters for numeric data by using output formatting
Calculated filters for values when calculating data (based on FastScript)
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)
Possible to use data of Date, Time and Row type
Conditional highlighting of cell value in a slices (in a range)
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
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

I. Grids
1. Improvements to source data grid
This screenshot shows that the cube grid has a title zone and active row marker and also supports resizing and cell selection for clipboard operations.

2. Closer to the native look of Windows with enabled themes
This screenshot shows the improved appearance of the grid. Note that dropdowns are now consistent with other Windows controls.

3. Gradient drawing
It is now possible to use a variety of gradient fills, as well as solid fills, for various parts of the grid.

II. Data analysis
1. Optimized axis operations
Grid transposition is now instant – it does not require data recalculation (required in FastCube1)
Movement of Measures between axes and within an axis is now instant – it does not require recalculation (required in FastCube1)
Filtering does not reset the state of collapsed nodes
2. New dimension attribute for single choice (radio filter)
It is now possible to set up a dimension having a single value, if required. This screenshot shows how it appears in the grid.

3. Groups
FastCube2 can now merge the dimension items into groups. For example you can place the first two years in one group and the next two in another group. This is how it appears in the dropdown:

Note the new button with a “tree” icon near the regular expand/collapse button. When you have a group you can expand it as a regular dimension item (using the regular expand/collapse button). So you will see the aggregate values for 2 years as:

4. Totals
Totals have many new features. This screenshot shows some of them.

One measure can have more than one total
Each total has a position attribute which allows it to be placed either before items, after items or nowhere
Total can have its own aggregate function which differs from the measure aggregate function
Grand total can be collapsed (it collapses the whole axis)

5. Ranks for measures

6. Tree-like axis
The grid can now represent axes in a more compact form, as in this screenshot.

7. Data highlighting
Data highlighting has been significantly improved.

It is now possible to highlight any cell dependent on its value, in addition to the existing conditional highlighting of cells (which itself has also been improved).

8. Status panel
FastCube2 grid has a status panel which shows aggregates for a selected region.

9. Use of FastScript
Although FastCube2 uses the same scripting engine as FastCube1 we have been able to improve its use in several ways. Whereas FastCube1 restricted the script space to individual calculated measures, so preventing the sharing of code with other measures, FastCube2 now has a script space common to all calculated measures, thus making it possible to share some code between them.

10. Export
FastCube2 comes with built-in support for exporting both slice and cube data to these data formats: XLS, HTML, DBF (cube data only), ODT and XML.

III. Cube
1. Splits
FastCube2 supports these types of field splits:

- Split date and time fields into their component parts (day, month, minute, …). The parts required can be specified before the data load. Moreover, parts can be added or removed even after the data load

- References: additional fields can be loaded from reference tables based on a key field

- Custom split: a custom field can be created, based on any other field, and can be loaded in the code, using values from the base field.

2. Loading from custom storage
There is a new component, similar to the FastReport user dataset, which allows data loading from sources other than TDataSet. Field descriptions need to be written and also handlers for traversing the data store and retrieving the data.

3. Data conversion during the load process
If a data table stores numerical data in a string field it is only required to specify the result type and the data loader will automatically convert values during the load process.

4. Custom field calculation during the load process
For complex data transformations it is possible to create a user field which is evaluated during the load process. The evaluation can be performed using an embedded script or by means of an event handler.

5. Add/remove operations on fields after the load
FastCube2 allows these field operations after the data load:

Remove a field

Add custom calculated fields

Change split parts for date and time fields (see above)

Create custom splits

6. Append data to an active cube
FastCube2 allows the loading of additional data to already opened cubes.

IV. Global filter
FastCube2 has a new standalone component which allows a single data cube to simultaneously analyse data using different criteria provided by independent filters.

V. More to come
Other features that will be implemented in future FastCube2.x versions include: hierarchical dimensions, top-N, vertical text output, export to more data formats … and more.

Current version
+ Added event TfcxCustomToolbar.BeforeDialogExecute
- Fixed TDate, TTime, TDateTime fields parse for Lazarus/FPC
- Fixed array out of bounds error in TfcxSliceGrid

FastCube 2.10
+ Added expression support. Expressions allows to perform simple calculations based on measure and dimension values and functions.
+ Added methods TfcxCustomNodePopup.ExpandAll, TfcxCustomNodePopup.CollapseAll, property TfcxCustomGrid.AutoExpandPopups (true by default) which defines
whether to expand/collapse all PopupWindow automatically on show.
+ Added date split to half year.
+ Added Range.IgnoreCase property to ignore case for text compare. Added appropriate checkbox to range editor.
+ Added clear buttons to the measure editor form.
- Fixed error with loading chart for Lazarus.
- Fixed compilation for Lazarus/FPC.

Only for V.I.P
Warning! You are not allowed to view this text.
Users of Guests are not allowed to comment this publication.