ruisibi/rsbi-pom

睿思BI-数据仪表盘，开源商业智能，数据可视化系统

睿思BI-开源商业智能，数据可视化系统 (开源版)

VUE版本已发布，请访问：https://github.com/ruisibi/rsbi-vue

BI系统支撑库变更说明： 支撑库已更新为sqlite， 直接打成war包即可运行，如果还是需要使用mysql做支撑库，请修改如下配置：

application.properties文件：

 #使用mysql
 jdbc.driver=com.mysql.cj.jdbc.Driver
 jdbc.url=jdbc:mysql://localhost:3306/rs_report?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&serverTimezone=GMT%2B8
 jdbc.username=root
 jdbc.password=12345678

src/main/webapp/WEB-INF/ext2/ext-config/ext-config.xml文件
#修改支撑库为mysql：
<constant name="dbName" value="mysql" />

直接下载war包（sqlite支撑库）：https://www.ruisitech.com/files/rsbi.war (下载后放入tomcat直接运行)

“睿思BI”商业智能系统是由成都睿思商智科技有限公司自主研发的企业数据分析系统。 系统包含数据建模、数据报表、多维分析、仪表盘、移动BI等功能模块，方便企业快速建立一套易用，灵活、低成本的商业智能平台，实现数据的快速分析及可视化。

 

产品特点：

 1.轻量级BI, 支持快速建模，快速可视化数据。
 2.多维分析/报表/仪表盘使用简单，功能强大，通过拖放等方式构建分析界面，支持下钻/上卷/排序/筛选/计算/联动等多种操作方式。
 3.支持移动BI，通过APP随时随地访问报表数据。
 4.开放源码，采用apache2.0开源协议，用户可任意使用而不需我公司授权（标准版除外）。
 

系统功能：

 1.数据源 (支持：mysql/oracle/sqlserver/db2/postgresql/hive/kylin)
2.多维分析
3.数据报表
4.移动BI
5.权限管理

产品安装：

 1.安装数据，系统基于mysql数据库，先创建rs_report数据库，再解压datas/rs_report_data.zip文件，通过 mysql -u root -p rs_report< rs_report_data.bak 命令还原文件到 rs_report 数据库中。
2.安装程序，此项目为maven工程，通过maven打包项目。
3.修改数据库链接文件application.properties,主要修改 username, password 两项内容。
 4.发布到tomcat或通过启动jetty访问

技术支持：

请加QQ群 648548832, 此群为我公司官方技术支持群，你遇到的问题都可以在群里提问。

文档地址： http://www.ruisibi.cn/book.htm
演示地址： http://bi.ruisitech.com/
快速开始： https://blog.csdn.net/zhuifengsn/article/details/79822585

产品截图：

数据多维分析
 
数据可视化
 
数据建模
 
APP访问
 

rsbi-pom's Issues

请问交叉表-可以支持求概率么

例如表格列：月份+租金+【每月租金占这一年租金的概率】

图表维度最大只能设置6个？

是哪里做了限制了么？

ext3包依赖问题

CalendarTag找不到TagSupport类,缺少对javax.servlet.jsp包的依赖.

能成功启动服务，admin登录功能点不全，报表功能无法使用

请问开源版中提及的还原数据库“rs_report_data.bak”这个文件是没有的，压缩包中只有“rs_report.bak”，成功启动服务后，admin账户登录功能点显示不全，新建报表页面也报错，是因为库数据的问题吗

权限管理问题

新建用户权限控制不起作用

源码运行报错 Could not instantiate listener com.ruisi.ext.engine.control.ExtContextLoaderListener

