Server side framework is Spring+MyBatis and front-end is based on AngularJS1 and Bootstrap. The whole architecture graphic is as below:

**Be attention, refresh level is cube level rather than whole dashboard **

• Simple and beautiful interface and layout
• Lightweight architecture and concise source code, the entire project does not rely on any third-party multi-dimensional analysis tools
  • Front page style and layout of CBoard is based on AdminLTE2
  • The chart plugin uses ECharts
  • Javascript uses MVVM AngularJS 1.X framework
• Interactive, drag-and-drop OLAP classisc report development experience
• One dataset, multiple report widgets. Maximize reuse query resoult. But, the first and foremost survival rule in CBoard is make the dataset used in CBoard small using aggregate. Don't worry the source data can be very big. You don't need so many dimension in one chart

• Supports OLAP slice filter operation
• Supports sort multiple columns/rows at the sametime
• Global query cache, to avoid repeated query requests for data
• Support common charts and cross tables
  • Columnar/Stacked vertical and horizontal bar and line mixed chart with dual axis view
  • Pie chart
  • Radar Chart
  • Sanky Chart
  • Funnel Chart
  • KPI Widget
  • Cross-tabulation
  • China Map (**地图, 下一个版本将会支持动态三级下钻, 敬请期待)
  • Other graphs is coming soon
• Support JDBC data connection
• Support to connect one of the most popular open source multi-dimensional analysis of products Saiku2, and will be able to selectively create data and graphics
• Cube level data refresh / realtime chart for quick query
• Easy to implement your own DataProvider to connect any data source. Even for expensive commercial BI suite, it's not possible to connect all the NOSQL and NewSQL data source in the era of big data. Due to the schema of NOSQL are various, such as hash tables, arrays, trees, maps, etc., different people using the same NoSQL products designed Schema may vary widely. The user who most familiar with their storage schema are the user themselves. And it's easy to find a Java programmers to code a Class to connect their own data source. So we leave this part of work to the end user with an easy extended data connection framework in CBoard

Load Data from query or DataSet	Basic Operation

Switch Chart Type	Calculated Measure

Add Dashboard Parameters	Use Parameters

RBAC (Role Based Access Control), easy admin and view your users' role and roles' access resource list in one page.

• Grant roles to user by left Grant button.
• Grant access resource to a role by right Grant button.
• Resource can only be granted to role. A user can act as more than one roles.

1 百度网盘地址 http://pan.baidu.com/s/1slRKJCT 2 进入 0.2.1 目录，下面有两个文件

• cboard.war 这个war包只是单纯的对项目做了编译
• apache-tomcat-8.0.28-cboard.zip 捆绑了tomcat的包，需要更改一些元数据库连接配置，建立元数据表和库就可以直接运行了

3 元数据库Setup过程参考下面的英文文档2, 3步

Before the start, make sure you have setup environment:

• JDK version above 1.8
• MySQL
• Maven
• Tomcat 1 Download or git clone project

git clone https://github.com/yzhang921/CBoard.git

2 Install metadata of CBoard

 take MySQL database as example
-- CREATE DATEBASE cboard;
Execute ddl to create metadata table: _sql/mysql/mysql.sql_

3 Modify metadata connection properties file according to your db environment

CBoard/src/main/resources/config.properties

validationQuery=SELECT 1
jdbc_url=jdbc:mysql://localhost:3306/cboard
jdbc_username=root
jdbc_password=111111

4 Comile and package project with Maven

cd root path of CBoard
# Install SQLServer JDBC Driver into your local respository
mvn install:install-file -Dfile=lib/sqljdbc4-4.0.jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0 -Dpackaging=jar
mvn clean package

5 Deploy war to Tomcat application

• Copy CBoard/target/cboard.war to webapp folder of Tomcat and rename cboard.war to ROOT.war, Make sure deploy app as ROOT, Otherwise the application will not work
• Start up Tomcat

http://_yourserverip_:8080
Default login username and passwor: admin/root123

All tasks are listed in Issue Page group by milestone. Also you can get our development status from Project Page

You can create any issue or requirements through the Issue system of github.
If you like CBoard then use it, contribute to CBoard and don't forget to star it ⭐
Waiting for your Contribution and pull request!

CBoard QQ Group for Chinese: 301028618
Email: [email protected], [email protected]
Front-end question：[email protected]