Flexmonster Pivot Table & Chart Component

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Our regular prices are shown below. Please logon to see your discounted prices.

Flexmonster Pivot Table & Chart Component v1.5  

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

As a web component, Flexmonster Pivot provides Javascript and Flex API and complete customizability. Forget installation hassles and configuration. All you have to do is follow three simple steps - 1) copy the SWF files to your server; 2) point the configuration file to data sources and available options; 3) launch the application for a demo.

The component will connect to any database: MS SQL, MySQL, Oracle, PostgreSQL using simple script generating CSV output to enable real-time business analysis. You can use the complete reference manual, enterprise demos and lots of code samples for quick start up.

Pivot Table Component helps you to create interactive Pivot tables & charts reports for web and Flex applications. Pivot Component will provide your customers with an extremely intuitive end-user experience while creating and analyzing reports.

After the component is embedded into your application users will immediately get a variety of powerful features to meet their real-time business analysis needs:

• Display quickly the complex data from OLAP cubes, SQL databases or static CSV files into compact and summarized visual reports - tables and charts.
• Data is automatically arranged into a tree structure with expandable parents. End-users can expand or collapse child groups to see more summarized or raw reports.
• The drillable Pivot Charts provide a powerful method to expose the real-time business data to analysts.
• Users can easily change a report's layout visually and examine data from different perspective (you don't have to foresee all possible report scenarios your end-users might require).
• Each report data can be filtered, formatted (currencies, numbers), sorted or zoomed. User defines data totals and subtotals, the look of the report too.
• Report data can be visually highlighted with icons or color.
• You can link report data to external sources or other reports.
• Users can create new reports, save their created report layout and share with other.
• Finally the report data can be printed or exported as PDF file, Excel, CSV, image or HTML page.

Pivot Charts - Interactive drillable pivot charts
Pivot Charts provide an alternative, interactive way to visualize data:

• Users can drill-up and drill-down through data hierarchies and see chart details at every level.
• Charts are easily understood and have convenient tooltips and legend information.
• It is easy to switch between charts and table views or to use split view to see both table and charts views at the same time.

Pivot Table & Charts Component supports wide variety of charts:

• bar
• cylinder
• line
• scatter
• bar stack
• pie

Compose Report Layout - Select which dimensions & values to show
Users can easily change a report's layout visually and examine data from different perspective:

• Users can compose report layout in a minute - decide which dimensions should be placed to rows, columns or filter-area.
• Composing the report is as easy as drag and drop rows and column.
• Users can select an aggregation of the values to see well-consolidated reports.
• The following predefined aggregations are supported: Sum, Count, Average, Min, Max, Product, Percent.
• Even if you don't use OLAP, Pivot Table will aggregate and visualize the data immediately in real time.
• The users can hide or show totals and sub-totals for the values.
• The numeric values can be formatted: currencies and decimal places/separator.
• Finally it is possible to change the style of the report on the fly to make it looking more visually impressive.

The power of Pivot report composing allows you to stop guessing all possible report scenarios your end-users might require.

Analyze Data - Filter, sorting, top records, drill-down
Pivot Component provides Excel-like features which give users the interface they always used. The users can easily and quickly analyze data report now:

• Users can use the filter with intuitive quick-search to hide any irrelevant information or find target business facts.
• The filter supports huge data hierarchies with multi-select and searching the data.
• Users can sort any column or any row.
• Top 10 records provides the possibility to focus an attention only on the highly relevant data and hide all the other information.

Manage Views - Save & navigate report views
The users can work with predefined set of reports or create & save own reports. Once the user has composed a report to reveal the precise data views they may want to save it for future or share it with others.

The component supports saving reports to local hard drive or to the server. You can utilize the powerful JS and Flex API to save reports and load previously saved ones. The saved reports have exactly the same layout, number formatting, filters, sorting as in the original report.

It is much more convenient to share reports online by sharing the report link, comparing to the old-fashioned Excel files sending by email.

