[Mondrian] Presentation and doubt

Javier Chávez B. jchavezb at gmail.com
Fri Apr 17 07:25:11 EDT 2009


On Fri, Apr 17, 2009 at 1:56 AM, Ken Cheng <pubdevgroup at gmail.com> wrote:

> 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
>

Thanks to all for your councils ... already have my little  cube running :0)
.. the principal problem was the cache refresh .. so any time that change my
XML i've to restart my Tomcat ... is this normal??

Best Regard.

Javier.




> 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
>>
>>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>



-- 
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."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090417/3f9dc68f/attachment.html 


More information about the Mondrian mailing list