三月上旬新内容速递丨选图攻略、内存优化与场景深化

春风送暖,学习相伴!三月上旬更新聚焦数据可视化选图、内存管理技巧、频率分析与桑基图应用,助你轻松驾驭数据分析新场景!

一、场景应用精选

【数析课堂】频率分析:用“数数”快速定位业务痛点》→通过频率统计,快速发现高频问题,精准定位业务改进点。
【桑基图】流动的“资金河流”,一眼看透业务流向》→学习桑基图绘制,追踪资金流动路径,洞察业务流转全貌。

二、技术经验分享

不止选类型,更要找对入口:数据分析选图全攻略》→深入讲解图表选择的核心逻辑,助你告别“图表选择困难症”。
内存溢出别慌张:教你如何看懂BI的“胃”,并管住它的“嘴”》→揭秘BI内存机制,掌握优化技巧,让分析更流畅。

四、社区日志更新

2026年「月更日志」社区更新合集 2.1 - 2.28》→汇总二月社区更新动态,记录成长每一步。

六、任务持续上线

【BI知识闯关】不止选类型,更要找对入口:数据分析选图全攻略》→通过闯关巩固选图知识,提升实战应用能力。
【数析课堂】频率分析知识巩固》→配套练习,加深频率分析理解,强化业务洞察。
【图表应用】桑基图追踪资金流向,发现业务奥秘》→动手实践桑基图,探索资金流向中的业务规律。
【BI知识闯关】内存溢出别慌张:教你如何看懂BI的“胃”,并管住它的“嘴”》→挑战内存管理知识,成为BI优化高手。


阳春三月,学习正当时,快来社区参与挑战,一起探索数据新视界!

麦粉社区
>
帖子详情

excel融合分析数据刷新的时候报错?

数据准备 发表于 2023-7-10 10:34
发表于 2023-7-10 10:34:57
本帖最后由 谢谢 于 2023-7-15 13:09 编辑

excel融合分析数据刷新的时候报错,先在数据集查询了sql,然后在excel把数据拖出来,点击刷新的时候报错了,不知道什么原因,求助

展开看一下详细信息,或是将系统日志导出发出来看看
8063464ab70eec3a83.png
  •   谢谢
    [Sheet2][表1($A$1 数据来源:e4cd112e9bad75bd68886c69db72fe56)]未指定错误,请查看详细信息
    	at smartbi.spreadsheetreport.core.ExcelDataServlet.service(Smartbi:176)
    	at ...(...)
    	at smartbi.spreadsheetreport.core.GridDataFactory.buildSelfQueryData(Smartbi:3346)
    Caused by: java.lang.NullPointerException
    	at smartbi.spreadsheetreport.core.GridDataFactory.buildSelfQueryData(Smartbi:3346)
    	at smartbi.spreadsheetreport.core.GridDataFactory.processSelfQueryData(Smartbi:1920)
    	at smartbi.spreadsheetreport.core.GridDataFactory.openSimpleReports(Smartbi:1737)
    	at smartbi.spreadsheetreport.core.ExcelDataServlet.service(Smartbi:132)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:249)
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:276)
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:127)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:87)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:98)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:240)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:64)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:131)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367)
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882)
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1693)
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:748)
    
    (详细信息是这样的,看不懂)
    2023-7-10 10:50| 回复
  •   一周只洗一次澡的脏脏包
     回复 谢谢
    导入系统日志发出来看看呗
    2023-7-10 10:54| 回复
  •   谢谢
    哪一份呀
    2023-7-10 10:59| 回复
  •   一周只洗一次澡的脏脏包
     回复 谢谢
    详细信息后面不是有一个导出系统日志按钮嘛?直接点击导出系统日志就好
    2023-7-10 11:00| 回复
  •   谢谢
     回复 一周只洗一次澡的脏脏包

    2023-7-10 11:04| 回复
  • 还有7条回复,点击查看

回复

使用道具 举报

您好,您所反馈的问题已解决,目前官网已提供修复后的新版本,可下载新版本后再验证此问题,感谢您对Smartbi的关注与支持,有任何问题欢迎随时提出交流,我们随时在线为您解答。
2257964abc94709bb3.png

回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

16回帖数 0关注人数 1477浏览人数
最后回复于:2023-7-10 17:03

社区

指南

AI

搜索

快速回复 返回顶部 返回列表