• ASP.NET OLAP Chart is a web control to add Visual Analysis functionality to your ASP.NET applications. Unlike ASP.NET OLAP Grid, allows displaying business data in charts and graphs rather than in numbers right within the users web browsers. Works directly with a relational database or MS Analysis Services OLAP server. A built-in Silverlight-application allows perfect visualization on the client side not limited by HTML tags. 100% C# 2.0 managed code.

     

     

    特征综述 About Feature

     

    ASP.NET OLAP Grid exists in two versions that are shipped together: RIA OLAP Grid and HTML OLAP Grid. Though these versions have the same purpose and do not differ in the core functionality, they do differ in the technology they are built on and therefore in some points deriving from the particular 点击查看大图technology. Still, the versions are interchangeable and can be used instead one another without any harm, so it's up to you what version you prefer. We recommend that you use RIA controls because it's built on Silverlight technology that has advanced visualization capabilities, and makes the application much more sensitive, interactive and looking more like a desktop applications.

    HTML OLAP Grid is an ASP.NET control that renders OLAP data using DHTML tags. Though HTML version can be perfectly used, it is recommended to use the RIA OLAP Grid instead because its rendering is not tag-oriented, and so it's much more interactive for the end-user. Among the specific features of the HTML-rendered visualization there is the following:

    • Complete control over any Grid cell contents and its web-style. A possibility to replace a cell's content with any HTML code.
    • The flexible export to the following formats: BMP, CSV, GIF, HTML, JPEG, PDF, PNG, TIFF, TXT, XLS, XML.

    Full AJAX support点击查看大图
    All Grid operations (like drilling, sorting, pivoting, filtering, grouping) are performed in AJAX mode without any special AJAX library.

    Usability
    In addition to the flexible settings, the Grid has different popup menus that make it easy to access to the RadarCube numerous functions. The menus are truly context-dependent and have special options for each of the Grid cells, depending both on the cell type. Also you can easily customize any popup menu by using an appropriate event.

    Time intelligence
    One of the features available in OLAP Grid is Time Intelligence. If the current Cellset has one or several time dimensions, then additional option will be available in the popup menus to allow to compare measure values for different time periods or to display cumulative sum since the given date. Also you can define additional Time Intelligence types.

    OLAP Grid's API
    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. You can create your own aggregation functions; define your own rules for calculating dimension members, define your own sorting and context filtering. We can surely say the RadarCube is the constructor you can use to create OLAP-reports of any complication.

    Other Features

    • 100% managed code (C# 2.0), no ActiveX pieces.
    • All ASP.NET 2.0 advantages, including 100% AJAX, Web Parts, etc.
    • Fixed columns/rows headers on scrolling the Grid.
    • Web-browsers: IE 5.5 +, Firefox 1.1 +, Opera 9.0 +.
    • Client-side operating systems: Windows (all versions), Linux, Mac OS.
    • Hierarchies of three types:
      • Attribute hierarchies;
      • Parent-child hierarchies;
      • Multilevel hierarchies;
    • An ability to create additional calculated measures on the client or server side, using both the information from the fact table and values of the aggregated cube cells.
    • Additional calculated members of hierarchies on the client or server side.
    • Simultaneous display of a set of measures, each of which can be displayed in several different modes at the same time.
    • Interactive drill-down support of all types of hierarchies separately for every hierarchy member.
    • Saving and restoring the current OLAP slice.
    • Member grouping on any hierarchy level without changing the hierarchy levels structure.
    • Separate hierarchy or dimension sorting on any level. Possible overriding of any sorting method.
    • Ascending or descending sorting based on any column value in the OLAP grid.
    • Hierarchies' page-viewing mode. This feature allows to significantly lessen the network traffic and make the OLAP analysis easier.
    • Filtering of any set of hierarchy members with or without applying these filters in the OLAP calculations.
    • Auto filtering of the hierarchy members depending on their values in the Grid. Major/minor members selection, either based on their rank or on the Pareto principle.
    • Display in the Grid not only the values of measures, but a percent value in terms of total, subtotal, or grand totals. A possibility to create your own context-sensitive rules of measure display (for example, a cumulative sum of measure values for time dimensions only).
    • Custom popup menus in the Grid.
    • Handy integration with charting and other third-party components.
    • Easy localization. It is possible to localize the evaluation version as well.
    • Developer requirements: Visual Studio 2005, 2008, Visual Web Developer.
    • Medium trust compliance. It can be used on most shared Windows hosting environments