用于WEB报告的专业数据透视表组件

最强大的JavaScript工具，用于可视化您的业务数据


带示例数据，速来试用尝鲜！

1、Pivot Table-分层数据显示和分组

数据透视表构件可帮助您为Web、Flex和移动应用程序创建交互式的数据透视表和图表报告。数据透视表构件可在创建和分析报告的同时，为您的顾客提供极为直观的最终用户体验。

一旦将构件嵌入您的应用程序后，用户将立即获得各种强大的特色功能，以满足其实时业务分析的需求

• 可快速将来自OLAP立方块、SQL数据库或静态CSF文件的复杂数据显示为紧凑的概括性可视化报告，与Excel的数据透视表和图表类似

• 向下钻取的数据透视表是一种可向分析师开放实时业务数据的强大工具

• 用户很容易更改报告的外观布局，并从不同的视角对数据进行审视。您不必为满足最终用户的潜在需求而预见到所有可能的报告情况

• 每项报告数据均可以筛选、设定格式（货币、数字）、排序或放大。用户还可以定义数据的汇总值和小计值，以及报告的外观

• 报告数据可以打印或输出为PDF文件、Excel、CSV、图形或HTML网页

2、Pivot Charts-交互式可钻取图表

数据透视表可提供一种交互式的数据可视化替代方案：

• 支持多种类型：柱状图、圆柱图、直线图、散点图、堆积图和饼图

• 用户可通过数据的层级进行向上和向下钻取并在各个层级上查看图表的详情

• 图表便于理解，并且提供方便的工具提示和图例信息

3、撰写报告布局-选择尺寸和显示值

用户很容易更改报告的外观布局，并可从不同的视角对数据进行审视：

• 用户只需一分钟即可设定报告的布局-确定行、列或筛选区内应设定哪些维度

• 与行和列的拖放一样简单

• 支持的汇总运算：求和、计数、平均值、最小值、最大值、求积、百分比

• 数值的格式：货币、小数位数、分隔符

• 可对外观进行动态更改，使其更具吸引力

4、分析数据-过滤、排序、最高记录、向下钻取

数据透视表构件可提供类似Excel的功能，从而为用户提供其常用的界面：

• 可创建计算指标，以便从不同的视角对事实进行分析
• 数值的条件格式功能
• 通过直观性的快速搜索来筛选数据，将无关信息隐藏起来，或发现目标业务情况
• 通过多重选项支持巨量数据层级
• 用户可对任何一列或一行进行排序
• 通过Top 10记录，可将注意力集中于高度相关的数据

5、Manage Views-保存和浏览报告视图

用户可处理预先定义的报告集或创建和保存自己的报告。在用户编制完报告后，可将其保存起来，以便将来使用或与他人共享。

该构件支持将报告保存到本地硬盘驱动器或服务器。您可以借助强大的JS和Flex API来保存报告并载入以前保存的报告。保存的报告在布局、数据格式、筛选方式和排序方式，以及所有选项方面都和原报告相同。

6、对于web应用程序-容易嵌入到Web应用程序中，JavaScript API

<div id="firstPivotContainer">The component will appear here</div> 
<div id="secondPivotContainer">The component will appear here</div> 
<script src="flexmonster/flexmonster.js"></script>

<script>
	var pivot1 = new Flexmonster({
		container: "pivotContainer",
		toolbar: true,
		report: {
			dataSource: {
				filename: "data.csv"
			}
		},
		licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
	});

	var pivot2 = new Flexmonster({
		container: "pivotContainer",
		toolbar: true,
		report: {
			dataSource: {
				filename: "data2.csv"
			}    	
		},
		licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
	});
</script>

<button onclick="javascript: swapReports()">Swap Reports</button>
<script>
	function swapReports() {
		var report1 = pivot1.getReport();
		var report2 = pivot2.getReport();

		pivot1.setReport(report2);
		pivot2.setReport(report1);
	}
</script>

