[Mondrian] hierarchical dimensions with joins

Joel Sherriff jsherriff at rallydev.com
Mon Mar 8 16:58:27 EST 2010


I'm trying to get CaptionExpression to work in 3.1.5. I found a bug report with patch (http://jira.pentaho.com/browse/MONDRIAN-683) 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?


        <Dimension name="Item" foreignKey="ID">
                <Hierarchy hasAll="true" primaryKeyTable="ARTIFACT" primaryKey="ID">
                        <Join leftKey="F_ID_ID" rightAlias="F_ID" rightKey="ID">
                                <Table name="ARTIFACT">
                                <SQL>
                                        type in ('A')
                                </SQL>
                                </Table>
                                <Join leftKey="ID_F_OID" rightKey="ID">
                                        <Table name="F_ID"/>
                                        <Table name="ID_F"/>
                                </Join>
                        </Join>
                        <Level name="Item" column="ID" nullParentValue="null" nameColumn="NAME" parentColumn="PARENT_ID" uniqueMembers="true" >
                                <CaptionExpression>
                                        <SQL>
                                                concat("ID_F"."PREFIX",concat("F_ID"."ID","ID_F"."SUFFIX"))
                                        </SQL>
                                </CaptionExpression>
                        </Level>
                </Hierarchy>
        </Dimension>


Thanks. 

Joel   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100308/42ce6241/attachment.html 


More information about the Mondrian mailing list