[Mondrian] Presentation and doubt

Sherman Wood swood at jaspersoft.com
Thu Apr 16 12:15:46 EDT 2009


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090416/bc09d0e4/attachment.html 


More information about the Mondrian mailing list