您只需将Flexmonster数据透视表的Flash对象（SWF）插入网页，无论是静态HTML或由ASP、PHP、ASP.NET、JSP、 CouldFusion、Ruby on Rails、Java Script生成的网页，甚至是简单的HTML网页。该构件可连接至任何数据库：微软SQL、MySQL、Oracle、PostgreSQL，借助简单 的脚本来生成CSV输出，以实现实时业务分析。

7、OLAP/XMLA-通过XMLA或Flexmonster Accelerator 可视化OLAP数据

数据透视表构件可通过XMLA协议或者Flexmonster Accelerator 连接至OLAP立方块。XMLA是用于分析的XML：一种用于OLAP和数据挖掘等分析系统的，关于数据存储的行业标 砖。微软的SQL Server分析服务（2005，008）和Pentaho分析服务（Mondrian）非常适合使用数据透视表构件。

8、Customizable-用CSS控制外观&API

程序开发人员可以控制该构件的各种因素：通过CSS来控制风格、通过普通XML来控制报告的配置、HTML5应用程序的Javascript API以及Flex API，并可通过全球本地化来满足多语言的要求。

9、Fast-工作效率高

该构件以针对超大数据集进行了严格优化，以顺畅浏览和滚动超长的报告。已针对数据量可达100MB的数据文件和超大OLAP立方体数据量进行了彻底测试。

10000万条数据10秒极速加载，还有数据汇总、平均等计算公式同步进行。

Flexmonster Pivot Table & Charts版本对比表

我们的客户

Different Data Sources

	Pivot Table Component can use different data sources: OLAP Cube via XMLA protocol (MS Analysis Services); CSV files exported from Excel; XML from custom web services; support of Mondrian; support of SAP;
Search/Sort Through Huge Data Stores FAST
	Component is optimized to manage SERIOUS data. The grid renders multiple millions of cells. If your browser can take it, we'll dish it out.
Drill Down Grid on Rows and on Columns
	Drill-down data both on rows and on columns — from the summary data to details.
Compose Reports in Minutes
	Drag and drop your row and column choices. Choose filters and see your report instantly.
Pivot Charts
	Charts is the alternative, interactive way to visualize the most complex data in your tables. Drill down from the summary data to details on charts. Different chart types, such as: bar, line, pie. Customize each chart with convenient tool tips and legends. Easily switch between charts and table views to make sure you know what each chart is telling you.
Pivot Charts Drill Down
	You can drill up and down through data hierarchies and see charts at every level. Visualize everything from the big picture to the smallest details.
Filter, sort and group your data your way
	Excel-like features give users the interface they're used to.
Subtotal and Aggregate Numeric Data
	Count totals and aggregations both on server-side or client-side. Even if you don't have OLAP cube on your server side, Pivot Table can aggregate your data in runtime. You can predefine aggregation in the configuration or use the interface. sum count average min max product
Predefine and Save Reports
	Create a predefined report to reveal the precise data views you need; Return to the same view immediately next time Pivo Table is opened
Configuration via xml or flash vars
	Developers customize the look and feel of the grid, data source and default slices of data they need to see.
Customize Skins and Styles via CSS
	Developers can customize the look of the grid and all interface elements using standard CSS.
Easy Integration with Different Platforms
	Pivot Table & Charts component works seamlessly with C#, PHP, Ruby on Rails, ASP, JSP.
Embed into your Flex Apps
	It is easy to embed any part of the Pivot Table grid or chart components into your Flex application. Pivot Table's Flex API allows developers to change styles, component sizes and custom data for visualization.
Alternative to Open Source BI solutions
	Our Pivot Table Component can be used as an alternative to popular open source BI solutions like JPivot and olap4j: as an alternative to slow Flex OLAPDataGrid; as an alternative to Jpivot that is using Mondrian for OLAP server with XMLA support; as an alternative to olap4j with multidimensional data sets, MDX support and OLAP server support;
Loads in seconds
	Total size is less than 150K.It is smaller than any single grid component in Flex framework such as the Flex AdvancedDataGrid, OLAPDataGrid or even the simple DataGrid.