[Mondrian] Presentation and doubt

Eduardo Andrade eduardofandrade at gmail.com
Fri Apr 17 07:35:35 EDT 2009


Hello Javier,

I believe Mondrian doesn't refresh the model (internally) even if you change
the xml, unless you change the name attribute of the Schema (i.e. if you put
a different string as <Schema name="1223890486000"> everytime you save it,
it will load it again).
I use Mondrian/jPivot API rather than the bundle, so this may work for me
but not for you.

Give it a try.

Regards,
Eduardo

PS: Maybe we should be using the pentaho forums for this kind of questions ?

On Fri, Apr 17, 2009 at 12:25 PM, Javier Chávez B. <jchavezb at gmail.com>wrote:

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


-- 
Eduardo Andrade
eduardofandrade at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090417/baa3c8a2/attachment.html 


More information about the Mondrian mailing list