Drill down levels and Mondrian Schema

[joeri]

Hi,

I am creating a report that displays the number of unique users that placed an order per year.

This is what my result looks like:

/uploads/projects/jasperserver/image/report1.JPG

This is how my dimension is defined in Mondrian.

     <Dimension type="StandardDimension" foreignKey="DATEID" name="date">        <Hierarchy hasAll="true" allMemberName="All Dates" primaryKey="DATEID">            <Table name="DIMDATE"/>            <Level name="Year" column="CALENDARYEAR" uniqueMembers="true" />            <Level name="Quarter" column="CALENDARYEARQTR" uniqueMembers="true" />            <Level name="Date" column="FULLDATE" uniqueMembers="true"/>        </Hierarchy>    </Dimension>

When I click on the + button for a particular Quarter, the drill down fails with error: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy

Is there something wrong with my Mondrian? Something missing?

Anyone has an idea?

Thanks in advance.

Best Regards
Joeri

Post Edited by joeri at 05/26/2010 10:00

[joeri]

This has been solved.

You receive this error when:

- Dimension table name is invalid

- parentColumn, nameColumn, Column of a Level in your dimension hierarchy is invalid