next version move to https://github.com/billchen198318/hillfog

<h2>bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence</h2> <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-logo.png" alt="logo"/>

Features:

BSC's Vision, Perspectives, Objectives of strategy, Key Performance Indicators (KPIs). and Maintain measure-data.
KPI report, Personal and organization BSC report. can custom workspace's layout
Strategy Map, and BSC SWOT.
Provides SQL client query results show as Chart ( PIE, BAR, LINE, AREA ).
Provides a simple OLAP client query.
Provides Sourcecard query for mobile-device browser.
PDCA & PDCA report.

<h3>bambooBSC demo video</h3> <a href="http://www.youtube.com/watch?feature=player_embedded&v=N5BsWZL8bxQ" target="_blank">bambooBSC demo video</a> <h3>Who use bambooBSC</h3> <a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/PRESENTACIN-PROPUESTADEDISEODELCUADRODEMANDO-JUDITHMCA.pdf" target="_blank">PROPUESTA DE DISEÑO DEL CUADRO DE MANDO INTEGRAL PARA LA TOMA DE DECISIONES EN EL INSTITUTO FINLAY DE VACUNAS</a> <h2>bambooBSC architecture</h2> <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/bamboobsc_05_web_arch.png"/> <h2>License</h2> bambooBSC is released under version 2.0 of the Apache Version 2.0 <h2>VM version install document:</h2> <a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/install-vm-ver.pdf">install-vm-ver.pdf</a> <h2>manual install document:</h2> <a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/install.pdf">install.pdf</a> <h2>manual document:</h2> <a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/bamboobsc-guide.pdf">bamboobsc-guide.pdf</a> <h2>Download:</h2> VM version( need with VirtualBox ): https://github.com/billchen198318/bamboobsc/releases/download/v0.7.8/bamboobsc-0.7.8-RELEASE-VM.7z Manual install version: https://github.com/billchen198318/bamboobsc/releases/download/v0.7.8/bamboobsc-0.7.8-RELEASE.7z contact: chen.xin.nien@gmail.com <h2>Screenshot</h2> 1 Region view. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/REGION_MAP_VIEW.png"/> 2 Workspace. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/WORKSPACE.png"/> 3 KPIs dashboard. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/KPI-DAS.png"/> 4 Employee/Personal BSC report. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/EMPLOYEE-REPORT.png"/> 5 Department BSC report. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/DEPARTMENT-REPORT.png"/> 6 Employee 360 Degree feedback score view. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/DF_PROJECT_SCORE_VIEW.png"/> 7 KPI BSC report. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/KPI-REPORT.png"/> 7 KPI BSC report (coffee chart). <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/COFFEE_CHART.png"/> 8 OLAP Client report. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/OLAP-CLIENT.png"/> 9 Mobile version dashboard view. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/MOBILE-02.png"/> 10 BSC strategy-map. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/BSC-STRATEGY-MAP.png"/> 11 SQL-Client query result as chart. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/SQL-CLIENT-QUERY.png"/> 12 Support the development of integration processes flow. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/BPMN_PROCESS_LIST.png"/> 13 KPI period trends / change(%). <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/KPI-PERIOD-TRENDS.png"/> 14 PDCA Report. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/PDCA-REPORT-03.png"/> 15 PDCA Project history. <img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/PDCA-REPORT-04.png"/>

Install on Linux

1. must first install the MariaDB and JDK8 (JAVA8)


# apt-get install oracle-java8-jdk
# java -version

java version "1.8.0" Java(TM) SE Runtime Environment (build 1.8.0-b132) Java HotSpot(TM) Client VM (build 25.0-b70, mixed mode)

config MariaDB root account's password

# mysqladmin -u root -p password

2. Config MariaDB enable lower_case_table_names=1

# service mysql stop
# vi /etc/mysql/my.cnf

add lower_case_table_names=1

[mysqld]
lower_case_table_names=1

and save my.cnf

# service mysql restart

3. Get bambooBSC environment file

# cd /home
# wget --no-check-certificate https://github.com/billchen198318/bamboobsc/releases/download/v0.7.8/bamboobsc-0.7.8-RELEASE.7z

4. Install P7ZIP

# apt-get install p7zip

5. Extract the archive

# p7zip -d bamboobsc-0.7.8-RELEASE.7z

6. Import bbcore.sql to MariaDB

# cd /home/bamboobsc-07/
# mysql -u root -p

mysql> create database bbcore; mysql> exit;

# mysql bbcore -u root -p < bbcore.sql

7. Config applicationContext-dataSource.properties

config A ( CORE system ). /home/bamboobsc-07/apache-tomcat-8.5.56/webapps/core-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties config B (Balanced Scorecard system ). /home/bamboobsc-07/apache-tomcat-8.5.56/webapps/gsbsc-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties config C (Simple OLAP system ). /home/bamboobsc-07/apache-tomcat-8.5.56/webapps/qcharts-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties config D (Mobile web ). /home/bamboobsc-07/apache-tomcat-8.5.56/webapps/gsbsc-mobile-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties settings dataSource.user and dataSource.password dataSource.user is MariaDB account dataSource.password is MariaDB password

example:

dataSource.user=root
dataSource.password=password

8. The need to create the directory folder, for upload and report source file need.

# cd /var
# mkdir gsbsc gsbsc/upload gsbsc/jasperreport

9. Run bambooBSC

# cd /home/bamboobsc-07/apache-tomcat-8.5.56/bin
# chmod a+x catalina.sh
# chmod a+x shutdown.sh
# chmod a+x startup.sh

add JAVA_OPTS="-Xmx2048M -XX:+UseG1GC -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Duser.language=en -Duser.country=US" to catalina.sh

# ./startup.sh

Wait a few minutes, Use google Chrome or Firefox browser (no support IE) input url ( [IP-Address]:[Port]/core-web/index.action ) example (if server IP-Address is 192.168.1.100) : 192.168.1.100:8080/core-web/index.action

the log file on /tmp/

Install on Amazon EC2 Failed to get local InetAddress for VMID

cannot connect to MariaDB database Please refer to: http://stackoverflow.com/questions/603351/can-we-set-easy-to-remember-hostnames-for-ec2-instances

Build development environments

System required
A. JDK8
B. Eclipse4 or later version
C. Apache Tomcat8

1. Download archives file

click "Download ZIP" button <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/001.png"></img>

2. Unzip the archive file bamboobsc-master.zip

Unzip to C:\home\git\ <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/002.png"></img>

3. Open eclipse

workspace dir input C:\home\git\bamboobsc-master <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/003.png"></img>

4. Configure eclipse

settings Text file encoding to UTF-8 <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/005.png"></img>

5. Import project

a. core-persistence b. core-lib c. core-base d. core-web e. gsbsc-standard f. gsbsc-web g. qcharts-standard h. qcharts-web i. gsbsc-mobile-web j. gsbsc-persistence k. qcharts-persistence <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/004.png"></img> <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/006.png"></img>

config tomcat7 server <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/007.png"></img> <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/008.png"></img>

config core-lib project "ThirdPartyLib" user libraries add External JARs: all jar file on C:\home\git\bamboobsc-master\core-web\WEB-INF\lib\ <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/009.png"></img>

config core-base project "CORE-LIB" user libraries add

Bamboobsc

Install / Use

README