报错

sql有问题吗？你贴出这个数据集的sql看一下

阿姆斯特朗炮 发表于 2024-2-27 09:17
sql有问题吗？你贴出这个数据集的sql看一下

SELECT "Sub1__QryName"."MbrTradeDetailMonth_separate_company_code" AS "company_code", "Sub1__QryName"."MbrTradeDetailMonth_separate_member_province" AS "member_province", "Sub1__QryName"."MbrTradeDetailMonth_separate_member_city" AS "member_city", "Sub1__QryName"."MbrTradeDetailMonth_separate_member_status" AS "member_status", "Sub1__QryName"."MbrTradeDetailMonth_separate_reg_channel" AS "reg_channel"
        , "Sub1__QryName"."MbrTradeDetailMonth_separate_prod_code" AS "prod_code", "Sub1__QryName"."MbrTradeDetailMonth_separate_prod_phase_name" AS "prod_phase_name", "Sub1__QryName"."MbrTradeDetailMonth_separate_prod_series_name" AS "prod_series_name", "Sub1__QryName"."MbrTradeDetailMonth_separate_customer_code" AS "customer_code", "Sub1__QryName"."MbrTradeDetailMonth_separate_customer_name" AS "customer_name"
        , "Sub1__QryName"."MbrTradeDetailMonth_separate_txn_province" AS "txn_province", "Sub1__QryName"."MbrTradeDetailMonth_separate_txn_city" AS "txn_city", "Sub1__QryName"."MbrTradeDetailMonth_separate_saleregion_code" AS "saleregion_code", "Sub1__QryName"."MbrTradeDetailMonth_separate_saleregion_name" AS "saleregion_name", "Sub1__QryName"."MbrTradeDetailMonth_separate_w_insert_date" AS "w_insert_date"
        , "Sub1__QryName"."MbrTradeDetailMonth_separate_batch" AS "batch", "Sub1__QryName"."MbrTradeDetailMonth_separate_store_code" AS "store_code", "Sub1__QryName"."MbrTradeDetailMonth_separate_store_name" AS "store_name", "Sub1__QryName"."MbrTradeDetailMonth_separate_month_code" AS "month_code", "Sub1__QryName"."date_day" AS "date_day"
        , "Sub1__QryName"."oldmem_cnt_m" AS "oldmem_cnt_m", "Sub1__QryName"."newmem_cnt_m" AS "newmem_cnt_m", "Sub1__QryName"."memtxn_cnt_m" AS "memtxn_cnt_m", "Sub1__QryName"."regmem_cnt_m" AS "regmem_cnt_m", "Sub1__QryName"."memtxn_stand_tin_m" AS "memtxn_stand_tin_m"
        , "Sub1__QryName"."memtxn_stand_price_m" AS "memtxn_stand_price_m", "Sub1__QryName"."stand_transfer_amt_m" AS "stand_transfer_amt_m", "Sub1__QryName"."midnewmem_cnt_m" AS "midnewmem_cnt_m", "Sub1__QryName"."effective_newmem_cnt_m" AS "effective_newmem_cnt_m", "Sub1__QryName"."newmem_stand_qty_m" AS "newmem_stand_qty_m"
        , "Sub1__QryName"."oldmem_stand_qty_m" AS "oldmem_stand_qty_m", "Sub1__QryName"."newmem_stand_price_m" AS "newmem_stand_price_m", "Sub1__QryName"."DimSalesRegionDtExt_separate_lv_01_name" AS "lv_01_name", "Sub1__QryName"."DimSalesRegionDtExt_separate_lv_02_name" AS "lv_02_name", "Sub1__QryName"."DimSalesRegionDtExt_separate_lv_03_name" AS "lv_03_name"
        , "Sub1__QryName"."DimSalesRegionDtExt_separate_lv_04_name" AS "lv_04_name", "Sub1__QryName"."Company_name_separate_company_name" AS "company_name"
FROM "dlink"."MbrTransactionMonth" "Sub1__QryName"
LIMIT 100000001

yhdata_AYmNn2eU 发表于 2024-2-27 09:20
SELECT "Sub1__QryName"."MbrTradeDetailMonth_separate_company_code" AS "company_code", "Sub1__QryNa ...

保存数据集的时候，能加载出数据来吗？

阿姆斯特朗炮 发表于 2024-2-27 09:22
保存数据集的时候，能加载出数据来吗？

有数据出来，现在就是制作计算列以及添加过滤筛选栏报错

yhdata_AYmNn2eU 发表于 2024-2-27 09:25
有数据出来，现在就是制作计算列以及添加过滤筛选栏报错

你计算列怎么写的，看一下

yhdata_AYmNn2eU 发表于 2024-2-27 09:25
有数据出来，现在就是制作计算列以及添加过滤筛选栏报错

我感觉，表名加上引号可能会报错吧

阿姆斯特朗炮 发表于 2024-2-27 09:26
你计算列怎么写的，看一下

iif(col['memtxn_cnt_m'] != 0,
col['memtxn_stand_tin_m']/col['memtxn_cnt_m'],0)

yhdata_AYmNn2eU 发表于 2024-2-27 09:30
iif(col['memtxn_cnt_m'] != 0,
col['memtxn_stand_tin_m']/col['memtxn_cnt_m'],0)

看着没啥毛病啊，我试一下

阿姆斯特朗炮 发表于 2024-2-27 09:43
看着没啥毛病啊，我试一下

错误代码:190000045
报告: '会员交易月表20240227091055-1854'   数据集: '会员交易月汇总'   组件: '图表1'   执行用户: 'admin'
异常: 执行数据失败：报告: '会员交易月表20240227091055-1854'   数据集: '会员交易月汇总'   组件: '图表1'   执行用户: 'admin'
原因: 执行SQL失败：“查询没有传回任何结果。”
        at g5.db.RTDashboard.execData(RTDashboard.java:2398)
        at g5.db.RTDashboard.execData(RTDashboard.java:2253)
        at g5.db.impl.DBTool.execData(DBTool.java:5425)
        at g5.db.impl.DBTool.executeElem(DBTool.java:5466)
        at g5.db.impl.DBTool.executeElem(DBTool.java:5444)
        at g5.sv.db.req.UpdateElemReq.process1(UpdateElemReq.java:123)
        at g5.sv.db.req.UpdateElemReq.process0(UpdateElemReq.java:79)
        at g5.sv.Req.process(Req.java:57)
        at g5.sv.db.impl.DBServiceImpl.process(DBServiceImpl.java:1212)
        at g5.sv.db.DBProc.procReq(DBProc.java:1416)
        at g5.sv.db.DBProc.service(DBProc.java:132)
        at g5.sv.ServletHelper.service(ServletHelper.java:122)
        at g5.sv.PortalServlet.service(PortalServlet.java:1464)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at com.yonghongtech.filter.LoginFilter.doFilter0(LoginFilter.java:73)
        at com.yonghong.api.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:59)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
        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.base/java.lang.Thread.run(Thread.java:834)