- 由 赵尉余创建于十二月 19, 2024
（本文档仅供参考）
背景
参考命名集示例-根据某字段排序 实现按指定字段排序需求时出现异常，命名集设计如下：
问题1
拖拽命名集后报错：请求列失败 -> 查询失败 -> errorMessageorg.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}' errorStackTrace=java.lang.RuntimeException: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
展开源码
BuildTime: 2024-12-17 17:43:42
TAG: Hotfix_SmartbiV10_5_15_20241216
smartbix.augmenteddataset.util.AugmentedDataSetException: 请求列失败 -> 查询失败 -> errorMessageorg.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
errorStackTrace=java.lang.RuntimeException: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
at mondrian.xmla.SmartbiQueryServlet.lambda$doPost$0(SmartbiQueryServlet.java:601)
at mondrian.xmla.SmartbiQueryServlet.doPost(SmartbiQueryServlet.java:613)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at mondrian.xmla.SmartbiChainInfoFilter.doFilter(SmartbiChainInfoFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:761)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:388)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
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:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:375)
at mondrian.olap4j.MondrianOlap4jPreparedStatement.<init>(MondrianOlap4jPreparedStatement.java:64)
at mondrian.olap4j.FactoryJdbc4Plus$AbstractPreparedStatement.<init>(FactoryJdbc4Plus.java:682)
at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jPreparedStatementJdbc41.<init>(FactoryJdbc41Impl.java:188)
at mondrian.olap4j.FactoryJdbc41Impl.newPreparedStatement(FactoryJdbc41Impl.java:70)
at mondrian.olap4j.MondrianOlap4jConnection.prepareOlapStatement(MondrianOlap4jConnection.java:506)
at mondrian.xmla.SmartbiQueryServlet.getResult(SmartbiQueryServlet.java:754)
at mondrian.xmla.SmartbiQueryServlet.lambda$doPost$0(SmartbiQueryServlet.java:598)
... 28 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{<Set>}'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1000)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:220)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1748)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:139)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
at mondrian.olap.QueryAxis.resolve(QueryAxis.java:229)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:144)
at mondrian.olap.Query.resolve(Query.java:828)
at mondrian.olap.Query.resolve(Query.java:713)
at mondrian.olap.Query.<init>(Query.java:437)
at mondrian.olap.Query.<init>(Query.java:398)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1265)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1097)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:98)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:363)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:359)
at mondrian.server.Locus.execute(Locus.java:90)
at mondrian.server.Locus.execute(Locus.java:75)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356)
... 35 more
at smartbix.augmenteddataset.util.AugmentedDataSetException.create(AugmentedDataSetException.java:61)
at smartbix.augmenteddataset.service.OlapService.getMdxColumns(OlapService.java:1378)
at smartbix.augmenteddataset.service.OlapService.getMdxColumns(OlapService.java:1309)
at smartbix.augmenteddataset.service.OlapService.getMdxColumns(OlapService.java:1295)
at smartbix.augmenteddataset.service.OlapService$$FastClassBySpringCGLIB$$1aefb890.invoke(<generated>)
at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at smartbixlibs.org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
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:762)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
at smartbix.augmenteddataset.service.OlapService$$EnhancerBySpringCGLIB$$978bc2ea.getMdxColumns(<generated>)
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 smartbixlibs.org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at smartbixlibs.org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:903)
at smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:809)
at smartbixlibs.org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
at smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
at smartbixlibs.org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at smartbixlibs.org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:682)
at smartbixlibs.org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
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 smartbix.smartbi.filter.SmartbiXTraceFilter.doFilter(SmartbiXTraceFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbixlibs.org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:94)
at smartbixlibs.org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
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.imitator.NetworkInterceptorFilter.doFilter(NetworkInterceptorFilter.java:43)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
at smartbi.weixin.filter.WxLoginFilter.doFilter(WxLoginFilter.java:246)
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.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:93)
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.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:130)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.LogFilter.doFilter(LogFilter.java:63)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.framework.SmartbiApplicationFilter.doFilter(SmartbiApplicationFilter.java:57)
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:177)
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:885)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1688)
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)
Caused by: smartbix.augmenteddataset.util.AugmentedDataSetException: 查询失败 -> errorMessageorg.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
errorStackTrace=java.lang.RuntimeException: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
at mondrian.xmla.SmartbiQueryServlet.lambda$doPost$0(SmartbiQueryServlet.java:601)
at mondrian.xmla.SmartbiQueryServlet.doPost(SmartbiQueryServlet.java:613)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at mondrian.xmla.SmartbiChainInfoFilter.doFilter(SmartbiChainInfoFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:761)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:388)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
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:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:375)
at mondrian.olap4j.MondrianOlap4jPreparedStatement.<init>(MondrianOlap4jPreparedStatement.java:64)
at mondrian.olap4j.FactoryJdbc4Plus$AbstractPreparedStatement.<init>(FactoryJdbc4Plus.java:682)
at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jPreparedStatementJdbc41.<init>(FactoryJdbc41Impl.java:188)
at mondrian.olap4j.FactoryJdbc41Impl.newPreparedStatement(FactoryJdbc41Impl.java:70)
at mondrian.olap4j.MondrianOlap4jConnection.prepareOlapStatement(MondrianOlap4jConnection.java:506)
at mondrian.xmla.SmartbiQueryServlet.getResult(SmartbiQueryServlet.java:754)
at mondrian.xmla.SmartbiQueryServlet.lambda$doPost$0(SmartbiQueryServlet.java:598)
... 28 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{<Set>}'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1000)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:220)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1748)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:139)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
at mondrian.olap.QueryAxis.resolve(QueryAxis.java:229)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:144)
at mondrian.olap.Query.resolve(Query.java:828)
at mondrian.olap.Query.resolve(Query.java:713)
at mondrian.olap.Query.<init>(Query.java:437)
at mondrian.olap.Query.<init>(Query.java:398)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1265)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1097)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:98)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:363)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:359)
at mondrian.server.Locus.execute(Locus.java:90)
at mondrian.server.Locus.execute(Locus.java:75)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356)
... 35 more
at smartbix.augmenteddataset.util.AugmentedDataSetException.create(AugmentedDataSetException.java:61)
at smartbix.augmenteddataset.olap.impl.OlapQueryService.createException(OlapQueryService.java:529)
at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:679)
at smartbix.augmenteddataset.olap.impl.OlapQueryService$$FastClassBySpringCGLIB$$d01e6225.invoke(<generated>)
at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
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:762)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
at smartbix.augmenteddataset.olap.impl.OlapQueryService$$EnhancerBySpringCGLIB$$d1e27007.executeQuery(<generated>)
at smartbix.augmenteddataset.service.OlapService.getMdxColumns(OlapService.java:1338)
... 88 more
Caused by: java.lang.RuntimeException: errorMessageorg.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
errorStackTrace=java.lang.RuntimeException: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
at mondrian.xmla.SmartbiQueryServlet.lambda$doPost$0(SmartbiQueryServlet.java:601)
at mondrian.xmla.SmartbiQueryServlet.doPost(SmartbiQueryServlet.java:613)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at mondrian.xmla.SmartbiChainInfoFilter.doFilter(SmartbiChainInfoFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:761)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:388)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
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:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.olap4j.OlapException: mondrian gave exception while parsing query:Mondrian Error:No function matches signature '{<Set>}'
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:375)
at mondrian.olap4j.MondrianOlap4jPreparedStatement.<init>(MondrianOlap4jPreparedStatement.java:64)
at mondrian.olap4j.FactoryJdbc4Plus$AbstractPreparedStatement.<init>(FactoryJdbc4Plus.java:682)
at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jPreparedStatementJdbc41.<init>(FactoryJdbc41Impl.java:188)
at mondrian.olap4j.FactoryJdbc41Impl.newPreparedStatement(FactoryJdbc41Impl.java:70)
at mondrian.olap4j.MondrianOlap4jConnection.prepareOlapStatement(MondrianOlap4jConnection.java:506)
at mondrian.xmla.SmartbiQueryServlet.getResult(SmartbiQueryServlet.java:754)
at mondrian.xmla.SmartbiQueryServlet.lambda$doPost$0(SmartbiQueryServlet.java:598)
... 28 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{<Set>}'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1000)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:220)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1748)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:139)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
at mondrian.olap.QueryAxis.resolve(QueryAxis.java:229)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:144)
at mondrian.olap.Query.resolve(Query.java:828)
at mondrian.olap.Query.resolve(Query.java:713)
at mondrian.olap.Query.<init>(Query.java:437)
at mondrian.olap.Query.<init>(Query.java:398)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1265)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1097)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:98)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:363)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:359)
at mondrian.server.Locus.execute(Locus.java:90)
at mondrian.server.Locus.execute(Locus.java:75)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356)
... 35 more
at smartbix.augmenteddataset.olap.impl.OlapQueryExceptionHandler.handleException(OlapQueryExceptionHandler.java:46)
at smartbix.augmenteddataset.olap.impl.OlapQueryService.throwRequestFailException(OlapQueryService.java:803)
at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:677)
... 99 more
原因&解决办法
报错是提示格式不对，检查排序字段发现是从【维度】下拖拽过来的，需要改成成【度量】下拖拽
问题2
在仪表盘-交叉表拖新建的命名集预览后，发现多了一列(all) 和 小计行，能否不显示？
原因&解决办法
出现列(all) 和 小计行是因为命名集创建时拖拽的是维度下的【dt】，需要改成拖拽低下的级别【dt】，具体见下图说明
- 无标签
