This is the best choice to extend the functionality of your desktop apps using the controls for Visual Analysis. The full power of the traditional Windows Forms applications is used to satisfy your users with great performance and usability.
RadarCube supports MS Analysis Services (RadarCube MSAS) or any relational database
(RadarCube Direct) as a data source. RadarCube Direct edition supports the data
warehouse structure by using all its tables. RadarCube dimensions and measures structure
allows the data warehouse structure to be reflected in the final OLAP-report to
the full extent. RadarCube supports such structures as "star" and "snowflake", several
fact tables and "parent-child" relations in the dimension tables.
In the OLAP-schema the data is organized in multilevel (for the "snowflake" schema) and "parent-child" hierarchies.
For the MSAS edition all you have to do is define the connection string to the server. For the Direct edition you only need to create a standard Visual Studio DataSet control and describe all table relations; then you can use it as a data source for RadarCube. This helps you both save memory and reduce the loading time, because you do not have to create a special table/view containing all data from the related tables.
Despite the fact that RadarCube is 100% managed, it doesn't yield in its performance to its VCL analogues: HierCube and RadarCube VCL. The unique technology of calculating OLAP-slices "on the fly" first implemented in HierCube and updated in RadarCube, allows calculating only the data currently displayed. Such technology saves memory and remarkably reduces an OLAP-slice calculation time. Thus, RadarCube easily operates with data warehouses containing up to several million records in the fact table for Direct edition and almost unlimited amount of records for the MSAS edition.
The power of the RadarCube core shows up not only in the unique performance and most compound OLAP structures support, but also in OLAP reports individual settings. This includes the automatic transformation of dates into flat and multilevel hierarchies, ability to create calculated dimensions and hierarchy members, calculated measures and calculated hierarchies. For example, for the "Year" dimension you can create calculated members that show the year-to-year dynamics. For the "Account" measure, you can create calculated members to show the sub-totals by the sum of some of the expense or income items. The values of these calculated members will be adjusted to the active OLAP-slice. More than that, you can show or hide member values for particular contexts. You can define the attibutes containing additional info about members and comment the OLAP cells. And much more...
RadarCube can visualize the OLAP slice as a Grid or series of Charts. OLAP Grid allows the user to replace the content of any cell, to place a picture of any size into any Grid cell, to automatically position pictures and text within a cell, to adjust the cell size to its contents, to change order of the members by simply drag-n-dropping them, context filters, members' grouping, any method of sorting including alphabetical, by value, or custom.
RadarCube OLAP Grid supports formatting of the cell content in accordance with its value. Context formatting can be applied to a selected area or to the whole Grid. There are different variants of formatting: you can change the background color, draw bar charts within cells, or make other amends.
Modifiers are easy and powerful options of data representation. You can choose your data to be shown in different colors, using different shapes and sizes, so that you can easy distinguish them in a single graph. You can simply place a dimension or a measure on the modifiers pane and get the graph showing different values in a different manner. For example, you might place the "Shippers" dimension on Color pane and get the OLAP Chart showing shippers in different colors. Or you can place the "Sales" measure on Color pane to highlight the top sales. The like can be done for Shape and Size so that you can make your data perfectly distinguished. If a measure is placed on the Color pane, its values range is mapped to the given colors range so that it is tremendously easy to spot the top/low values.
It is easy to zoom into your data, so that you take a deeper look at a certain data square. Want a little bit more details? Not a big deal - just zoom into the data you are interested in. And all is done visually, so you do not even need to know the exact values of your data.
Select any data range in OLAP Chart and copy to clipboard. Then you'll be able to paste it in an Office program for further analysis. You can also paste the OLAP Chart like a picture to illustrate your investigations.
At any stage of your analysis you can see the underlying data for the selected values. There are two commands for that: "Show underlying data" and "Drillthrough" The "Drill through" operation can be performed against any data source including relational databases. It shows all records from the data source that had been counted on calculating the selected points.
You can set up a look and feel of the component selecting from the standard color schemes like MS Office 2003, Windows Vista, etc., or defining your own display style. In addition to the styles you can always override the standard appearance using many painting events - an unlimited ability to make up your own special appearance.
You can print your report to share it with others using the built-in Print Preview window. You can tune your page/printer settings before printing. Also if you feel like sharing the report through the net or by email you can easy export it to a wide range of formats including PDF, XLS, CSV, JPG, etc.
The RadarCube core has a detailed and well documented API which allows you to perform any OLAP-slice modifications from within your application, obtain information about any Cube or Grid cell no matter if it is actually displayed in the current Grid report. You can create your own aggregation functions with event handlers; define your own functions for calculating dimension members, define your own sorting and context filtering methods. We can surely describe RadarCube as a perfect tool to create OLAP-reports of any complexity.
RadarCube is royalty free (of course, if you don't use it to create your components for resale and are stuck to the License Agreement). By purchasing RadarCube you get the right to download new versions within a year from the purchase date, get free tech support, and a discount for purchasing our products. If for some reason you're not satisfied with the quality of the product, you can get your money back within 30 days from the purchase date.