Hello all,
I am new to Mondrian and was trying to create a simple cube whose schema was developed using Mondrian workbench. The MDX query works with the workbench but gives an exception saying "cube not found" when try from the Mondrian web application. The back end database is MySQL. Please find the below schema:
<Schema name="Event" description="Event">
<Cube name="event" caption="Event_Reports" visible="true" description="Event_Reports" cache="true" enabled="true">
<Table name="fact_event">
</Table>
<Dimension type="StandardDimension" visible="true" foreignKey="time_id" highCardinality="false" name="dim_time">
<Hierarchy name="Time" visible="true" hasAll="true" primaryKey="time_id" primaryKeyTable="dim_time">
<Table name="dim_time">
</Table>
<Level name="Year" visible="true" table="dim_time" column="year" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
<Level name="Quarter" visible="true" table="dim_time" column="quarter" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
<Level name="Month" visible="true" table="dim_time" column="year" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="event_id" name="dim_event">
<Hierarchy name="event" visible="true" hasAll="true" primaryKey="event_id" primaryKeyTable="dim_event">
<Table name="dim_event">
</Table>
<Level name="Event" visible="true" table="dim_event" column="event_name" type="String" uniqueMembers="false" levelType="Regular">
</Level>
</Hierarchy>
</Dimension>
<Measure name="mReports" column="_reports" aggregator="count" description="mReports" visible="true">
</Measure>
</Cube>
</Schema>
fact_event, dim_time & dim_event are the sources.
The MDX query being used is :SELECT {[Measures].[mReports]} ON COLUMNS,
{descendants([dim_time].[2017])} ON ROWS
FROM [event]
Find the below error:
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:MDX cube 'event' not found
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:MDX cube 'event' not found
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:556)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:462)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:MDX cube 'event' not found
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:261)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
Any help is appreciated. Also please let me know if there is any tutorial that can help me resolve/understand better.
Thanks in advance,
Praveen Kumar Bandi
Mondrian Error:MDX cube 'event' not fo
