Hi, I'm trying to create a hierarchy with three levels and a double join. I get it working with to levels and a simple join (feature-set -> campaign), but when I add the third level (feature-set -> campaign -> partner) I get this error: javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyThe MDX query is: SELECT {([Type].[All Types],[Measures].[Count])} ON COLUMNS, {([state].[All States],[Country].[All Countrys] )} ON ROWS FROM [users] The query works in the workbench, I get the error when I try to expand a hierarchy in the Analysis View provided by JasperServer. I can expand "All types" to see all partners, but when I try to expand a partner I get the error. My dimension is defined as below. What am I doing wrong? Code:<Dimension type="StandardDimension" foreignKey="feature_set_id" name="Type"> <Hierarchy hasAll="true" primaryKey="id" primaryKeyTable="feature_sets"> <Join leftAlias="" leftKey="campaign_id" rightAlias="campaigns_alias" rightKey="id"> <Table name="feature_sets"> </Table> <Join leftKey="partner_id" rightKey="id"> <Table name="campaigns" schema="" alias="campaigns_alias"> </Table> <Table name="partners"> </Table> </Join> </Join> <Level name="Partner" table="partners" column="id" nameColumn="name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="Campaign" table="campaigns" column="id" nameColumn="name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="Account" table="feature_sets" column="id" nameColumn="name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy></Dimension>