源码编译没有问题，运行时报如下错误(错误内容比较多)：
2018-05-14 18:58:03.609:WARN:oejw.StandardDescriptorProcessor:Scanner-1: Could not instantiate listener com.ruisi.ext.engine.control.ExtContextLoaderListener java.lang.ClassNotFoundException: com.ruisi.ext.engine.control.ExtContextLoaderListener at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:565) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.eclipse.jetty.server.handler.ContextHandler.loadClass(ContextHandler.java:1735) at org.eclipse.jetty.webapp.StandardDescriptorProcessor.visitListener(StandardDescriptorProcessor.java:1915) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.eclipse.jetty.webapp.IterativeDescriptorProcessor.visit(IterativeDescriptorProcessor.java:84) at org.eclipse.jetty.webapp.IterativeDescriptorProcessor.process(IterativeDescriptorProcessor.java:71) at org.eclipse.jetty.webapp.MetaData.resolve(MetaData.java:409) at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1457) at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:287) at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:46) at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:192) at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:505) at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151) at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:180) at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:453) at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64) at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:610) at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:529) at org.eclipse.jetty.util.Scanner.scan(Scanner.java:392) at org.eclipse.jetty.util.Scanner$1.run(Scanner.java:329) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) 2018-05-14 18:58:04.396:INFO:oejs.session:Scanner-1: DefaultSessionIdManager workerName=node0 2018-05-14 18:58:04.397:INFO:oejs.session:Scanner-1: No SessionScavenger set, using defaults 2018-05-14 18:58:04.399:INFO:oejs.session:Scanner-1: node0 Scavenging every 600000ms 2018-05-14 18:58:05.076:WARN:oejs.BaseHolder:Scanner-1: java.lang.ClassNotFoundException: com.ruisi.ext.engine.control.ExtViewServlet at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:565) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.eclipse.jetty.util.Loader.loadClass(Loader.java:65) at org.eclipse.jetty.servlet.BaseHolder.doStart(BaseHolder.java:93) at org.eclipse.jetty.servlet.ServletHolder.doStart(ServletHolder.java:366) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:759) at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:374) at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1497) at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1459) at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:287) at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:46) at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:192) at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:505) at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151) at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:180) at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:453) at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64) at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:610) at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:529) at org.eclipse.jetty.util.Scanner.scan(Scanner.java:392) at org.eclipse.jetty.util.Scanner$1.run(Scanner.java:329) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) 2018-05-14 18:58:05.077:WARN:oejshC.rsbi_4_0:Scanner-1: unavailable javax.servlet.UnavailableException: Class loading error for holder extView@b2264066==com.ruisi.ext.engine.control.ExtViewServlet,jsp=null,order=-1,inst=false at org.eclipse.jetty.servlet.BaseHolder.doStart(BaseHolder.java:100) at org.eclipse.jetty.servlet.ServletHolder.doStart(ServletHolder.java:366) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:759) at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:374) at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1497) at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1459) at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:287) at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:46) at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:192) at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:505) at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151) at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:180) at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:453) at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64) at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:610) at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:529) at org.eclipse.jetty.util.Scanner.scan(Scanner.java:392) at org.eclipse.jetty.util.Scanner$1.run(Scanner.java:329) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) 2018-05-14 18:58:05.196:WARN:oejs.BaseHolder:Scanner-1: java.lang.ClassNotFoundException: com.ruisi.ext.engine.control.ExtControlServlet at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:565) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.eclipse.jetty.util.Loader.loadClass(Loader.java:65) at org.eclipse.jetty.servlet.BaseHolder.doStart(BaseHolder.java:93) at org.eclipse.jetty.servlet.ServletHolder.doStart(ServletHolder.java:366) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:759) at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:374) at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1497) at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1459) at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:287) at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:46) at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:192) at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:505) at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151) at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:180) at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:453) at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64) at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:610) at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:529) at org.eclipse.jetty.util.Scanner.scan(Scanner.java:392) at org.eclipse.jetty.util.Scanner$1.run(Scanner.java:329) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505)

数据库读取的中文页面显示会乱码

睿思BI我部署在tomcat-9上，凡是涉及从mysql数据库读取的中文都会乱码，包括各类组件的标题。
而我的mysql数据库都是保存为utf-8 的，在远程终端能正常显示，但是在BI页面上就显示问号，请问是哪里编码出现问题吗？怎么解决呢？

页面部分乱码

页面出现部分乱码，还有id重复的现象

postgresql数据库非public schema的表建模报错

postgresql数据库非public schema的表建模报错。找不到表。应该是没有指定schema的问题。这个改怎么解决

缓存问题

当我修改数据源时,配置成功但是连接但是多维分析时依旧报数据库连接错误!debug时internalGet(key);获取到的数据库连接依旧是老数据.

java.lang.ClassNotFoundException: com.ruisi.ext.engine.control.ExtContextLoaderListener

程序在启动时候无法找到该类 。
搜索整个工程也没有该文件

java.lang.ClassNotFoundException: com.ruisi.ext.engine.control.ExtContextLoaderListener
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1928)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1771)
at org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:536)
at org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:518)
at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:148)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5073)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5680)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1702)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1692)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)