Mehdi,<br><br>Can you copy paste your complete Level element configuration? Using a MemberFormatter is the way to go. Was there any exception message thrown by Mondrian telling you it failed to instantiate the MemberFormatter?<br>
<br><br><br><div class="gmail_quote">On Wed, May 11, 2011 at 6:35 AM, mehdi b <span dir="ltr"><<a href="mailto:mehdi_xinu@yahoo.com">mehdi_xinu@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top">Hi,<br><br>I'm using mondrian 3.2.1. I have a Level which is integer and it has 8 digits length, its definition is as follows:<br>
<Dimention name="TrxDate"><br><Hierarchy hasAll="true" allMemberName="All"><br><Level name="TrxDate" column="..." uniqueMembers="true"/><br></Hierarchy><br>
</Dimention><br><br>when I want to use this dimension in query like<br>SELECT {[Measures].{Trx]} on COLUMNS, {[TrxDate].[20110403]} on ROWS from [Types]<br><br>I encounter the error that [TrxDate].[20110403] not found, but when I run the query as<br>
SELECT {[Measures].{Trx]} on COLUMNS, {[TrxDate].[2.0110403E7]} on ROWS from [Types]<br><br>the query executed successfully. I don't know how Mondrian formatted the members?<br>I also tried various types on the Level definition in schema like type="String" or type="Numeric" but the result is as the same. I
also created a "MemberFormatter" and assigned it to the Level definition in schema, but it is not called.<br><br>I also tried the query<br>SELECT {[Measures].{Trx]} on COLUMNS, {[TrxDate]} on ROWS from [Types]<br>
<br>and then print the result through result.print() method and it seems that Mondrian load the members as scientific format.<br><br>I would appreciate any help!<br><br></td></tr></tbody></table><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>