[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