[Mondrian] Presentation and doubt

Javier Chávez B. jchavezb at gmail.com
Thu Apr 16 11:58:10 EDT 2009


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/32aa235d/attachment.html 


More information about the Mondrian mailing list