数据模型计算度量参数

电子表格软件发表于 2024-3-25 13:38

陈强 Lv3 关注ta

发表于 2024-3-25 13:38:18

基于数据模型的电子表格，添加计算度量作为参数后，当输入参数值，报表查询失败，有什么办法解决吗

清澈的愚蠢 Lv6 关注ta

发表于 2024-3-25 15:40:53

报什么错误？把具体的错误信息发上来看看

陈强

查询失败
	at smartbix.augmenteddataset.util.AugmentedDataSetException.create(AugmentedDataSetException.java:34)
	at smartbix.augmenteddataset.olap.impl.OlapQueryService.createException(OlapQueryService.java:594)
	at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:517)
	at smartbix.augmenteddataset.olap.impl.OlapQueryService$$FastClassBySpringCGLIB$$d01e6225.invoke()
	at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at smartbix.augmenteddataset.olap.impl.OlapQueryService$$EnhancerBySpringCGLIB$$2d6f73ff.executeQuery()
	at smartbix.augmenteddataset.query.mondrian.MondrianQueryExecutor.getData(MondrianQueryExecutor.java:33)
	at smartbix.augmenteddataset.handler.DefaultAugmentedDataSetHandler.getDataSetData(DefaultAugmentedDataSetHandler.java:91)
	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService.getDataSetData(AugmentedDataSetQueryService.java:224)
	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$FastClassBySpringCGLIB$$3c7d00ce.invoke()
	at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$EnhancerBySpringCGLIB$$328faea6.getDataSetData()
	at smartbix.smartbi.AugmentedDataSetForVModule.getDataSetData(AugmentedDataSetForVModule.java:690)
	at sun.reflect.GeneratedMethodAccessor1067.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at smartbi.cs.a(Smartbi:82)
	at smartbi.spreadsheetreport.core.selfquery.AugmentedGirdDataQuery.getGridData(Smartbi:118)
	at smartbi.spreadsheetreport.core.GridDataFactory$a.a(Smartbi:490)
	at smartbi.spreadsheetreport.core.GridDataFactory$a.b(Smartbi:207)
	at smartbi.spreadsheetreport.core.GridDataFactory$a.a(Smartbi:189)
	at smartbi.spreadsheetreport.core.GridDataFactory$a.call(Smartbi:134)
	at smartbi.freequery.client.simplereport.JobService$2.call(JobService.java:86)
	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)
	Suppressed: java.lang.NullPointerException
		at smartbix.augmenteddataset.olap.impl.OlapQueryService.getTwoDimensionData(OlapQueryService.java:1186)
		at smartbix.augmenteddataset.olap.impl.OlapQueryService.buildResult(OlapQueryService.java:941)
		at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:510)
		... 38 more

2024-3-25 16:03| 回复

陈强

基于数据模型的即席查询，当用计算度量作为参数的时候，是没有问题的，但是电子表格在参数管理设置后，如果那个计算度量的参数输入了值，就会报这个错

2024-3-25 16:09| 回复

脑袋空空

回复陈强

你的报错是不是没截完整？参数是怎么配置的，可以截图看看

2024-3-29 17:42| 回复

脑袋空空

或者试一下开启SQL引擎的设置想看能不能规避？
说明及操作：https://wiki.smartbi.com.cn/pages/viewpage.action?smt_poid=43&pageId=113542956

2024-3-29 17:43| 回复

使用道具赞举报

返回列表

5回帖数	0关注人数	282浏览人数
最后回复于：2024-3-25 15:40

邀请回答

邀请麦粉解答问题，每天可以发送10次邀请！请勿重复邀请~

头像	昵称	操作
	大傻boy	邀请TA
	Eva_Li	邀请TA
	一周只洗一次澡的脏脏包	邀请TA
	麦本麦	邀请TA
	何超宏	邀请TA
	鬼仔性格	邀请TA