Error creating Modrian Connection

[chrisodom]

I am new to this product and I am trying to get a simple example up and running. I have made a simple schema:

 

Code:

<?xml version="1.0" encoding="UTF-8"?>
<Schema name="Reporting metrics LibreDigital">
	
	<Dimension name="Books">
		<Hierarchy hasAll="true" primaryKey="BOEMAS_BOOK_EDITION_ID">
			<Table name="NS_RPT_DM.BOOK_EDITION_MASTER_MV"/>
			<Level name="Book" column="BOEMAS_BOOK_EDITION_ID" uniqueMembers="true">
				<Property name="Title" column="BOEMAS_ENGLISH_PROPER_TITLE"/>
				<Property name="ISBN" column="BOEMAS_ISBN_13"/>
			</Level>  
		</Hierarchy>
	</Dimension>

	<Dimension name="Requests">
		<Hierarchy hasAll="true" primaryKey="BRRDET_REQUEST_RECORD_ID" >
			<Table name="NS_RPT_DM.BOOK_REQUEST_RECORD_DETAIL_MV"/>
			<Level name="Request" column="BRRDET_REQUEST_RECORD_ID" uniqueMembers="true">
				<Property name="File Id" column="COFDET_CONTENT_FILE_ID"/>
				<Property name="UserName" column="BRRDET_USER"/>
			</Level>
		</Hierarchy>
	</Dimension>
	
	<Dimension name="BusinessUnits">
		<Hierarchy hasAll="true" primaryKey="BUMAS_BUSINESS_UNIT_ID">
			<Table name="NS_RPT_DM.BUSINESS_UNIT_MASTER_MV"/>
			<Level name="Business Unit" column="BUMAS_BUSINESS_UNIT_ID" uniqueMembers="true">
				<Property name="Busiess Unit Name" column="BUMAS_ENGLISH_NAME"/>
				<Property name="Status" column="BUMAS_STATUS"/>
			</Level>
		</Hierarchy>		
	</Dimension>
	
	<Dimension name="Publishers">
		<Hierarchy hasAll="true" primaryKey="CONTACT_ID">
			<Table name="NS_RPT_DM.CONTACT_XREF_MV"/>
			<Level name="Publisher Id" column="CONTACT_ID" uniqueMembers="true"/>
		</Hierarchy>
	</Dimension>

	<Dimension name="Vendors">
		<Hierarchy hasAll="true" allMemberName="All Vendors" primaryKey="BOVMAS_VENDOR_ID">
			<Table name="NS_RPT_DM.BOOK_VENDOR_MASTER_MV"/>
			<Level name="Vendor" column="BOVMAS_VENDOR_ID" uniqueMembers="true">
				<Property name="Vendor Name" column="BOVMAS_NAME"/>
			</Level>
		</Hierarchy>
	</Dimension>

	<Cube name="Request_Fact">
		<Table name="NS_RPT_DM.BOOK_REQUEST_RECORD_DETAIL_MV">
			<DimensionUsage name="Books" source="Books" foreignKey="BOEMAS_BOOK_EDITION_ID" />
			<DimensionUsage name="Vendors" source="Vendors" foreignKey="BOVMAS_VENDOR_ID" />
			<DimensionUsage name="Requests" source="Requests" foreignKey="BRRDET_REQUEST_RECORD_ID" />
			<CalculatedMember name="Vends" dimension="Measures">
				<Formula>[Requests].[Request].[File Id] = -1</Formula>
				<CalculatedMemberProperty name="FORMAT_STRING" value="#,###"/>
			</CalculatedMember>
		</Table>	
	</Cube>
</Schema>

 

Using the Administration section of the JasperIntelligence server I was trying to upload and test a quick example using this MDX:

 

 

Code:

[code] select [Measures].[Vends] ON COLUMNS, [Requests].[Request].[user Name] ON ROWS from [Request_Fact]

 

I am getting a "null" value response from the application:

 

That is not a valid MDX Query: null

 

and I see this stack trace in my IDE:

 

Code:

