[Mondrian] Presentation and doubt

Eduardo Andrade eduardofandrade at gmail.com
Thu Apr 16 13:35:39 EDT 2009


Hello Javier,
i think you may benefit very much if you're using mondrian DTD + a nice xml
editor (I use Eclipse) to check for syntax errors.

Check if this works :

<!DOCTYPE Schema SYSTEM "mondrian.dtd">
<Schema name="Cubo">
    <Cube name="Cubo" cache="true" enabled="true">
        <Table name="Payment_Worker" alias="Fact_Table" />
        <Dimension name="Category" foreignKey="Cat_Id">
            <Hierarchy hasAll="true" allMemberName="All Categories"
primaryKey="Cat_Id" defaultMember="All Categories">
                <Table name="Categories" />
                <Level name="Cat Type" column="Cat_id" uniqueMembers="true"
/>
            </Hierarchy>
        </Dimension>
        <Measure name="Payment" column="paw_Totalpay" datatype="Numeric"
aggregator="sum" visible="true"></Measure>
    </Cube>
</Schema>

Also, the forums are great to see examples of xml models, as well this
documentation page, which i use often :
http://mondrian.pentaho.org/documentation/xml_schema.php

Cheers,
Eduardo Andrade

On Thu, Apr 16, 2009 at 5:21 PM, Javier Chávez B. <jchavezb at gmail.com>wrote:

>
>
> On Thu, Apr 16, 2009 at 5:15 PM, Sherman Wood <swood at jaspersoft.com>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
>>
>> Something like that ?
>
> <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">
>                 *<Level name="Cat Type" column="Cat_id"
> uniqueMembers="true"/>*
>             </Hierarchy>
>         </Dimension>
>         <Measure name="Payment" column="paw_Totalpay" datatype="Numeric"
> aggregator="sum" visible="true">
>         </Measure>
>     </Cube>
> </Schema>
>
> But still have the same problem ...
>
> Thanks..
> J.
>
>
> --
> 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."
> _______________________________________________
> 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/20090416/6b096a7a/attachment.html 


More information about the Mondrian mailing list