[ABI 5.2] 树形下拉框联动问题

您这个维表是通用维还是层级维呢

您好，我本地测试了一下，直接用dim函数就可以实现需求，
详细说明文档可参考  https://help.esensoft.com/doc-view-520.html

截图202202231038024538.png (22.6 KB, 下载次数: )

下载附件

2022-2-23 10:38 上传

截图202202231038238628.png (37.58 KB, 下载次数: )

下载附件

2022-2-23 10:38 上传

截图202202231039301066.png (12.59 KB, 下载次数: )

下载附件

2022-2-23 10:39 上传

试试勾选参数的自动过滤属性，不需要写过滤条件

报错详情：
组织下拉框自动过滤选项勾选后、过滤条件拿掉了，组织下拉框选择任意一个选项，点击计算按钮时报如下错误（注：不勾选任何选项时，点击计算不报错，但不勾选没法实现我想要的功能）：
并行计算报表模板时出现如下异常：[GRID3(0.1.7.2)]计算浮动表元 GRID3->B2 (ZFAJTJBGMX.case_order_code)时出错：在准备维表数据时发生异常： Data truncation: Data too long for column 'DIMTABLE_' at row 1，详情：com.esen.exception.RuntimeException4I18N: [GRID3(0.1.7.2)]计算浮动表元 GRID3->B2 (ZFAJTJBGMX.case_order_code)时出错：在准备维表数据时发生异常： Data truncation: Data too long for column 'DIMTABLE_' at row 1   at com.esen.jdbc.orm.impl.ExecuterImpl.add(ExecuterImpl.java:131)   at com.esen.jdbc.orm.impl.ExecuterProxy.add(ExecuterProxy.java:69)   at com.esen.jdbc.orm.impl.SessionImpl.add(SessionImpl.java:284)   at com.esen.ecore.repository.AbstractRepository.add(dc:734)   at com.esen.ecore.repository.AbstractRepository$$FastClassBySpringCGLIB$$9149409c.invoke()   at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)   at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:737)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)   at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)   at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:283)   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)   at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)   at org.springframework.cache.interceptor.CacheAspectSupport.invokeOperation(CacheAspectSupport.java:342)   at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:405)   at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:324)   at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)   at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:672)   at com.esen.eanalysemgr.dim.RecordDimsInfoEntityRepository$$EnhancerBySpringCGLIB$$8d348a36.add()   at com.esen.eanalysemgr.dim.RecordDimsInfoServiceImpl.recordDimInfo(RecordDimsInfoServiceImpl.java:101)   at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.checkPrepareDimTablesDataInSql(OlapResultMultImpl.java:1220)   at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.checkPrepareDimTables(OlapResultMultImpl.java:1105)   at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.prepareInterfaceDimDatas(OlapResultMultImpl.java:1255)   at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.queryData(OlapResultMultImpl.java:400)   at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.doit(OlapResultMultImpl.java:266)   at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.(OlapResultMultImpl.java:118)   at com.esen.ebibase.rptbase.calc.db.top.CalcOlapResult.calcGroupOlap(CalcOlapResult.java:79)   at com.esen.ebibase.rptbase.calc.impl.GroupOlapEngine.calc(GroupOlapEngine.java:36)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.calcOlap(OLTPResultManager.java:610)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpResult(OLTPResultManager.java:599)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData4AutoOlap(OLTPResultManager.java:159)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData(OLTPResultManager.java:89)   at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportCalc.getOltpData(FxBaseAnalyseReportCalc.java:506)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.getOltpData(FloatFxqCalc.java:251)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.getOltpData(FloatFxqInnerCalc.java:81)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1369)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1340)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata_group_A_ds(FloatFxqInnerCalc.java:1058)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata_group(FloatFxqInnerCalc.java:1033)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata(FloatFxqInnerCalc.java:1004)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_oltp(FloatFxqInnerCalc.java:937)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float(FloatFxqInnerCalc.java:891)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult(FloatFxqInnerCalc.java:150)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.calc(FloatFxqInnerCalc.java:60)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:247)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatRectInFxqResultImpl.processResult(FloatRectInFxqResultImpl.java:56)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.processResult(RectsInFxqResultImpl.java:103)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqResultImpl.processResult(FloatFxqResultImpl.java:121)   at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:83)   at com.esen.ebibase.rptbase.calc.impl.FxCalc.calc(FxCalc.java:34)   at com.esen.ebibase.rptbase.calc.impl.cache.RequestTask_FxqCalc.doRun(RequestTask_FxqCalc.java:107)   at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)   at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)   at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)   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) Caused by: com.esen.exception.RuntimeException4I18N: 在准备维表数据时发生异常： Data truncation: Data too long for column 'DIMTABLE_' at row 1   ... 63 more Caused by: com.esen.jdbc.orm.ORMSQLException: Data truncation: Data too long for column 'DIMTABLE_' at row 1   ... 63 more

是的。报一样的错.
数据库：达梦8.1