Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 24149, RadarCube OLAP library

by Radar - Soft Email: support@radar-soft.com


Extremely powerful VCL OLAP component which combines the ideas of Desktop OLAP and enterprise OLAP servers, like Microsoft Analysis Services.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 6.0  to 10.0 105 downloads
Copyright: All rights reserved


Size: 11,551,595 bytes
Updated on Wed, 04 Oct 2006 02:08:23 GMT
Originally uploaded on Tue, 03 Oct 2006 08:30:59 GMT
SHA1 Hash: AE7086A09BFD5F7181C43239F39B6FBF69356FEF
MD5 Hash: 6BE618A804E95D9D173BDCC5E6452D45

    Explore the files in this upload

Description
Extremely powerful VCL OLAP component which combines the ideas of Desktop OLAP and enterprise OLAP servers, like Microsoft Analysis Services.

Key features: Cube definition
- Support of data sources:
-- A single table or query of any database (any TDataSet successor, no BDE required);
-- Several tables or queries of any database organized into the "star" or "snowflake" schema (any TDataSet successors, no BDE required);
-- Microsoft Analysis Server 2000, 2005 or local cube files.
- Support a set of aggregation functions, such as Sum, Count, Distinct Count, Min, Max, biased or unbiased variance, median and so on. Supports custom aggregation functions.
- Support of numbers, strings and dates as measure values.
- Support of measure grouping.
- Support of all cube structure elements of Enterprise OLAP servers (dimensions, hierarchies, hierarchy levels and their relations). You can build the cube in the Desktop OLAP, and then, when increasing the size of tables, to port the Desktop cube into the MS Analysis cube, at that the logical structure of the cube will remain unchanged.
- Support of parent-child, multilevel and mixed hierarchies;
- An ability to create calculated measures, dimensions, hierarchies and hierarchy levels based on the data both as the fact table rows and all dimension tables rows related to it with the foreign keys.
- An ability to create additional calculated measures, using both the information from the fact table and values of the aggregated cube cells.
- Support of calculated members of dimensions or hierarchies.
- Support of dimension or hierarchy attributes which store additional information about dimension or hierarchy members.

Key features: Data visualization

- Unicode support.
- Support of "Undo" and "Redo" actions during the OLAP analysis.
- Support of saving and restoring the current OLAP slice.
- Support of sorting on any level of hierarchy or dimension separately. Ability of overriding any sorting method.
- Support of sorting based on any column value in the OLAP grid.
- Support of filtering any set of hierarchy members with or without applying these filters in the OLAP calculations.
- Support of the auto filtering of the hierarchy members depending on their values in the grid. An ability for selection some major/minor members, either according to their rank or on the Pareto principle.
- An ability to display in the grid not only the values of the measures but a percent value regarding totals, subtotals, or grand totals. An ability to create your own context-sensitive rules on measure display (for example, a cumulative sum of measure values for time dimensions, and just its value for all other cases).
- The auto image drawing in any grid cell, the auto picture positioning in a cell, depending on the parameters assigned by a programmer.
- Support of the custom drawing on the grid cells.
- Support of the custom popup menus in the grid.
- Support of the drag-n-drop of measures or hierarchy members within the grid.
- Auto wrapping of the cell contents depending on its width. Auto sizing of the column width with auto wrapping for the very "long" cells of the grid.
- An ability to edit OLAP data directly in the grid ("writeback" support).
- Allows to display the current slice as a diagram (any TChart successor). Support of Drill-down actions in the chart. The source code of the charting component comes for free.
- Allows to copy the selected grid area into the clipboard. Support all common office clipboard formats.
- Allows to export grid data to many formats: MS Excel (using OLE or directly to XLS-file), HTML, PDF, WMF, RTF, TXT, BMP, XML. Exports to the RaveReport, ReportBuilder, FastReport are coming soon. Also supports direct drawing on printer Canvas.
- Easy localization. It is possible to localize the evaluation version as well.

For more information, see http://www.radar-soft.com

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC03