<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I'm trying to get CaptionExpression to work in 3.1.5. I found a bug
report with patch (<a href="http://jira.pentaho.com/browse/MONDRIAN-683" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-683</a>) but
even after applying the patch I have no luck. I suspect it's because my
level is hierarchical. Also, my CaptionExpression relies on a join. I see no evidence of the join or the CaptionExpression in the generated SQL to build this dimension. Is it something wrong in my schema? Or do Joins and CaptionExpression not work for hierarchical dimensions?<div><br></div><div><br><div><div> <Dimension name="Item" foreignKey="ID"></div><div> <Hierarchy hasAll="true" primaryKeyTable="ARTIFACT" primaryKey="ID"></div><div> <Join leftKey="F_ID_ID" rightAlias="F_ID" rightKey="ID"></div><div> <Table name="ARTIFACT"></div><div> <SQL></div><div> type in ('A')</div><div> </SQL></div><div> </Table></div><div> <Join leftKey="ID_F_OID" rightKey="ID"></div><div> <Table name="F_ID"/></div><div> <Table name="ID_F"/></div><div> </Join></div><div> </Join></div><div> <Level name="Item" column="ID" nullParentValue="null" nameColumn="NAME" parentColumn="PARENT_ID" uniqueMembers="true" ></div><div> <CaptionExpression></div><div> <SQL></div><div> concat("ID_F"."PREFIX",concat("F_ID"."ID","ID_F"."SUFFIX"))</div><div> </SQL></div><div> </CaptionExpression></div><div> </Level></div><div> </Hierarchy></div><div> </Dimension></div><div><br></div><div><br></div></div><div>
Thanks. <br>
<br>
Joel </div></div></body></html>