[Mondrian] Presentation and doubt

[Javier Chávez B.]

On Fri, Apr 17, 2009 at 1:47 PM, Diego Dimunzio <ddimunzio at gmail.com> wrote:

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

Thanks a lot Diego ...

Best Regard.

Javier.


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


-- 
Cumprimentos
jchavez
linux User #397972 on http://counter.li.org/

Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>
- "A wide screen just makes a bad film twice as bad."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090417/733c74d8/attachment.html