[Mondrian] CalculatedMember with specific Hierarchy/Parent

Julian Hyde jhyde at pentaho.com
Wed Jun 20 15:00:12 EDT 2012

On Jun 20, 2012, at 1:21 AM, Ati Rosselet wrote:

> Hi,  Does the CalculatedMember work when specifying a specific
> hierarchy + parent?

Yes. See http://jira.pentaho.com/browse/MONDRIAN-960. Fixed and tested.

> I am trying to add a member so that it appears under the "All" member,
> but nothing seems to work.
> Without specifying anything, it appears on the same level as All, but
> I need it to appear as a child of all,
> otherwise I can't visually arrange it in the viewer (jPivot) [members
> on the same level as "All" can't be
> moved to appear between 2 elements under "All"]
>        <CalculatedMember name="Total costs" hierarchy="Account"
> parent="[Account].[All Accounts]">
> 	  <Formula>[Account].[Primary cost] + [Account].[Infrastructure Cost
> Allocation] + [Account].[BU Overhead]</Formula>
> 	  <CalculatedMemberProperty name="FORMAT_STRING" value="#,##0.00"/>
> 	</CalculatedMember>
> Has anyone else run into this problem?  Using Mondrian 3.4.3.  Or
> maybe something needs to be changed in jPivot?

My money would be on JPivot. Calc members come out of APIs differently than regular members. JPivot would have to be changed specifically to ask for them.


More information about the Mondrian mailing list