Export and Print - Export to PDF, Excel, HTML, CSV and images
Pivot Component supports the printing of the Pivot view. Additionally the users can export the reports into a variety of formats:

• Microsoft Excel
• PDF
• Web page (HTML page)
• CSV (comma separated text format)
• Image (PNG)

Both table view and charts view can be printed or exported.

You can control where to save the export data, the following methods are supported:

• Save to local file
• Save to server (to remote file-storage or database)
• Save to clipboard

Embedding Into Your Application

For web-application - Easy embed into Web application, JavaScript API
Pivot Component simplicity allows you to get started in 15 minutes. The component is extremely easy to integrate. We provide extensive documentation, enterprise demos and easy to understand code samples so you could prepare your demo to customer almost immediately.

To use Pivot Table Component you do not have to install anything on the web server. All you need to do is copy paste the SWF files to your server - and you're ready to go! Thus even on those servers which do not allow installation of own components, Pivot Table Component will run without any problems.

Pivot Component works with all web technologies and data sources.

You just insert usual Flash object (SWF) into web page, either static HTML or generated by ASP, PHP, ASP.NET, JSP, ColdFusion, Ruby on Rails, JavaScript or even simple HTML pages.

The component will connect to any database: MS SQL, MySQL, Oracle, PostgreSQL using simple script generating CSV output to enable real-time business analysis.

With powerful JavaScript API and configuration you control entire behavior of the component. You can customize component features, turn on & off any possibilities for the end users and specify the available interactions with the end users.

For Flex-application - Easy embed into Flex application as SWC component
It is easy to embed Pivot Table Component into Flex application as SWC component.

The Pivot Table Component for Flex has a very flexible and easy to learn API that allows you to create Pivot tables and charts in very few lines of code. You can also do advanced things like exporting the reports as images or PDFs, exporting data as CSV or Excel.

The component is compatible with Flex SDK 3.x and later.

Pivot Table Component is ideal alternative to OLAPDataGrid for your Flex solutions. The OLAPDataGrid in Flex is not full-featured Pivot Table. Flexmonster Pivot Table has a number of critical features which are totally absent in OLAPDataGrid:

• Flexmonster Pivot Table can collapse/expand both rows and columns (while OLAPDataGrid can do this for rows only)
• Flexmonster Pivot Table is optimized for large volumes of data (millions of rows) visualization (while OLAPDataGrid becomes terribly slow for rendering and scrolling even after 2-3 thousands facts)
• Flexmonster Pivot Table has features for the analyst to configure reports on-the-fly (configure the dimension, switch views, auto-sorting and filtering)
• Flexmonster Pivot Table can work with OLAP server via connection string (while OLAPDataGrid needs additional data preparation)
• Flexmonster Pivot Table has Pivot Charts showing the same grid visualization but in charts view

SQL/CSV database - Gets data from SQL database or CSV sheets
The component will connect to any database: MS SQL, MySQL, Oracle, PostgreSQL - using simple script generating CSV output to enable real-time business analysis. Pivot Component is full browser-side component, thus you can use any desired server-side to generate CSV data: ASP, PHP, ASP.NET, JSP, ColdFusion, Ruby on Rails, JavaScript or simple HTML pages.

You can even use usual static CSV files with exported business data to create a simple business intelligence report to demonstrate the power of Pivot tables and charts.

Alternatively Pivot Component can work with OLAP cubes via XMLA, which is a standard method to work with really huge data volumes.

Pivot Component allows additional control by providing meta-data to the reports. You can define which columns are dates, currencies or parts of tree hierarchies, links or icons for the desired visualization.

