用于WEB報(bào)告的專業(yè)數(shù)據(jù)透視表組件

最強(qiáng)大的JavaScript工具，用于可視化您的業(yè)務(wù)數(shù)據(jù)


帶示例數(shù)據(jù)，速來(lái)試用嘗鮮！

1、Pivot Table-分層數(shù)據(jù)顯示和分組

數(shù)據(jù)透視表構(gòu)件可幫助您為Web、Flex和移動(dòng)應(yīng)用程序創(chuàng)建交互式的數(shù)據(jù)透視表和圖表報(bào)告。數(shù)據(jù)透視表構(gòu)件可在創(chuàng)建和分析報(bào)告的同時(shí)，為您的顧客提供極為直觀的最終用戶體驗(yàn)。

一旦將構(gòu)件嵌入您的應(yīng)用程序后，用戶將立即獲得各種強(qiáng)大的特色功能，以滿足其實(shí)時(shí)業(yè)務(wù)分析的需求

• 可快速將來(lái)自OLAP立方塊、SQL數(shù)據(jù)庫(kù)或靜態(tài)CSF文件的復(fù)雜數(shù)據(jù)顯示為緊湊的概括性可視化報(bào)告，與Excel的數(shù)據(jù)透視表和圖表類似

• 向下鉆取的數(shù)據(jù)透視表是一種可向分析師開(kāi)放實(shí)時(shí)業(yè)務(wù)數(shù)據(jù)的強(qiáng)大工具

• 用戶很容易更改報(bào)告的外觀布局，并從不同的視角對(duì)數(shù)據(jù)進(jìn)行審視。您不必為滿足最終用戶的潛在需求而預(yù)見(jiàn)到所有可能的報(bào)告情況

• 每項(xiàng)報(bào)告數(shù)據(jù)均可以篩選、設(shè)定格式（貨幣、數(shù)字）、排序或放大。用戶還可以定義數(shù)據(jù)的匯總值和小計(jì)值，以及報(bào)告的外觀

• 報(bào)告數(shù)據(jù)可以打印或輸出為PDF文件、Excel、CSV、圖形或HTML網(wǎng)頁(yè)

2、Pivot Charts-交互式可鉆取圖表

數(shù)據(jù)透視表可提供一種交互式的數(shù)據(jù)可視化替代方案：

• 支持多種類型：柱狀圖、圓柱圖、直線圖、散點(diǎn)圖、堆積圖和餅圖

• 用戶可通過(guò)數(shù)據(jù)的層級(jí)進(jìn)行向上和向下鉆取并在各個(gè)層級(jí)上查看圖表的詳情

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

3、撰寫(xiě)報(bào)告布局-選擇尺寸和顯示值

用戶很容易更改報(bào)告的外觀布局，并可從不同的視角對(duì)數(shù)據(jù)進(jìn)行審視：

• 用戶只需一分鐘即可設(shè)定報(bào)告的布局-確定行、列或篩選區(qū)內(nèi)應(yīng)設(shè)定哪些維度

• 與行和列的拖放一樣簡(jiǎn)單

• 支持的匯總運(yùn)算：求和、計(jì)數(shù)、平均值、最小值、最大值、求積、百分比

• 數(shù)值的格式：貨幣、小數(shù)位數(shù)、分隔符

• 可對(duì)外觀進(jìn)行動(dòng)態(tài)更改，使其更具吸引力

4、分析數(shù)據(jù)-過(guò)濾、排序、最高記錄、向下鉆取

數(shù)據(jù)透視表構(gòu)件可提供類似Excel的功能，從而為用戶提供其常用的界面：

• 可創(chuàng)建計(jì)算指標(biāo)，以便從不同的視角對(duì)事實(shí)進(jìn)行分析
• 數(shù)值的條件格式功能
• 通過(guò)直觀性的快速搜索來(lái)篩選數(shù)據(jù)，將無(wú)關(guān)信息隱藏起來(lái)，或發(fā)現(xiàn)目標(biāo)業(yè)務(wù)情況
• 通過(guò)多重選項(xiàng)支持巨量數(shù)據(jù)層級(jí)
• 用戶可對(duì)任何一列或一行進(jìn)行排序
• 通過(guò)Top 10記錄，可將注意力集中于高度相關(guān)的數(shù)據(jù)

5、Manage Views-保存和瀏覽報(bào)告視圖

用戶可處理預(yù)先定義的報(bào)告集或創(chuàng)建和保存自己的報(bào)告。在用戶編制完報(bào)告后，可將其保存起來(lái)，以便將來(lái)使用或與他人共享。

該構(gòu)件支持將報(bào)告保存到本地硬盤(pán)驅(qū)動(dòng)器或服務(wù)器。您可以借助強(qiáng)大的JS和Flex API來(lái)保存報(bào)告并載入以前保存的報(bào)告。保存的報(bào)告在布局、數(shù)據(jù)格式、篩選方式和排序方式，以及所有選項(xiàng)方面都和原報(bào)告相同。

6、對(duì)于web應(yīng)用程序-容易嵌入到Web應(yīng)用程序中，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數(shù)據(jù)透視表的Flash對(duì)象（SWF）插入網(wǎng)頁(yè)，無(wú)論是靜態(tài)HTML或由ASP、PHP、ASP.NET、JSP、 CouldFusion、Ruby on Rails、Java Script生成的網(wǎng)頁(yè)，甚至是簡(jiǎn)單的HTML網(wǎng)頁(yè)。該構(gòu)件可連接至任何數(shù)據(jù)庫(kù)：微軟SQL、MySQL、Oracle、PostgreSQL，借助簡(jiǎn)單 的腳本來(lái)生成CSV輸出，以實(shí)現(xiàn)實(shí)時(shí)業(yè)務(wù)分析。

7、OLAP/XMLA-通過(guò)XMLA或Flexmonster Accelerator 可視化OLAP數(shù)據(jù)

數(shù)據(jù)透視表構(gòu)件可通過(guò)XMLA協(xié)議或者Flexmonster Accelerator 連接至OLAP立方塊。XMLA是用于分析的XML：一種用于OLAP和數(shù)據(jù)挖掘等分析系統(tǒng)的，關(guān)于數(shù)據(jù)存儲(chǔ)的行業(yè)標(biāo) 磚。微軟的SQL Server分析服務(wù)（2005，008）和Pentaho分析服務(wù)（Mondrian）非常適合使用數(shù)據(jù)透視表構(gòu)件。

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

程序開(kāi)發(fā)人員可以控制該構(gòu)件的各種因素：通過(guò)CSS來(lái)控制風(fēng)格、通過(guò)普通XML來(lái)控制報(bào)告的配置、HTML5應(yīng)用程序的Javascript API以及Flex API，并可通過(guò)全球本地化來(lái)滿足多語(yǔ)言的要求。

9、Fast-工作效率高

該構(gòu)件以針對(duì)超大數(shù)據(jù)集進(jìn)行了嚴(yán)格優(yōu)化，以順暢瀏覽和滾動(dòng)超長(zhǎng)的報(bào)告。已針對(duì)數(shù)據(jù)量可達(dá)100MB的數(shù)據(jù)文件和超大OLAP立方體數(shù)據(jù)量進(jìn)行了徹底測(cè)試。

10000萬(wàn)條數(shù)據(jù)10秒極速加載，還有數(shù)據(jù)匯總、平均等計(jì)算公式同步進(jìn)行。

Flexmonster Pivot Table & Charts版本對(duì)比表

我們的客戶

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.