[Mondrian] CalculatedMember with specific Hierarchy/Parent

[Julian Hyde]

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.

Julian