[Mondrian] Formatters and Calculated Members in Virtual Cubes

Alan Jackson AlanJ at symmetrics.net
Wed Mar 19 15:30:29 EDT 2008


Thanks Julian, works a treat
 
Could I suggest that the doc's are updated to reflect this?
 
Thanks
Alan

________________________________

From: Julian Hyde [mailto:jhyde at pentaho.org] 
Sent: 19 March 2008 03:53
To: Alan Jackson
Cc: mondrian at 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 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&aid=1407747&group_i
d=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/20080319/b8f61118/attachment.html 


More information about the Mondrian mailing list