<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18000" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=593054817-20032008><FONT face=Verdana
color=#000080 size=2>done in change 10735; will be in
mondrian-3.0.1.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Alan Jackson
[mailto:AlanJ@symmetrics.net] <BR><B>Sent:</B> Wednesday, March 19, 2008 12:30
PM<BR><B>To:</B> jhyde@pentaho.org<BR><B>Cc:</B>
mondrian@pentaho.org<BR><B>Subject:</B> RE: [Mondrian] Formatters and
Calculated Members in Virtual Cubes<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=578112719-19032008>Thanks Julian, works a treat</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=578112719-19032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=578112719-19032008>Could I suggest that the doc's are updated to reflect
this?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=578112719-19032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=578112719-19032008>Thanks</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=578112719-19032008>Alan</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Julian Hyde [mailto:jhyde@pentaho.org]
<BR><B>Sent:</B> 19 March 2008 03:53<BR><B>To:</B> Alan Jackson<BR><B>Cc:</B>
mondrian@pentaho.org<BR><B>Subject:</B> RE: [Mondrian] Formatters and
Calculated Members in Virtual Cubes<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=612594403-19032008><FONT face=Verdana
color=#000080 size=2>Did you try creating a property called
CELL_FORMATTER?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=612594403-19032008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=612594403-19032008><FONT face=Verdana
color=#000080 size=2> <SPAN class=687072120-18032008><FONT face=Arial
color=#0000ff> <CalculatedMember dimension="Measures" forumula="..."
name="calcmem1" ></FONT></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=612594403-19032008><FONT face=Arial
color=#0000ff size=2><SPAN class=687072120-18032008><SPAN
class=687072120-18032008> <CalculatedMemberProperty
name="CELL_FORMATTER" value="com.acme.MyFormatter"
/></SPAN></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=612594403-19032008><FONT face=Arial
color=#0000ff size=2><SPAN class=687072120-18032008>
</CalculatedMember></SPAN></FONT></SPAN></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT><FONT face=Verdana
color=#000080 size=2></FONT><FONT face=Verdana color=#000080
size=2></FONT><BR><SPAN class=612594403-19032008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Alan Jackson
[mailto:AlanJ@symmetrics.net] <BR><B>Sent:</B> Tuesday, March 18, 2008 1:28
PM<BR><B>To:</B> jhyde@pentaho.org; Mondrian developer mailing
list<BR><B>Subject:</B> RE: [Mondrian] Formatters and Calculated Members in
Virtual Cubes<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>Thanks Julian</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>The issue (#1407747) seems to only relate the the
case where the calculated member is in a cube</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>It doesn't seem to cover the case where the
calculated member is in a VIRTUAL cube.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>Our calculated measure only exists in the virtual
cube, it does not exist in the physical cubes.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>It looks like these work in subtly different
ways.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>Is it possible to have this fixed in the Virtual
Cube scenario as well?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>Our schema looks like:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008><VirtualCube
name="VirtCube"></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008> <VirtualCubeDimension
name="Dim1"/></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008> ...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008> <VirtualCubeMeasure cubeName="Cube1"
name="[Measures].[Measure1] /></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008> ...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008> <CalculatedMember dimension="Measures"
forumula="..." formatter="com.acme.myformatter" name="calcmem1"
/></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></VirtualCube></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>Thanks</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=687072120-18032008>Alan</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Julian
Hyde<BR><B>Sent:</B> 17 March 2008 23:50<BR><B>To:</B> 'Mondrian developer
mailing list'<BR><B>Subject:</B> RE: [Mondrian] Formatters and Calculated
Members in Virtual Cubes<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=187574923-17032008><FONT face=Verdana
color=#000080 size=2>I think that was issue 1407747. See <A
href="http://sourceforge.net/tracker/index.php?func=detail&aid=1407747&group_id=35302&atid=414616">http://sourceforge.net/tracker/index.php?func=detail&aid=1407747&group_id=35302&atid=414616</A>.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187574923-17032008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=187574923-17032008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Alan
Jackson<BR><B>Sent:</B> Monday, March 17, 2008 4:02 PM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Formatters and
Calculated Members in Virtual Cubes<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial size=2>Hi
Guys,</FONT></SPAN></DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial size=2>Just wondering
if anyone can confirm whether this is a bug I'm seeing or
not.</FONT></SPAN></DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial size=2>If you take a
Virtual Cube and add a calculated measure to it, applying a formatter to
it (FORMATTER="com.acme.myformatter") it doesn't get applied. Applying the
same formatter to a cube calculated member works fine.</FONT></SPAN></DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial
size=2>RolapVirtualCubeMeasure.java has a getFormatter method that returns
the formatter for the cube measure - should there be a check in here for
the case where the virtual cube measure doesn't have a cube measure behind
it?</FONT></SPAN></DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial
size=2>TIA</FONT></SPAN></DIV>
<DIV><SPAN class=718395822-17032008><FONT face=Arial
size=2>Alan</FONT></SPAN></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>