How to use CELL PROPERTY FORMATTED_VALUE?

[biaggi]

Hi all, I have some cubes with Measures with a formatString like this:

 

                <Measure name="MeasureName" column="dbColumn" datatype="String" aggregator="sum" caption="MeasureCaption" visible="true" formatString="#,##0.00 €">
 

 

This works perfectly on Analisys views, and the FmtValue Property is correctly returned in XML/A

 

        <Cell CellOrdinal="0">
          <Value xsi:type="xsd:string">37460.44793599999996518</Value>
          <FmtValue>37,460.45 €</FmtValue>
          <FormatString>#,##0.00 €</FormatString>
        </Cell>
 

But I can't use the formatted value in the reports, i've tried with this field descriptions

        <field name="MeasureName" class="java.lang.String">
                <fieldDescription><![CDATA[FormattedData([Measures].[MeasureName])]]></fieldDescription>
        </field>
        <field name="MeasureName" class="java.lang.String">
                <fieldDescription><![CDATA[[Measures][MeasureName](FORMATTED_DATA)]]></fieldDescription>
        </field>
        <field name="MeasureName" class="java.lang.String">
                <fieldDescription><![CDATA[[Measures][MeasureName](FmtValue)]]></fieldDescription>
        </field>

And no one works, the output is allways the unformatted value.

I've been searching for forums and internet, but i cant find any formatted field example, can someone provide an example?