Radar-Soft, L.L.C. - Software Products

RadarCube Windows Forms Desktop OLAP

RadarCube is a powerful NET Windows Forms OLAP control entirely authored in C# 2.0. Having an excellent performance it allows to work with databases with millions records. RadarCube has a splendid user interface and powerful API designed to create true OLAP applications. Key features: - One or several tables/views /stored procedures described in a DataSet object. - A set of standard aggregation functions like Sum, Count, Distinct Count, Min, Max so on. Custom aggregation functions. - Hierarchies of three types: -- Parent-child hierarchies (both balanced and unbalanced); -- Multilevel hierarchies (both regular and ragged); -- Mixed from all previous types. - An ability to create calculated measures, dimensions, hierarchies and hierarchy levels. - Calculated members of hierarchies. - Auto conversion of the DateTime fields into multilevel hierarchies. Any conversion algorithms. - Unicode support. - Several types of drilling down: to the nearest successor, to the next level, to the next hierarchy. - Hierarchy members grouping (including multilevel and parent-child hierarchies). - Separate sorting of different hierarchy levels. - Ascending or descending sorting based on the column values in the grid. - Filtering of hierarchy members with or without applying these filters to the OLAP calculations. - Ability to place pictures into grid cells, and automatically position picture and text within the cell, depending on the parameters defined by a programmer. - A complete control over the cells contents, ability of custom drawing within the cells. - Ability to change the context menus in the grid. - Auto sizing of the cell depending on their contents. - The IListSource interface implementation which allows OLAP Grid to be used as the data source for the components working with data (for example, Chart or export). - Allows exporting grid data to MS Excel, BMP, TXT, HTML, JPG, GIF, PDF, and so on. - An ability to edit OLAP data.

Keywords: olap pivot windows forms bi business intelligence owc cube crosstab contact name stereo mix

HierCube OLAP library for VCL

HierCube Library is a set of VCL components designed to create fast, handy, and powerful OLAP-applications in different IDE. The library has its own OLAP-engine made using MOLAP-principle, and allows you making OLAP-views "on the fly", not wasting time and memory for intermediate calculations. Calculations performance doesn''t depend on the cube capacity and the depth of hierarchical dimensions. For example, one million records fact table is processed for less than a second. No OLAP server required. Main features: - 100% Unicode support - "Star" or "Snowflake" schemas support - Hierarchical dimensions of any nesting level, defined with "Parent-Child" relations - Several flat dimensions grouped into a hierarchical one (composite or multilevel dimension). - Dimension filters: allows to exclude any members from the current OLAP-view - Dimension groups: allows to gather any members into a single group during. - History of OLAP-views: allows "undo", "redo" operations during OLAP-analysis - Three types of calculated summaries: see data that you really want. - Different aggregate functions and sub-functions: using different functions to display cube data. Sub-functions display the final result in different ways like displaying % value instead of the function value. - Supersaturated cubes: no need to group records in the SQL-queries. - Saving/Restoring: allows to save all cube and/or all OLAP-views in a disk file and restore it back later on. - Fact table editing: allows to use HierCube library to create cross tabulated tables. - Displaying current OLAP-slice in a diagram. - Dimension attributes: displaying additional information given from the dimension table from any member. - No standard problems of "sparse" multidimensional cubes like "database explosion" or "cube sparsity". - Vast export functionality: copying to Clipboard, exporting in the most common formats: PDF, RTF, HTML, XLS, CSV, BMP, WMF, and other. - Easy localization.

Keywords: olap-component olap-engine olap-grid olap-application olap-functionality olap-view cross tabulated table molap-principle hiercube radarsoft aggregate function olap-server composite dimension multilevel dimension pivot mysql front current state