[Mondrian] Presentation and doubt

Javier Chávez B. jchavezb at gmail.com
Thu Apr 16 12:21:07 EDT 2009


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."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090416/af688659/attachment.html 


More information about the Mondrian mailing list