joeri Posted May 26, 2010 Share Posted May 26, 2010 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.JPGThis 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.OlapModelProxyIs there something wrong with my Mondrian? Something missing?Anyone has an idea?Thanks in advance.Best RegardsJoeriPost Edited by joeri at 05/26/2010 10:00 Link to comment Share on other sites More sharing options...
joeri Posted June 3, 2010 Author Share Posted June 3, 2010 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now