[Mondrian] Presentation and doubt
Diego Dimunzio
ddimunzio at gmail.com
Fri Apr 17 08:47:03 EDT 2009
Hello Javier,
I far I know it's normal even when you flush the mondrian cache by hand,
there is no wait to clear the dimension cache.
Here is a good post about it.
http://forums.pentaho.org/archive/index.php/t-51518.html
Regards
Diego
On Fri, Apr 17, 2009 at 8:25 AM, 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
>
>
--
Diego Andres Dimunzio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090417/c98d84d1/attachment.html
More information about the Mondrian
mailing list