[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