Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hi

  1. #1
    Join Date
    Nov 2007

    Question Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hi

    Hi All,

    I am trying to run the Mondrian demo with mysql.
    I followed the installation instruction for non-embedded database to load the foodmart database and deploy the web application.

    However, instead of getting query results , I got the following error message when trying the simple MDX queries from the link 'Basic interface for ad hoc queries':

    mondrian.olap.MondrianException: Mondrian Error:Internal error: Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hierarchy "Time.Weekly"
    at mondrian.resource.MondrianResource$_Def0.ex(
    at mondrian.olap.Util.newInternal(
    at mondrian.rolap.RolapHierarchy.init(
    at mondrian.rolap.RolapDimension.init(
    at mondrian.rolap.RolapCube.init(
    at mondrian.rolap.RolapCube.<init>(
    at mondrian.rolap.RolapSchema.load(
    at mondrian.rolap.RolapSchema.load(
    at mondrian.rolap.RolapSchema.<init>(
    at mondrian.rolap.RolapSchema.<init>(
    at mondrian.rolap.RolapSchema$Pool.get(
    at mondrian.rolap.RolapSchema$Pool.get(
    at mondrian.rolap.RolapConnection.<init>(
    at mondrian.rolap.RolapConnection.<init>(
    at mondrian.olap.DriverManager.getConnection(
    at mondrian.olap.DriverManager.getConnection(
    at mondrian.olap.DriverManager.getConnection(
    at mondrian.web.servlet.MDXQueryServlet.processRequest(
    at mondrian.web.servlet.MDXQueryServlet.doGet(
    at javax.servlet.http.HttpServlet.service(
    at javax.servlet.http.HttpServlet.service(
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(
    at org.apache.catalina.core.StandardWrapperValve.invoke(
    at org.apache.catalina.core.StandardContextValve.invoke(
    at org.apache.catalina.core.StandardHostValve.invoke(
    at org.apache.catalina.valves.ErrorReportValve.invoke(
    at org.apache.catalina.core.StandardEngineValve.invoke(
    at org.apache.catalina.connector.CoyoteAdapter.service(
    at org.apache.coyote.http11.Http11Processor.process(
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(
    at org.apache.tomcat.util.threads.ThreadPool$
    Any help is highly appreciated!

    Thank you for your time!



  2. #2
    Join Date
    Apr 2008

    Default "[Time.Weekly].[All Time.Weeklys].[1997]" in Hierarchy "Time.Weekly"

    I have the same problem. None of the example queries work.
    Apache Tomcat/5.0.28
    jvm 1.6.0_05-b13
    mysql 5.0.16

    Has somebody get the demo work with a mysql?
    All hints and tips are welcome.

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.