[Mondrian] Presentation and doubt

Ken Cheng pubdevgroup at gmail.com
Thu Apr 16 20:56:30 EDT 2009


Hi Javier,
          Seems your schema file is not a well-formated xml file.
change "<Table name="Categories">" to '<Table name="Categories"/>" and 
have a try

Sherman Wood wrote:
>
> You need to add a Level to the Hierarchy.
>
>  
>
> Sherman
>
>  
>
> *From:* mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] *On Behalf Of *Javier Chávez B.
> *Sent:* Thursday, April 16, 2009 8:58 AM
> *To:* mondrian at pentaho.org
> *Subject:* [Mondrian] Presentation and doubt
>
>  
>
> Hi all.. sorry for my english but i'm learning :0)
>
> Dear all i need some orientation about a cube that i'm trying to do...
>
> i've made an MDX with the structure as follow:
>
> <Schema name="Cubo" >
>     <Cube name="Cubo" cache="true" enabled="true">
>         <Table name="Payment_Worker" alias="Fact_Table">
>         </Table>
>         <Dimension name="Category"  foreignKey="Cat_Id" >
>             <Hierarchy hasAll="true" allMemberName="All Categories"  
> primaryKey="Cat_Id" defaultMember="All Categories">
>                 <Table name="Categories">
>             </Hierarchy>
>         </Dimension>
>         <Measure name="Payment" column="paw_Totalpay" 
> datatype="Numeric" aggregator="sum" visible="true">
>         </Measure>
>     </Cube>
> </Schema>
>
> also  i've the next Query :
>
> select
>   {[Measures].[Payment]} on columns,
>   {([Category].[All Categories])} ON rows
> from Cubo
>
> but when try to run this query i get the next 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
>     object '[Category].[All Categories]' not found in cube 'Cubo'
>
> Somebody can help or orient about what i'm doing wrong... sorry if the 
> question is very basic !!!
>
> Thanks in advice.
>
> Javier.
>
> -- 
> Cumprimentos
> jchavez
> linux User #397972 on http://counter.li.org/
>
> Groucho Marx 
> <http://www.brainyquote.com/quotes/authors/g/groucho_marx.html>  - "A 
> child of five would understand this. Send someone to fetch a child of 
> five."
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>   




More information about the Mondrian mailing list