Thank you.. yes there was a change. It turns out that my fix for jpivot to show the calculated members in place in the hirearchy was only using the old query.getFormulas, as opposed to checking with getCalculatedMembers(Hierarchy) from the schema. Seems to work now, but I still can't get them to be under the "all" member. Any other works fine at the moment.. I'll have to redebug... (is that a word?).<br>
<br>Cheers.<br>Ati<br><br><div class="gmail_quote">On Wed, Jun 20, 2012 at 9:00 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Jun 20, 2012, at 1:21 AM, Ati Rosselet wrote:<br>
<br>
> Hi, Does the CalculatedMember work when specifying a specific<br>
> hierarchy + parent?<br>
<br>
Yes. See <a href="http://jira.pentaho.com/browse/MONDRIAN-960" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-960</a>. Fixed and tested.<br>
<br>
<br>
> I am trying to add a member so that it appears under the "All" member,<br>
> but nothing seems to work.<br>
> Without specifying anything, it appears on the same level as All, but<br>
> I need it to appear as a child of all,<br>
> otherwise I can't visually arrange it in the viewer (jPivot) [members<br>
> on the same level as "All" can't be<br>
> moved to appear between 2 elements under "All"]<br>
><br>
> <CalculatedMember name="Total costs" hierarchy="Account"<br>
> parent="[Account].[All Accounts]"><br>
> <Formula>[Account].[Primary cost] + [Account].[Infrastructure Cost<br>
> Allocation] + [Account].[BU Overhead]</Formula><br>
> <CalculatedMemberProperty name="FORMAT_STRING" value="#,##0.00"/><br>
> </CalculatedMember><br>
><br>
><br>
> Has anyone else run into this problem? Using Mondrian 3.4.3. Or<br>
> maybe something needs to be changed in jPivot?<br>
<br>
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.<br>
<br>
Julian<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div><br>