[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes
From: "Julian Hyde" <jhyde () pentaho ! org>
Date: 2008-03-20 17:48:19
Message-ID: 17CE4E24642B4A0DB4E47BB73C4325EE () mackerel
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
done in change 10735; will be in mondrian-3.0.1.
_____
From: Alan Jackson [mailto:AlanJ@symmetrics.net]
Sent: Wednesday, March 19, 2008 12:30 PM
To: jhyde@pentaho.org
Cc: mondrian@pentaho.org
Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes
Thanks Julian, works a treat
Could I suggest that the doc's are updated to reflect this?
Thanks
Alan
_____
From: Julian Hyde [mailto:jhyde@pentaho.org]
Sent: 19 March 2008 03:53
To: Alan Jackson
Cc: mondrian@pentaho.org
Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes
Did you try creating a property called CELL_FORMATTER?
<CalculatedMember dimension="Measures" forumula="..." name="calcmem1" >
<CalculatedMemberProperty name="CELL_FORMATTER"
value="com.acme.MyFormatter" />
</CalculatedMember>
Julian
_____
From: Alan Jackson [mailto:AlanJ@symmetrics.net]
Sent: Tuesday, March 18, 2008 1:28 PM
To: jhyde@pentaho.org; Mondrian developer mailing list
Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes
Thanks Julian
The issue (#1407747) seems to only relate the the case where the calculated
member is in a cube
It doesn't seem to cover the case where the calculated member is in a
VIRTUAL cube.
Our calculated measure only exists in the virtual cube, it does not exist in
the physical cubes.
It looks like these work in subtly different ways.
Is it possible to have this fixed in the Virtual Cube scenario as well?
Our schema looks like:
<VirtualCube name="VirtCube">
<VirtualCubeDimension name="Dim1"/>
...
<VirtualCubeMeasure cubeName="Cube1" name="[Measures].[Measure1] />
...
<CalculatedMember dimension="Measures" forumula="..."
formatter="com.acme.myformatter" name="calcmem1" />
</VirtualCube>
Thanks
Alan
_____
From: mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org] On
Behalf Of Julian Hyde
Sent: 17 March 2008 23:50
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes
I think that was issue 1407747. See
http://sourceforge.net/tracker/index.php?func=detail
<http://sourceforge.net/tracker/index.php?func=detail&aid=1407747&group_id=3
5302&atid=414616> &aid=1407747&group_id=35302&atid=414616.
Julian
_____
From: mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org] On
Behalf Of Alan Jackson
Sent: Monday, March 17, 2008 4:02 PM
To: mondrian@pentaho.org
Subject: [Mondrian] Formatters and Calculated Members in Virtual Cubes
Hi Guys,
Just wondering if anyone can confirm whether this is a bug I'm seeing or
not.
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.
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?
TIA
Alan
[Attachment #5 (text/html)]
<!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&gro \
up_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>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic