[Mondrian] Mondrian Error:Syntax error , token 'EOF'

Ednardo Ferreira ednardof at yahoo.com
Mon May 12 15:39:22 EDT 2008


Hi!

I use Mondrian since last year for tests.I use Access and change samples, and that's all right since now.

I'm having this problem:


"JPivot had an error ...
org.apache.jasper.JasperException: javax.servlet.ServletException: 
javax.servlet.jsp.JspException: javax.servlet.ServletException: 
javax.servlet.jsp.JspException: Mondrian Error:Syntax error at line 6, column 2, 
token 'EOF'"
What is it?

Follow...:

1) My cube and dimensions

<!-- DIMENSOES DO CUBO TCC -->

  <Dimension name="periodo">
    <Hierarchy hasAll="true" allMemberName="All periodo" primaryKey="id" defaultMember="All periodo">
      <Table name="periodo"/>
      <Level name="ano" column="ano" type="Numeric" uniqueMembers="true" />
      <Level name="semestre" column="semestre" type="Numeric" uniqueMembers="false" />
    </Hierarchy>
  </Dimension>
  
  <Dimension name="tipo de beneficio">
    <Hierarchy hasAll="true" allMemberName="All beneficio" primaryKey="id" defaultMember="All beneficio">
      <Table name="tipo de beneficio"/>
      <Level name="tpbeneficio" column="tpbeneficio" type="String" uniqueMembers="true" />
    </Hierarchy>
  </Dimension>
  
  
  <Dimension name="area de ensino" >
    <Hierarchy hasAll="true" allMemberName="All area" primaryKey="id" defaultMember="All area">
      <Table name="area de ensino"/>
      <Level name="area" column="area" type="String" uniqueMembers="true" />
      <Level name="curso" column="curso" type="String" uniqueMembers="true" />
      <Level name="turma" column="turma" type="String" uniqueMembers="true" />
    </Hierarchy>
  </Dimension>

<!-- Montando o Cubo-->  

  <Cube name="media">
  <Table name="media"/>

  <DimensionUsage name="periodo" source="periodo" foreignKey="idperiodo"/>
  <DimensionUsage name="tipo de beneficio" source="tipo de beneficio" foreignKey="idbeneficio"/>
  <DimensionUsage name="area de ensino" source="area de ensino" foreignKey="idareadeensino"/>
  
  <Measure name="media" column="media" aggregator="avg"/>
  
</Cube>

2) My conn

<%@ page session="true" contentType="text/html; charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:MondrianFoodMart" catalogUri="/WEB-INF/queries/FoodMart.xml">
select
  {[Measures].[media]} on columns,
  {([periodo].[All periodo], [tipo de beneficio].[All beneficio],[area de ensino].[All area)} ON rows
from [media]
</jp:mondrianQuery>

<c:set var="title01" scope="session">Notas por turma, periodo e curso</c:set>




 Até mais!
Jesus te ama e Ele vai voltar! 


Ednardo de Oliveira Ferreira
Analista de Sistemas e Mestre em Transportes
+55(61)8128-7950 
Blog: http://vilaperi.blogspot.com/


Desmascarando o panfleto Veja: http://luis.nassif.googlepages.com/home


"É preciso viver, não apenas existir." (Plutarco)


"O encontro de duas personalidades é como o contato de duas substâncias químicas. Se há alguma reação, ambos são transformados" (Carl Jung)


"Para o triunfo do mal só é preciso que os bons homens não façam nada." (Edmund Burke)


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080512/cead2162/attachment.html 


More information about the Mondrian mailing list