Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Mondrian Error:MDX cube 'event' not fo

  1. #1

    Default Mondrian Error:MDX cube 'event' not fo

    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

  2. #2
    Join Date
    Jun 2012
    Posts
    11

    Default

    Hi Praveen

    I don't know if you have solved your problem.

    I just saw that your "Time" dimension is configured as a "StandardDimension" instead of a TimeDimension.

    You cube is named "event" and your hierarchy is also called "event". It might just be that the mondrian engine gets confused between the cube and the dimension. Consider renaming one of them.

    Hope this helps.
    Louis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.