OLAP/XMLA - Visualize data from OLAP via XMLA (MS Analysis Services or Pentaho Mondrian
Pivot Table Component can connect to OLAP cubes via XMLA protocol. XMLA is XML for Analysis - an industry standard for data access in analytical systems, such as OLAP and Data Mining.

The following business intelligence software works well with the Pivot Table Component:

• Microsoft SQL Server Analysis Services (2005, 2008)
• Pentaho Analysis Services (Mondrian)
• any other business intelligence software supporting XMLA standard

Both Microsoft Analysis Services and Pentaho Analysis Services data sources are fully supported by the Pivot Table Component. If connected to such a data source, the Pivot Table Component delegates all data management and calculations to the server-side.

This method will greatly increase your application's performance if you are dealing with large data volumes. In such case it could take a long time for a client browser to recalculate all the data. It works much faster when request server-side data recalculation and then simply display the received result.

Customizable - Control skins with CSS & API
Pivot Table Component not only gives your business data a pretty look, it also adds smart analysis features like filtering, drill-down, report export, zoom and styles.

You can control and customize these all features with configuration of the report and powerful API. Any feature can be deactivated, enabled or configured to work differently from the default behavior.

Developers can control the following aspects of the component:

• The appearance of the user controls, grid and charts - with CSS.
• The report XML or FlashVars configuration allows to enable/disable any features and select the data source method.
• The Pivot Component is tightly integrated with JavaScript. This allows updating client-side table, listening user events and maintaining states or to saving it.
• You can define the desired behavior of the component or override certain features (filters, formatting cells, setting links, etc) with API.
• The component has JavaScript API for web-based applications and Flex API for Flex applications.
• Each report has its own grid styles, predefined styles are available for the end user to select from.
• Visible text of the Pivot Component can be translated with special localization to fit multi-language requirements.

Fast - Works fast with huge data sources
The component is seriously optimized for huge data sets for smooth browsing and scrolling really long reports. It is thoroughly tested to work with up to 100MB data files and huge OLAP cubes data volumes.

Maximum data size is limited only by your end-users' browsers and the capacity of their computers.

The table renders multiple millions of cells immediately. If the user's browser can handle it, we'll display it.

Just browser - Component works in any web-browser with Flash player installed
Pivot Table Component will show fine any modern browser (Internet Explorer, Firefox, Chrome, Opera) with installed Adobe Flash Player 10.

Adobe Flash Player is a cross-platform browser plug-in that delivers breakthrough Web experiences to over 99% of Internet users (according to the official Flash Player Penetration). You can always get Flash Player at http://www.adobe.com/go/getflash.

The component works with any server-side platform, it doesn't matter which server-side language served the Flash object or provided the data.

All editions include:
For web-developers and integrators:

• Connect to SQL databases (with CSV-output script) or static CSV files
• SWF to embed into web-applications (with JavaScript API) and SWC for Flex-applications (Flex API)
• Skins and visual appearance control with easy-to-edit CSS

For end-users of your applications (analysts, top-managers):

• Ability to visualize data in Pivot tables and interactive drillable Pivot charts
• Compose layout, select which dimensions and values to show
• Analyze data: drill-down, filtering, sorting, top records, aggregating, sub-totaling
• Visualize really huge data sets for smooth browsing and scrolling really long reports

Standard Edition includes:

• DataSource: CSV/SQL 1MB
• Unlimited developers, unlimited dev/test servers, unlimited end-users
• Free upgrades and support for 3 months

Professional Edition includes:

• DataSource: CSV/SQL 2MB
• Unlimited developers, unlimited dev/test servers, unlimited end-users
• Free upgrades and support for 6 months
• Save/load report configuration. Export as CSV, HTML or image (PNG).

Enterprise Site Edition includes:

• DataSource: CSV/SQL 4MB, XMLA/OLAP Mondrian
• Unlimited developers, unlimited dev/test servers, unlimited end-users
• Free upgrades and support for 9 months
• Save/load report configuration. Export as CSV, HTML or image (PNG).
• Printing. PDF export. Export to Microsoft Excel. Localization

Enterprise Advanced Edition includes:

• DataSource: CSV/SQL Unlimited MB, XMLA/OLAP Mondrian and Microsoft Analysis Services
• Unlimited developers, unlimited dev/test servers, unlimited end-users
• Free upgrades and support for 12 months
• Save/load report configuration. Export as CSV, HTML or image (PNG).
• Printing. PDF export. Export to Microsoft Excel. Localization