CBoard

An open BI Dashboard platform that supports interactive multi-dimensional report design and data analysis

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

Screenshot

Near Realtime data refresh

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

Features Of CBoard

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

![image](https://cloud.githubusercontent.com/assets/6037522/20123306/429b8f8c-a659-11e6-9954-8f9352d3d9ef.png)

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

Demo (Click pics for full screen demo!)

Load Data from query or DataSet	Basic Operation

Switch Chart Type	Calculated Measure

Add Dashboard Parameters	Use Parameters

Access Control

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步

How to build project

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

Access CBoard

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

Road Map

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

For more detailed Chinese document CBoard 中文文档

For more detailed English document CBoard Wiki

Contact us

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: peter.zhang921@gmail.com, g.yuanyf@gmail.com
Front-end question：fine0830@outlook.com

wedon665/CBoard