欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
Pentaho
第64行: | 第64行: | ||
[[Image:pentaho-query-olap-data.png|right|thumb|MDX Query of an OLAP Datasource]] | [[Image:pentaho-query-olap-data.png|right|thumb|MDX Query of an OLAP Datasource]] | ||
MDX Query of an OLAP Datasource | MDX Query of an OLAP Datasource | ||
− | [[Image:mdx-datasource-xaction-result.png|right|MDX Query Result]] | + | [[Image:mdx-datasource-xaction-result.png|right|thumb|MDX Query Result]] |
This rule uses an MDX multidimensional query to return Actual and Budget for all Regions. | This rule uses an MDX multidimensional query to return Actual and Budget for all Regions. | ||
2007年11月20日 (二) 22:30的版本
Pentaho: 商业智能项目提供企业级报表制作,分析,数据挖掘与工作流的功能.这个软件提供灵活 的部署选项以使它可作为嵌入式组件来使用,或作为定制BI应用程序. Pentaho包括Eclipse BIRT,JasperReports,Mondrian,JPivot,调度(scheduling),web服务,商业规则。
目录 |
Pentaho Projects
Pentaho is the sponsor and owner of other open source projects. These projects provide components and functionality integrated with the Pentaho BI Platform.
- Mondrian - Open Source OLAP Server
- JFreeReport - Open Source Reporting
- Kettle - Open Source Data Integration (ETL)
- Pentaho - Comprehensive Open Source BI Suite
- Weka - Open Source Data Mining
集成产品
Pentaho BI 平台集成和增强了现有的流行的第三方开放源码组件:
- Mondrian OLAP 服务器和 jPivot Analysis Front-End
- Firebird RDBMS
- Enhydra ETL,Shark 和 JaWE 工作流
- Kettle EII and ETL
- JBoss 应用程序服务器,Hibernate 和 Portal
- Weka 数据挖掘
- Eclipse 工作台和 BIRT 报表组件
- JOSSO 单点登录和 LDAP 集成
- Mozilla Rhino Javascript Processor
支持标准
BI 平台支持开放标准和协议有:
- XML – W3C 的可扩展标记语言
- JSR-94 – Java规则引擎
- JSR-168 – Java Portlet
- SVG – W3C 的可扩展适量图形
- XPDL – WFMC 的 XML 流程定义语言
- XForms – W3C 的 Web Forms
- MDX – Microsoft 的 OLAP 查询语言
- WSBPEL – Oasis 的 Web 服务业务流
- WSDL - W3C 的 Web 服务描述语言
安装
wget http://download.huihoo.com/pentaho/pentaho_demo-1.2.1.625-GA.tar.gz tar zxvf pentaho_demo-1.2.1.625-GA.tar.gz ./start-pentaho.sh http://localhost:8080/pentaho/
或者
获得 http://download.huihoo.com/pentaho/pentaho-1.2.1-linux-opensource-installer.bin chmod a+x pentaho-1.2.1-linux-opensource-installer.bin ./pentaho-1.2.1-linux-opensource-installer.bin 根据向导完成安装
安装成功后, 会在 MySQL 中创建如下库:
- hibernate
- quartz
- sampledata
- shark
启动系统
./start-pentaho.sh http://localhost:8080/pentaho // 成功进入 :) 初步浏览了一下,功能十分强大 http://localhost:8080/portal/portal/pentaho/ // 也提供了基于 JBoss Portal 的商务智能门户方案
安装 Pentaho Design Studio, 让其与 Pentaho Solutions 结合使用
wget http://download.huihoo.com/pentaho/pentaho-design-studio-linux_1.5.5.548-0.tar.gz
./PentahoDesignStudio File > New > Project > General 创建 Pentaho Solutions 的项目 并定位目录: pentaho-demo/pentaho-solutions/, 这时将 pentaho-solutions导入 Eclipse
MDX Query of an OLAP Datasource
This rule uses an MDX multidimensional query to return Actual and Budget for all Regions.
The data source is a Mondrian OLAP cube: samples/reporting/SampleData.mondrian.xml
Analysis
Dashboards
Data Integration
Data Mining
BI Platform
Reporting
All organizations use reporting in one form or another. As a result, reporting is considered a core Business Intelligence (BI) need and is frequently the first BI application deployed. Pentaho Reporting allows organizations to easily access, format, and distribute information to employees, customers, and partners.