[Mondrian] Formatters and Calculated Members in Virtual Cubes

Julian Hyde jhyde at pentaho.org
Tue Mar 18 23:53:23 EDT 2008


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 at symmetrics.net] 
Sent: Tuesday, March 18, 2008 1:28 PM
To: jhyde at 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 at pentaho.org [mailto:mondrian-bounces at 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 at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Alan Jackson
Sent: Monday, March 17, 2008 4:02 PM
To: mondrian at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080318/3fc7df19/attachment.html 


More information about the Mondrian mailing list