It was a case error on my part, the following worked fine:<br><br> <CalculatedMemberProperty name="DATATYPE" value="Numeric" /><br><br>I can add this detail to the Calculated Member section of the schema documentation if you think it's appropriate.
<br><br><br><div><span class="gmail_quote">On 3/26/07, <b class="gmail_sendername">Matt Campbell</b> <<a href="mailto:mkambol@gmail.com">mkambol@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>I'll have to dig into this, but setting the datatype property of a <CalculatedMember> does not appear to have any effect--member.getPropertyValue() returns null in the block of code you snipped. Setting the datatype attribute of a <Measure> does have an effect, though.
<br><br><br><br><div><div><span class="e" id="q_11190167e476a3cf_1"><span class="gmail_quote">On 3/23/07, <b class="gmail_sendername">Julian Hyde</b> <<a href="mailto:julianhyde@speakeasy.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
julianhyde@speakeasy.net</a>> wrote:</span></span></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><span class="e" id="q_11190167e476a3cf_3">
<div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2">Here's the code, from
RowsetDefinition.java:</font></span></div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2"> //
DATA_TYPE DBType best guess is
string<br> int
dbType =
DBType.WSTR.userOrdinal;<br>
String datatype =
(String)<br>
member.getPropertyValue(Property.DATATYPE.getName());<br>
if (datatype != null)
{<br>
if (datatype.equals("Integer"))
{<br>
dbType =
DBType.I4.userOrdinal;<br>
} else if (datatype.equals("Numeric"))
{<br>
dbType =
DBType.R8.userOrdinal;<br>
} else
{<br>
dbType =
DBType.WSTR.userOrdinal;<br>
}<br>
}<br>
row.set(DataType.name, dbType);<br></font></span></div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2">It suggests that you can override by setting the DATATYPE
property of the calculated member to "Integer" or "Numeric".</font></span></div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#000080" face="Verdana" size="2">Julian</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Matt
Campbell<br><b>Sent:</b> Friday, March 23, 2007 11:56 AM<br><b>To:</b>
<a href="mailto:mondrian@pentaho.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mondrian@pentaho.org</a><br><b>Subject:</b> [Mondrian] Datatype in
MDSCHEMA_MEASURES<br></font><br></div><div><span>
<div></div><br>Calculated members appear to always have a datatype of WSTR
(130) specified in the XMLA response. This looks like a bug.
Anyone have additional
information?<br><br><row><br>
<CATALOG_NAME>FoodMart</CATALOG_NAME>
<br>
<CUBE_NAME>Sales</CUBE_NAME><br>
<MEASURE_NAME>Profit
Growth</MEASURE_NAME><br>
<MEASURE_UNIQUE_NAME>[Measures].[Profit
Growth]</MEASURE_UNIQUE_NAME><br>
<MEASURE_CAPTION>Gewinn-Wachstum</MEASURE_CAPTION>
<br>
<MEASURE_AGGREGATOR>127</MEASURE_AGGREGATOR><br>
<span style="font-weight: bold;"><DATA_TYPE>130</DATA_TYPE></span><br>
<MEASURE_IS_VISIBLE>true</MEASURE_IS_VISIBLE>
<br> <DESCRIPTION>Sales Cube -
Profit Growth
Member</DESCRIPTION><br></row><br></span></div></blockquote></div></span></div>
<br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><br></blockquote></div><br>
</blockquote></div><br>