[code] 10:31:36,841 WARN [OlapConnectionServiceImpl] Validation Failed for Olap Unit: null [Ljava.lang.StackTraceElement;@119267b 10:31:36,841 ERROR [OlapConnectionServiceImpl] java.lang.NullPointerException 10:31:36,841 ERROR [sTDERR] java.lang.NullPointerException 10:31:36,841 ERROR [sTDERR] at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.dereference(OlapConnectionServiceImpl.java:325) 10:31:36,841 ERROR [sTDERR] at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.getMondrianConnectProperties(OlapConnectionServiceImpl.java:237) 10:31:36,841 ERROR [sTDERR] at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.getMondrianConnection(OlapConnectionServiceImpl.java:227) 10:31:36,841 ERROR [sTDERR] at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.validateMDX(OlapConnectionServiceImpl.java:176) 10:31:36,841 ERROR [sTDERR] at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.validate(OlapConnectionServiceImpl.java:165) 10:31:36,841 ERROR [sTDERR] at com.jaspersoft.jasperserver.war.validation.OlapUnitValidator.validateMdxQuery(OlapUnitValidator.java:129) 10:31:36,841 ERROR [sTDERR] at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source) 10:31:36,841 ERROR [sTDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 10:31:36,841 ERROR [sTDERR] at java.lang.reflect.Method.invoke(Method.java:585) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.action.FormAction.invokeValidatorMethod(FormAction.java:682) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.action.FormAction.doValidate(FormAction.java:656) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.action.FormAction.bindAndValidate(FormAction.java:530) 10:31:36,841 ERROR [sTDERR] at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) 10:31:36,841 ERROR [sTDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 10:31:36,841 ERROR [sTDERR] at java.lang.reflect.Method.invoke(Method.java:585) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:141) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:67) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.AnnotatedAction.execute(AnnotatedAction.java:208) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.ActionExecutor.execute(ActionExecutor.java:54) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.support.ActionTransitionCriteria.test(ActionTransitionCriteria.java:87) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.support.TransitionCriteriaChain.test(TransitionCriteriaChain.java:70) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.Transition.canExecute(Transition.java:187) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.Transition.execute(Transition.java:210) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.TransitionableState.onEvent(TransitionableState.java:105) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.Flow.onEvent(Flow.java:545) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.signalEvent(FlowExecutionControlContextImpl.java:199) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.execution.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:239) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.executor.FlowExecutorImpl.signalEvent(FlowExecutorImpl.java:177) 10:31:36,841 ERROR [sTDERR] at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:100) 10:31:36,856 ERROR [sTDERR] at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:198) 10:31:36,856 ERROR [sTDERR] at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) 10:31:36,856 ERROR [sTDERR] at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) 10:31:36,856 ERROR [sTDERR] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792) 10:31:36,856 ERROR [sTDERR] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726) 10:31:36,856 ERROR [sTDERR] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) 10:31:36,856 ERROR [sTDERR] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) 10:31:36,856 ERROR [sTDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 10:31:36,856 ERROR [sTDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 10:31:36,856 ERROR [sTDERR] at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:134) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) 10:31:36,856 ERROR [sTDERR] at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 10:31:36,856 ERROR [sTDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) 10:31:36,856 ERROR [sTDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) 10:31:36,903 ERROR [sTDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) 10:31:36,903 ERROR [sTDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) 10:31:36,903 ERROR [sTDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) 10:31:36,903 ERROR [sTDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) 10:31:36,903 ERROR [sTDERR] at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) 10:31:36,903 ERROR [sTDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) 10:31:36,903 ERROR [sTDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) 10:31:36,903 ERROR [sTDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) 10:31:36,903 ERROR [sTDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) 10:31:36,903 ERROR [sTDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) 10:31:36,903 ERROR [sTDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) 10:31:36,903 ERROR [sTDERR] at java.lang.Thread.run(Thread.java:595)

 

any help would be deeply appreciated!

[rhancke]

Hi chrisodom,

 

Try to test this mdx query:

 

SELECT {[Measures].[Vends]} ON COLUMNS, {([Requests].[Request].[userName])} ON ROWS FROM Request_Fact

[chrisodom]

I updated MDX query to only get back this message:

 

That is not a valid MDX Query: Mondrian Error:MDX object '[Measures].[Vends]' not found in cube 'Request_Fact'

 

I am not sure why this is not found?

[swood]

That is a wierd cube - no actual members at all?

 

Try having at least one actual measure on the fact table.

 

 

 

Sherman

JasperSoft