Hello Javier,<br><br>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).<br>
I use Mondrian/jPivot API rather than the bundle, so this may work for me but not for you.<br><br>Give it a try.<br><br>Regards,<br>Eduardo<br><br>PS: Maybe we should be using the pentaho forums for this kind of questions ?<br>
<br><div class="gmail_quote">On Fri, Apr 17, 2009 at 12:25 PM, Javier Chávez B. <span dir="ltr"><<a href="mailto:jchavezb@gmail.com">jchavezb@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote">On Fri, Apr 17, 2009 at 1:56 AM, Ken Cheng <span dir="ltr"><<a href="mailto:pubdevgroup@gmail.com" target="_blank">pubdevgroup@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Javier,<br>
Seems your schema file is not a well-formated xml file.<br>
change "<Table name="Categories">" to '<Table name="Categories"/>" and have a try<br>
</blockquote><div><br>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??<br>
<br>Best Regard.<br><br>Javier.<br><br><br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Sherman Wood wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div>
<br>
You need to add a Level to the Hierarchy.<br>
<br>
<br>
Sherman<br>
<br>
<br>
*From:* <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] *On Behalf Of *Javier Chávez B.<br>
*Sent:* Thursday, April 16, 2009 8:58 AM<br>
*To:* <a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br>
*Subject:* [Mondrian] Presentation and doubt<br>
<br>
<br>
Hi all.. sorry for my english but i'm learning :0)<br>
<br>
Dear all i need some orientation about a cube that i'm trying to do...<br>
<br>
i've made an MDX with the structure as follow:<br>
<br>
<Schema name="Cubo" ><br>
<Cube name="Cubo" cache="true" enabled="true"><br>
<Table name="Payment_Worker" alias="Fact_Table"><br>
</Table><br>
<Dimension name="Category" foreignKey="Cat_Id" ><br>
<Hierarchy hasAll="true" allMemberName="All Categories" primaryKey="Cat_Id" defaultMember="All Categories"><br>
<Table name="Categories"><br>
</Hierarchy><br>
</Dimension><br>
<Measure name="Payment" column="paw_Totalpay" datatype="Numeric" aggregator="sum" visible="true"><br>
</Measure><br>
</Cube><br>
</Schema><br>
<br>
also i've the next Query :<br>
<br>
select<br>
{[Measures].[Payment]} on columns,<br>
{([Category].[All Categories])} ON rows<br>
from Cubo<br>
<br>
but when try to run this query i get the next error:<br>
<br>
<br>
org.apache.jasper.JasperException: javax.servlet.ServletException:<br>
javax.servlet.jsp.JspException: org.apache.jasper.JasperException:<br>
javax.servlet.ServletException: javax.servlet.jsp.JspException:<br>
com.tonbeller.jpivot.olap.model.OlapException: Mondrian Error:MDX<br>
object '[Category].[All Categories]' not found in cube 'Cubo'<br>
<br>
Somebody can help or orient about what i'm doing wrong... sorry if the question is very basic !!!<br>
<br>
Thanks in advice.<br>
<br>
Javier.<br>
<br>
-- <br>
Cumprimentos<br>
jchavez<br>
linux User #397972 on <a href="http://counter.li.org/" target="_blank">http://counter.li.org/</a><br>
<br></div></div>
Groucho Marx <<a href="http://www.brainyquote.com/quotes/authors/g/groucho_marx.html" target="_blank">http://www.brainyquote.com/quotes/authors/g/groucho_marx.html</a>> - "A child of five would understand this. Send someone to fetch a child of five."<br>
<br>
------------------------------------------------------------------------<div><br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br>
</div></blockquote><div><div></div><div>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Cumprimentos<br>jchavez<br>linux User #397972 on <a href="http://counter.li.org/" target="_blank">http://counter.li.org/</a><br><br><a href="http://www.brainyquote.com/quotes/authors/g/groucho_marx.html" target="_blank">Groucho Marx</a> - "A child of five would understand this. Send someone to fetch a child of five."
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Eduardo Andrade<br><a href="mailto:eduardofandrade@gmail.com">eduardofandrade@gmail.com</a><br>