Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: i have a problem to parse my SCHEMA

  1. #1

    Default i have a problem to parse my SCHEMA

    Hi,
    i have a schema that MONDRIAN doesn't want to parse.
    In my ACCESS database i have table names with accents and blanks like 'numéro de l'établissement'. So i am obliged to put it under brackets like this [numéro de l'établissement].
    Is MONDRIAN allowing special characters in the schema.xml like ' à or é .... ???
    Here is my little schema :
    <?xml version="1.0"?>
    <Schema name="BaseDePilotage">
    <!--
    == $Id: //open/mondrian/demo/FoodMart.xml#14 $
    == This software is subject to the terms of the Common Public License
    == Agreement, available at the following URL:
    ==
    http://www.opensource.org/licenses/cpl.html.
    == Copyright (C) 2000-2003 Kana Software, Inc. and others.
    == All Rights Reserved.
    == You must accept the terms of that agreement to use this software.
    ==
    == todo:
    == 1. <CalculatedMember/>
    -->

    <Dimension name="etablissement">
    <Hierarchy hasAll="true" primaryKey="[identifiant de l'établissement]">
    <Table name="ETABLISSEMENT"/>
    <Level name="annee" column="[année d'observation]" uniqueMembers="true"/>
    <Level name="departement" column="[libellé long du département de l'établissement]" uniqueMembers="true"/>
    <Level name="commune" column="[libellé long de la commune de l'établissement]" uniqueMembers="true"/>
    <Level name="numero" column="[numéro de l'établissement]" uniqueMembers="true"/>
    <Property name="nom" column="[dénomination]"/>
    </Level>
    </Hierarchy>
    </Dimension>

    <Cube name="Effectifs">
    <Table name="[SUIVI DES INSCRIPTIONS]"/>
    <DimensionUsage name="etablissement" source="etablissement" foreignKey="[identifiant de l'établissement]"/>
    <Dimension name="annee" foreignKey="[année d'observation]">
    <Hierarchy hasAll="true" allMemberName="All annee" primaryKey="[année d'observation]">
    <Table name="ETABLISSEMENT"/>
    <Level name="annee" uniqueMembers="true" column="[année d'observation]"/>
    </Hierarchy>
    </Dimension>
    <Measure name="nombre d'élèves" column="[nombre d'inscriptions]" aggregator="sum" formatString="Standard"/>
    </Cube>
    </Schema>
    Does somone see some strange things ?
    eric

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: i have a problem to parse my SCHEMA

    I think you're asking a lot of any product to expect names with accents AND quotation marks to work. However, if you insist...
    1. Remove the brackets. Mondrian will add them when it generates the SQL if it deems fit.
    2. Replace the nasty characters with HTML entities such as '&eacute;'.
    3. Turn on tracing. Then you can see what SQL mondrian is generating.

  3. #3

    Default RE: i have a problem to parse my SCHEMA

    ok for 1 and 2 but not for 3.
    I don't know how to enable tracing. I saw it was in MONDRIAN.PROPERTIES but i have no MONDRIAN.PROPERTIES in TOMCAT directories.
    So, what could i do ??
    I m going to search more ....

  4. #4

    Default RE: i have a problem to parse my SCHEMA

    i tried to trace MONDRIAN SQL by adding in the jk2.properties the key mondrian.trace.level with the value 1
    But i have no SQL error when i want to execute my MDX query :
    org.apache.jasper.JasperException: java.lang.RuntimeException: Internal error: Error while executing query [select {[Measures].[nombre d'élèves]} ON columns, Hierarchize(Union({[annee].[All annees]}, [annee].[All annees].Children)) ON rows from [Effectifs] ]
    org.apache.jasper.JasperException: java.lang.RuntimeException: Internal error: Error while executing query [select {[Measures].[nombre d'élèves]} ON columns, Hierarchize(Union({[annee].[All annees]}, [annee].[All annees].Children)) ON rows from [Effectifs] ] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at .....
    .......
    .......
    So i don't understand at this moment.
    I tried to show some parts of my schema but when i drill down i have an error ...
    oups....

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.