SpagoBI

您可以在Wikipedia上了解到此条目的英文信息 SpagoBI Thanks, Wikipedia.

Spagobi Architecture

SpagoBI是一个商业智能平台：为商业智能项目提供了一个完整开源的解决方案。它涵盖 了一个BI系统所有方面的功能包括：数据挖掘、查询、分析、报告、Dashboard仪表板。

SpagoBI 基于 Spago 框架构建

Install

此方法适用于Linux和Windows平台

SpagoBI Roles

install exo portal
wget http://download.huihoo.com/exoplatform/exo-portal-1.1.4-tomcat.zip
mkdir spagobi\repository\ directory 
wget http://download.huihoo.com/spagobi/1.9.3/spagobi-1.9.3.zip
unzip spagobi-1.9.3.zip under repository directory
wget http://download.huihoo.com/spagobi/1.9.3/SpagoBIInstaller-1.9.3-08102007.zip
unzip SpagoBIInstaller-1.9.3-08102007.zip
start StartSpagoBIInstaller 
start SpagoBI

http://localhost:8080/sbiportal
president/president
staff_gen/staff_gen
sales_manager/sales_manager
product_manager/product_manager
....

http://localhost:8080/portal
exoadmin/exo
exoportal/exo
exotest/exo
exo/exo
demo/exo

http://localhost:8080/spagobi

Build

wget http://download.huihoo.com/spagobi/1.9.3/SpagoBI-src-1.9.3.zip

Install Maven 2

wget http://download.huihoo.com/apache/maven/maven-2.0.7-bin.tar.gz
tar zxvf maven-2.0.7-bin.tar.gz /usr/local/maven-2.0.7
export MAVEN_HOME=/usr/local/maven-2.0.7
export PATH=/usr/local/maven-2.0.7/bin:$PATH

Install exo portal

wget http://download.huihoo.com/exoplatform/exo-portal-1.1.4-tomcat.zip
unzip exo-portal-1.1.4-tomcat.zip /usr/local/exo-portal-1.1.4

目前只支持三种 Application Server

#mvn install:install-file -DgroupId=exo -DartifactId=exo-platform.container \
         -Dversion=2.0.3 -Dpackaging=jar -Dfile=/usr/local/exo-portal-1.1.4/common/lib/exo-platform.container-2.0.3.jar
#mvn -Pspagobi-tomcat package     // for Tomcat server or
#mvn -Pspagobi-jboss package      // for JBoss server or
#mvn -Pspagobi-jonas package     // for JOnAS server

A folder "build" will be created, 然后请看 tomcat_installation_instructions.txt 文件

中文化

在 /SpagoBI-src-1.9.3/SpagoBIProject/src/下增加以下几个文件 
component_impexp_messages_zh_CN.properties
component_scheduler_messages_zh_CN.properties
component_spagobidashboardIE_messages_zh_CN.properties
component_spagobidashboardscompositionIE_messages_zh_CN.properties
component_spagobiofficedocIE_messages_zh_CN.properties
component_booklets_messages_zh_CN.properties
messages_zh_CN.properties

并对照英文翻译相应的中文。

在 /SpagoBI-src-1.9.3/SpagoBIProject/web-content/WEB-INF/conf/spagobi.xml 文件中增加
<LANGUAGE default="false" language="zh" country="CN" />

或将这些文件直接放在已发布的SpagoBI中

/exo-portal-1.1.4/webapps/spagobi/WEB-INF/classes 下

并修改 /exo-portal-1.1.4/webapps/spagobi/WEB-INF/conf/spagobi/spagobi.xml 文件

 <LANGUAGE default="false" language="zh" country="CN" />

修改 /exo-portal-1.1.4/webapps/spagobi/WEB-INF/conf/locales-config.xml

  <locale-config>

   <locale>zh</locale>

   <output-encoding>UTF-8</output-encoding>

   <input-encoding>UTF-8</input-encoding>

   <description>中文环境默认配置</description>

 </locale-config>

修改首页

修改版权信息:  exo-portal-1.1.4/webapps/sbiportal/spagobi-static-content/footer.html
修改banner: exo-portal-1.1.4/webapps/sbiportal/spagobi-static-content/banner.html

Use Projects

SpagoBI focus is in adding value to enterprise in the use both of Open Source solutions and of existing analytical engines (open source or proprietary). The interaction mode is open, such that several tools could be used in parallel or as an alternative.

• Application server: JOnAS, JBoss, Tomcat, IBM Websphere
• Application Framework: Spago
• Content repository: Jackrabbit, eXo JCR
• Search Engine: Lucene
• Report Engine: JasperRepor, BIRT
• OLAP client/engine: Jpivot, Mondrian
• Data Mining engine: Weka
• GIS engine: CartoWeb, MapServer, SVG
• QbE support : Hibernate
• ETL support: Talend OpenStudio
• Analytical dossier: OpenOffice Impress
• Workflow: jBPM
• Administration-Scheduler: Quartz
• Dashboard-Visualizer: OpenLaszlo
• Portal Server: eXo Portal, IBM Websphere Portal
• Proprietay engines: Business Objects, Microsoft Analysis Service

Links

• http://spagobi.objectweb.org/
• http://download.huihoo.com/spagobi/
• http://docs.huihoo.com/spagobi/

<discussion>characters_max=300</discussion>