Skip to content

bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence (BI) Web platform, Strategic management, Departments Performance Analysis, Employee Performance Analysis, Key Performance Indicators (KPIs), KPI report, Department/Personal balanced scorecard report, region performance view, BSC Strategy MAP, KPI dashboard, SWOT and report…

chrmorais/bamboobsc

 
 

Repository files navigation


Join the chat at https://gitter.im/billchen198318/bamboobsc

bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence



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

bambooBSC architecture




License

bambooBSC is released under version 2.0 of the Apache Version 2.0

install document:

install.pdf

manual document:

bamboobsc-guide.pdf

Download:

https://github.com/billchen198318/bamboobsc/releases/download/v0.6.1/bamboobsc-0.6.1.7z

contact: chen.xin.nien@gmail.com

Screenshot



1 Region view.



2 Workspace.



3 KPIs dashboard.



4 Employee/Personal BSC report.



5 Department BSC report.



6 Employee 360 Degree feedback score view.



7 KPI BSC report.



7 KPI BSC report (coffee chart).



8 OLAP Client report.



9 Mobile version KPIs view.



10 BSC strategy-map.



11 SQL-Client query result as chart.



12 Support the development of integration processes flow.



13 KPI period trends / change(%).




###Install on Windows install step video: https://www.youtube.com/watch?v=pM3q9udreDo

###Install on Linux ###1. must first install the MySQL and JDK8

# apt-get install mysql-server
# 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 MySQL root account's password

# mysqladmin -u root -p password

###2. Config MySQL 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/pi
# wget --no-check-certificate https://github.com/billchen198318/bamboobsc/releases/download/v0.6.1/bamboobsc-0.6.1.7z

###4. Install P7ZIP

# apt-get install p7zip

###5. Extract the archive

# p7zip -d bamboobsc-0.6.1.7z

###6. Import bbcore.sql to MySQL

# cd /home/pi/bamboobsc-06/
# 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/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/core-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

config B (Balanced Scorecard system ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/gsbsc-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

config C (Simple OLAP system ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/qcharts-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

config D (Mobile web ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/gsbsc-mobile-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

settings dataSource.user and dataSource.password
dataSource.user is MySQL account
dataSource.password is MySQL 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/pi/bamboobsc-06/apache-tomcat-7.0.65/bin
# chmod a+x catalina.sh
# chmod a+x shutdown.sh
# chmod a+x startup.sh

add JAVA_OPTS="-Xmx700M -client -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -XX:GCTimeRatio=2 -XX:AdaptiveSizePolicyWeight=90" 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 MySQL 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 Tomcat7

###1. Download archives file click "Download ZIP" button

###2. Unzip the archive file bamboobsc-master.zip Unzip to C:\home\git\

###3. Open eclipse workspace dir input C:\home\git\bamboobsc-master

###4. Configure eclipse settings Text file encoding to UTF-8

###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

config tomcat7 server

config core-lib project "ThirdPartyLib" user libraries
add External JARs: all jar file on C:\home\git\bamboobsc-master\core-web\WEB-INF\lib\

config core-base project "CORE-LIB" user libraries
add External JARs: "core-persistence.jar" and "core-lib.jar" on C:\home\git\bamboobsc-master\core-export-lib\

config gsbsc-standard project "CORE-BASE" user libraries
add External JARs: "core-base.jar", "gsbsc-persistence.jar" on C:\home\git\bamboobsc-master\core-export-lib\

###5. Clean Java Problems ( if found Java Problem on Markers )

  1. Clean all project
  2. Restart

no found Java Problem, Environment Setup Complete

About

bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence (BI) Web platform, Strategic management, Departments Performance Analysis, Employee Performance Analysis, Key Performance Indicators (KPIs), KPI report, Department/Personal balanced scorecard report, region performance view, BSC Strategy MAP, KPI dashboard, SWOT and report…

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 97.7%
  • CSS 1.7%
  • FreeMarker 0.3%
  • PHP 0.2%
  • XSLT 0.1%
  • ActionScript 0.0%