[Mondrian] <NameExpression> issue........

Nitesh Kumar niteshkumaar at gmail.com
Fri Oct 1 10:11:01 EDT 2010


Hi All,
I've used a degenerated dimension . (a dimension which hierarchy doesn't
have table. using directly fact table) . and fact table has id but doesn't
have name corresponding to the id. so I want to display the name instead of
id , so I wanted to use <NameExpression> attribute of <Level> but problem is
that fact table doesn't has name column can I use fetch from some other
table in <NameExpression> ?
Any suggestion/input would be highly appreciated.


<Dimension type="StandardDimension" name="usage_range_d" caption="All
Ranges">
        <Hierarchy name="range_usage_h" hasAll="true"
allMemberName="all_ranges" allMemberCaption="All Ranges" primaryKey="IP">

            <Level name="Year" table="" column="year" nameColumn=""
ordinalColumn="year" type="String" uniqueMembers="false" levelType="Regular"
hideMemberIf="Never">
            </Level>
            <Level name="Month" table="" column="month"
nameColumn="month_year" ordinalColumn="month_year" parentColumn=""
nullParentValue="" type="String" uniqueMembers="false" levelType="Regular"
hideMemberIf="Never">
            </Level>
            <Level  name="Range" table="" column="usage_range"
ordinalColumn="usage_range" nullParentValue="" type="String"
uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
            </Level>
            <Level name="IP List" table="" column="data_value" nameColumn=""
ordinalColumn="data_value" type="String" uniqueMembers="false"
levelType="Regular" hideMemberIf="Never" captionColumn="">
            </Level>
            <Level name="Account" table="" column="account_id"
nameColumn="account_id" ordinalColumn="account_id" type="String"
uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
            *<NameExpression>
                    <SQL dialect="mysql">
                        concat(account_id,&#39; - &#39;,
simages_account_view.name)                    </SQL>
                </NameExpression>*
            </Level>
        </Hierarchy>
    </Dimension>

-- 
Thanks & Regards,
Nitesh Kumar
09811-235-725
011-2598-4625
09654291004
09350-739733
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20101001/95779ddf/attachment.html 


More information about the Mondrian mailing list