# bamboobsc

**Repository Path**: mirrors/bamboobsc

## Basic Information

- **Project Name**: bamboobsc
- **Description**: 平衡计分卡简称「BSC」(Balanced Scorecard)于1992年由哈佛大学名师罗伯·卡普兰及大卫·诺顿(David Norton)首度提出,其最早的用意在于解决传统的绩
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: https://www.oschina.net/p/bamboobsc
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2020-07-24
- **Last Updated**: 2025-12-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

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

<br>

<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:<br/>
1. BSC's Vision, Perspectives, Objectives of strategy, Key Performance Indicators (KPIs). and Maintain measure-data.<br/>
2. KPI report, Personal and organization BSC report. can custom workspace's layout<br/>
3. Strategy Map, and BSC SWOT.<br/>
4. Provides SQL client query results show as Chart ( PIE, BAR, LINE, AREA ).<br/>
5. Provides a simple OLAP client query.<br/>
6. Provides Sourcecard query for mobile-device browser.<br/>
7. PDCA & PDCA report.
<br/><br/>



<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"/><br/>
<br/><br/>
<h2>License</h2>
bambooBSC is released under version 2.0 of the Apache Version 2.0
<br/><br/>
<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>
<br/>
<h2>manual install document:</h2>
<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/install.pdf">install.pdf</a>
<br/><br/>
<h2>manual document:</h2>
<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/bamboobsc-guide.pdf">bamboobsc-guide.pdf</a>
<br/><br/>
<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
<br/>
Manual install version:
https://github.com/billchen198318/bamboobsc/releases/download/v0.7.8/bamboobsc-0.7.8-RELEASE.7z
<br/><br/>
contact: chen.xin.nien@gmail.com
<br/><br/>

<h2>Screenshot</h2>
<br/>
<br/>1 Region view.
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/REGION_MAP_VIEW.png"/><br/>
<br/>2 Workspace.
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/WORKSPACE.png"/><br/>
<br/>3 KPIs dashboard.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/KPI-DAS.png"/><br/>
<br/>4 Employee/Personal BSC report.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/EMPLOYEE-REPORT.png"/><br/>
<br/>5 Department BSC report.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/DEPARTMENT-REPORT.png"/><br/>
<br/>6 Employee 360 Degree feedback score view.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/DF_PROJECT_SCORE_VIEW.png"/><br/>
<br/>7 KPI BSC report.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/KPI-REPORT.png"/><br/>
<br/>7 KPI BSC report (coffee chart).
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/COFFEE_CHART.png"/><br/>
<br/>8 OLAP Client report.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/OLAP-CLIENT.png"/><br/>
<br/>9 Mobile version dashboard view.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/MOBILE-02.png"/><br/>
<br/>10 BSC strategy-map.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/BSC-STRATEGY-MAP.png"/><br/>
<br/>11 SQL-Client query result as chart.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/SQL-CLIENT-QUERY.png"/><br/>
<br/>12 Support the development of integration processes flow.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/BPMN_PROCESS_LIST.png"/><br/>
<br/>13 KPI period trends / change(%).
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/KPI-PERIOD-TRENDS.png"/><br/>
<br/>14 PDCA Report.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/PDCA-REPORT-03.png"/><br/>
<br/>15 PDCA Project history.
<br/>
<img src="https://raw.githubusercontent.com/billchen198318/bamboobsc/master/core-doc/bamboobsc-pic/PDCA-REPORT-04.png"/><br/>

<br/>
<br/>

### 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;<br/>
mysql> exit;<br/>
```
# mysql bbcore -u root -p < bbcore.sql
```

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

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, <br/> 
Use <b>google Chrome</b> or <b>Firefox</b> browser (<b>no support IE</b>) input url ( <b>[IP-Address]:[Port]/core-web/index.action</b> )
example (if server IP-Address is 192.168.1.100) :<br/>
192.168.1.100:8080/core-web/index.action
<br/>

the log file on /tmp/

<br/>

### Install on Amazon EC2 Failed to get local InetAddress for VMID

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

<br/>
<br/>

### Build development environments
```
System required
A. JDK8
B. Eclipse4 or later version
C. Apache Tomcat8
```

### 1. Download archives file
click "Download ZIP" button<br/>
<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\ <br/>
<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<br/>
<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<br/>
<img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/005.png"></img>

### 5. Import project
   a. core-persistence<br/>
   b. core-lib<br/>
   c. core-base<br/>
   d. core-web<br/>
   e. gsbsc-standard<br/>
   f. gsbsc-web<br/>
   g. qcharts-standard<br/>
   h. qcharts-web<br/>
   i. gsbsc-mobile-web<br/>
   j. gsbsc-persistence<br/>
   k. qcharts-persistence<br/>
   <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<br/> 
   <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 <b>core-lib</b> project "ThirdPartyLib" user libraries<br/>
   add External JARs: all jar file on C:\home\git\bamboobsc-master\core-web\WEB-INF\lib\ <br/> 
   <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/009.png"></img>
   
   
   config <b>core-base</b> project "CORE-LIB" user libraries<br/>
   add External JARs: "core-persistence.jar" and "core-lib.jar" on C:\home\git\bamboobsc-master\core-export-lib\ <br/>
   <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/010.png"></img>
   
   
   config <b>gsbsc-standard</b> project "CORE-BASE" user libraries<br/>
   add External JARs: "core-base.jar", "gsbsc-persistence.jar" on C:\home\git\bamboobsc-master\core-export-lib\ <br/>
   <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/011.png"></img>
   
### 5. Clean Java Problems ( if found Java Problem on Markers )
   1. Clean all project 
   2. Restart

   no found Java Problem, Environment Setup Complete<br/>
   <img src="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/BUILD_DEV_ENV/012.png"></img>



# bambooBSC development manual

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/01-Entity.md">01 - Entitiy</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/02-DaoAndService.md">02 - DAO and Service</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/03-LogicService.md">03 - Logic service</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/04-ControllerAction.md">04 - Controller</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/05-ProgramRegistrationAndMenuSettings.md">05 - Program registration and Menu settings</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/06-RoleAndAuthoritySettings.md">06 - Role and authority settings</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/07-ExpressionSupportLogicService.md">07 - Expression support Logic Service</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/08-WebService.md">08 - WebService</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/09-JasperReport.md">09 - JasperReport</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/10-BPMN.md">10 - BPMN resource</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/11-Mail.md">11 - Mail</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/12-Job.md">12 - Job Scheduler</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/13-Template.md">13 - Template</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/14-WebContextBean.md">14 - Web Context bean</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/15-Formula.md">15 - Formula</a>
<br/>

<a href="https://github.com/billchen198318/bamboobsc/blob/master/core-doc/dev-docs/16-API.md">16 - API</a>
<br/>

<br>
<br>
<br>