biaggi Posted July 2, 2008 Share Posted July 2, 2008 Hi this is my first post, im trying to create an analisys view using as datasource a xmla connection. So i created de datasource, the connection to xmla and the xmla definition. Then using ireport created the jrxml and the report unit in jasperserver 3.0, but when i run the report i get this error: Code:net.sf.jasperreports.engine.JRRuntimeException: Parameter "XMLA_DATA_URL" does not exist.net.sf.jasperreports.engine.JRRuntimeException: Parameter "XMLA_DATA_URL" does not exist. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:495) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getParameterValue(JRAbstractQueryExecuter.java:436) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getParameterValue(JRAbstractQueryExecuter.java:448) at net.sf.jasperreports.engine.query.JRXmlaQueryExecuter.<init>(JRXmlaQueryExecuter.java:49) at net.sf.jasperreports.engine.query.JRXmlaQueryExecuterFactory.createQueryExecuter(JRXmlaQueryExecuterFactory.java:56) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:653) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1196) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:833) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:638) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:333) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:765) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:265) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:329) at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Transition.execute(Transition.java:229) at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112) at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:185) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Flow.start(Flow.java:557) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206) at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy13.launch(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131) at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) So edited the report and the data source configuration is empty, only apears the bean datasource. I've tryed to create a new report and the result is the same, so i tryed to create an analisys view whith this error: Code:[code]javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyjavax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy at org.apache.commons.el.Logger.logError(Logger.java:484) at org.apache.commons.el.Logger.logError(Logger.java:588) at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:318) at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145) at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263) at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:190) at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:917) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_if_2(viewOlap_jsp.java:1504) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:231) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Then i activated the lo4j log for soap and checked the soap comunications and for me are ok, this is the response of the server: Code:[code]<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:«»SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"> <SOAP-ENV:Header></SOAP-ENV:Header> <SOAP-ENV:Body> <xmla:ExecuteResponse xmlns:«»xmla="urn:«»schemas-microsoft-com:«»xml-analysis"> <xmla:return> <root xmlns="urn:«»schemas-microsoft-com:«»xml-analysis:mddataset" xmlns:«»xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:«»schemas-microsoft-com:«»xml-analysis:exception" xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance"> <xsd:«»schema targetNamespace="urn:«»schemas-microsoft-com:«»xml-analysis:mddataset" elementFormDefault="qualified" xmlns:«»sql="urn:«»schemas-microsoft-com:«»xml-sql" xmlns:«»xsd="http://www.w3.org/2001/XMLSchema" xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance"> <xsd:complexType name="MemberType"> <xsd:«»sequence> <xsd:element name="UName" type="xsd:«»string"></xsd:element> <xsd:element name="Caption" type="xsd:«»string"></xsd:element> <xsd:element name="LName" type="xsd:«»string"></xsd:element> <xsd:element name="LNum" type="xsd:unsignedInt"></xsd:element> <xsd:element name="DisplayInfo" type="xsd:unsignedInt"></xsd:element> <xsd:«»sequence maxOccurs="unbounded" minOccurs="0"> <xsd:any processContents="lax" maxOccurs="unbounded"></xsd:any> </xsd:«»sequence> </xsd:«»sequence> <xsd:attribute name="Hierarchy" type="xsd:«»string"></xsd:attribute> </xsd:complexType> <xsd:complexType name="PropType"> <xsd:attribute name="name" type="xsd:«»string"></xsd:attribute> </xsd:complexType> <xsd:complexType name="TupleType"> <xsd:«»sequence maxOccurs="unbounded"> <xsd:element name="Member" type="MemberType"></xsd:element> </xsd:«»sequence> </xsd:complexType> <xsd:complexType name="MembersType"> <xsd:«»sequence maxOccurs="unbounded"> <xsd:element name="Member" type="MemberType"></xsd:element> </xsd:«»sequence> <xsd:attribute name="Hierarchy" type="xsd:«»string"></xsd:attribute> </xsd:complexType> <xsd:complexType name="TuplesType"> <xsd:«»sequence maxOccurs="unbounded"> <xsd:element name="Tuple" type="TupleType"></xsd:element> </xsd:«»sequence> </xsd:complexType> <xsd:complexType name="CrossProductType"> <xsd:«»sequence> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <xsd:element name="Members" type="MembersType"></xsd:element> <xsd:element name="Tuples" type="TuplesType"></xsd:element> </xsd:choice> </xsd:«»sequence> <xsd:attribute name="Size" type="xsd:unsignedInt"></xsd:attribute> </xsd:complexType> <xsd:complexType name="OlapInfo"> <xsd:«»sequence> <xsd:element name="CubeInfo"> <xsd:complexType> <xsd:«»sequence> <xsd:element name="Cube" maxOccurs="unbounded"> <xsd:complexType> <xsd:«»sequence> <xsd:element name="CubeName" type="xsd:«»string"></xsd:element> </xsd:«»sequence> </xsd:complexType> </xsd:element> </xsd:«»sequence> </xsd:complexType> </xsd:element> <xsd:element name="AxesInfo"> <xsd:complexType> <xsd:«»sequence> <xsd:element name="AxisInfo" maxOccurs="unbounded"> <xsd:complexType> <xsd:«»sequence> <xsd:element name="HierarchyInfo" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:«»sequence> <xsd:«»sequence maxOccurs="unbounded"> <xsd:element name="UName" type="PropType"></xsd:element> <xsd:element name="Caption" type="PropType"></xsd:element> <xsd:element name="LName" type="PropType"></xsd:element> <xsd:element name="LNum" type="PropType"></xsd:element> <xsd:element name="DisplayInfo" type="PropType" minOccurs="0" maxOccurs="unbounded"></xsd:element> </xsd:«»sequence> <xsd:«»sequence> <xsd:any processContents="lax" minOccurs="0" maxOccurs="unbounded"></xsd:any> </xsd:«»sequence> </xsd:«»sequence> </xsd:complexType> <xsd:attribute name="name" type="xsd:«»string" use="required"></xsd:attribute> </xsd:element> </xsd:«»sequence> <xsd:attribute name="name" type="xsd:«»string"></xsd:attribute> </xsd:complexType> </xsd:element> </xsd:«»sequence> </xsd:complexType> </xsd:element> <xsd:element name="CellInfo"> <xsd:complexType> <xsd:«»sequence> <xsd:«»sequence minOccurs="0" maxOccurs="unbounded"> <xsd:choice> <xsd:element name="Value" type="PropType"></xsd:element> <xsd:element name="FmtValue" type="PropType"></xsd:element> <xsd:element name="BackColor" type="PropType"></xsd:element> <xsd:element name="ForeColor" type="PropType"></xsd:element> <xsd:element name="FontName" type="PropType"></xsd:element> <xsd:element name="FontSize" type="PropType"></xsd:element> <xsd:element name="FontFlags" type="PropType"></xsd:element> <xsd:element name="FormatString" type="PropType"></xsd:element> <xsd:element name="NonEmptyBehavior" type="PropType"></xsd:element> <xsd:element name="SolveOrder" type="PropType"></xsd:element> <xsd:element name="Updateable" type="PropType"></xsd:element> <xsd:element name="Visible" type="PropType"></xsd:element> <xsd:element name="Expression" type="PropType"></xsd:element> </xsd:choice> </xsd:«»sequence> <xsd:«»sequence maxOccurs="unbounded" minOccurs="0"> <xsd:any processContents="lax" maxOccurs="unbounded"></xsd:any> </xsd:«»sequence> </xsd:«»sequence> </xsd:complexType> </xsd:element> </xsd:«»sequence> </xsd:complexType> <xsd:complexType name="Axes"> <xsd:«»sequence maxOccurs="unbounded"> <xsd:element name="Axis"> <xsd:complexType> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <xsd:element name="CrossProduct" type="CrossProductType"></xsd:element> <xsd:element name="Tuples" type="TuplesType"></xsd:element> <xsd:element name="Members" type="MembersType"></xsd:element> </xsd:choice> <xsd:attribute name="name" type="xsd:«»string"></xsd:attribute> </xsd:complexType> </xsd:element> </xsd:«»sequence> </xsd:complexType> <xsd:complexType name="CellData"> <xsd:«»sequence> <xsd:element name="Cell" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:«»sequence maxOccurs="unbounded"> <xsd:choice> <xsd:element name="Value"></xsd:element> <xsd:element name="FmtValue" type="xsd:«»string"></xsd:element> <xsd:element name="BackColor" type="xsd:unsignedInt"></xsd:element> <xsd:element name="ForeColor" type="xsd:unsignedInt"></xsd:element> <xsd:element name="FontName" type="xsd:«»string"></xsd:element> <xsd:element name="FontSize" type="xsd:unsignedShort"></xsd:element> <xsd:element name="FontFlags" type="xsd:unsignedInt"></xsd:element> <xsd:element name="FormatString" type="xsd:«»string"></xsd:element> <xsd:element name="NonEmptyBehavior" type="xsd:unsignedShort"></xsd:element> <xsd:element name="SolveOrder" type="xsd:unsignedInt"></xsd:element> <xsd:element name="Updateable" type="xsd:unsignedInt"></xsd:element> <xsd:element name="Visible" type="xsd:unsignedInt"></xsd:element> <xsd:element name="Expression" type="xsd:«»string"></xsd:element> </xsd:choice> </xsd:«»sequence> <xsd:attribute name="CellOrdinal" type="xsd:unsignedInt" use="required"></xsd:attribute> </xsd:complexType> </xsd:element> </xsd:«»sequence> </xsd:complexType> <xsd:element name="root"> <xsd:complexType> <xsd:«»sequence maxOccurs="unbounded"> <xsd:element name="OlapInfo" type="OlapInfo"></xsd:element> <xsd:element name="Axes" type="Axes"></xsd:element> <xsd:element name="CellData" type="CellData"></xsd:element> </xsd:«»sequence> </xsd:complexType> </xsd:element> </xsd:«»schema> <OlapInfo> <CubeInfo> <Cube> <CubeName>cube_name</CubeName> </Cube> </CubeInfo> <AxesInfo> <AxisInfo name="Axis0"> <HierarchyInfo name="Measures"> <UName name="[Measures].[member_UNIQUE_NAME]"></UName> <Caption name="[Measures].[member_CAPTION]"></Caption> <LName name="[Measures].[LEVEL_UNIQUE_NAME]"></LName> <LNum name="[Measures].[LEVEL_NUMBER]"></LNum> <DisplayInfo name="[Measures].[DISPLAY_INFO]"></DisplayInfo> </HierarchyInfo> </AxisInfo> <AxisInfo name="Axis1"> <HierarchyInfo name="facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura"> <UName name="[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[member_UNIQUE_NAME]"></UName> <Caption name="[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[member_CAPTION]"></Caption> <LName name="[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[LEVEL_UNIQUE_NAME]"></LName> <LNum name="[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[LEVEL_NUMBER]"></LNum> <DisplayInfo name="[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[DISPLAY_INFO]"></DisplayInfo> </HierarchyInfo> </AxisInfo> <AxisInfo name="SlicerAxis"></AxisInfo> </AxesInfo> <CellInfo> <Value name="VALUE"></Value> <FmtValue name="FORMATTED_VALUE"></FmtValue> <FormatString name="FORMAT_STRING"></FormatString> </CellInfo> </OlapInfo> <Axes> <Axis name="Axis0"> <Tuples> <Tuple> <Member Hierarchy="Measures"> <UName>[Measures].[sUM of facturasprocesadasmecanica_dw.total]</UName> <Caption>SUM of facturasprocesadasmecanica_dw.total</Caption> <LName>[Measures].[MeasuresLevel]</LName> <LNum>0</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> <Axis name="Axis1"> <Tuples> <Tuple> <Member Hierarchy="facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura"> <UName>[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[All facturasprocesadasmecanica_dw.tipofactura]</UName> <Caption>All facturasprocesadasmecanica_dw.tipofactura</Caption> <LName>[facturasprocesadasmecanica_dw.tipofactura.facturasprocesadasmecanica_dw.tipofactura].[(All)]</LName> <LNum>0</LNum> <DisplayInfo>2</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> <Axis name="SlicerAxis"> <Tuples> <Tuple></Tuple> </Tuples> </Axis> </Axes> <CellData> <Cell CellOrdinal="0"> <Value xsi:type="xsd:int">221744.6962</Value> <FmtValue>221744.696</FmtValue> <FormatString>#.##0</FormatString> </Cell> </CellData> </root> </xmla:return> </xmla:ExecuteResponse> </SOAP-ENV:Body></SOAP-ENV:Envelope> Any hint on my problem? Is an error or just a missconfiguration? Im stucked at this point :( Link to comment Share on other sites More sharing options...
swood Posted July 7, 2008 Share Posted July 7, 2008 What data source did you set for the report? It needs to be an XML/A connection. ShermanJaspersoft Link to comment Share on other sites More sharing options...
biaggi Posted July 25, 2008 Author Share Posted July 25, 2008 Sorry for the delay, Finally solved the problem, was a missconfiguration,This steps works for me1.- configure and use a xmla connection2.- write a bean to get the info from the applicationcontext (and configure it in the applicationcontext.xml)3.- copy cincom and rex jars from ireports to the lib folder of jasper4.- edit classes/jasperreports.properties and add the propertynet.sf.jasperreports.query.executer.factory.xmla-mdx=net.sf.jasperreports.engine.query.JRXmlaQueryExecuterFactory This do the job for me and now i can get reports using xmla connections, but my problem now is that i need to give the username/password to the connection or awt fails in the server without X-window. Using Xvfb dont solve the problem neither start the server with awt in headless mode, becaus with headless mode it fails and if i use xvfb i need to give the user/password in a small windows that no appears in xvfb, xhost + says that the display is up and open, so now my problem is to know the name of the parameters for username and password, the rest of the parameters seems to be well known parameterValues.put("QUERY_LANG", "xmla-mdx"); parameterValues.put("XMLA_DATA_URL", this.xmlaConnection.getURI()); parameterValues.put("XMLA_DATA_CATALOG", this.xmlaConnection.getCatalog()); parameterValues.put("XMLA_DATA_DATASOURCE", this.xmlaConnection.getDataSource()); So if someone knows the name of the xmla parameters to get the username and password directly to the xmla servlet the information would be apreciated.Maybe the solution is edit the JRXmlaQueryExecuterFactory, but i cant find a complete source of the class. As i said before, any help would be apreciated :)Sorry for my poor english :) Link to comment Share on other sites More sharing options...
biaggi Posted July 31, 2008 Author Share Posted July 31, 2008 I'll continue with this post at: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=44048 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now