<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">To be clear. This is an issue with JPivot. The feature was implemented in Mondrian (see&nbsp;<a href="http://jira.pentaho.com/browse/MONDRIAN-335">http://jira.pentaho.com/browse/MONDRIAN-335</a>) and AFAIK works correctly.<div><div><br></div><div>Julian</div><div><br><div><div>On Oct 21, 2011, at 8:55 PM, Andy Grohe wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">I am trying to add a calculated member representing the aggregate of all children in a level<br><br>with member [Markets].[Territory].[Andy] as 'Aggregate([Markets].[All Markets].Children)'<br>select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,<br>
&nbsp; [Markets].[Territory].Allmembers ON ROWS<br>from [SteelWheelsSales]<br><br>If I run that in JPivot, the Andy measure is assigned to a new hierarchy.<br><br>I see <br><br><table border="0" height="202" width="171"><tbody><tr>
</tr><tr>
        <td valign="top"><p><table id="table8297b380-fc5e-11e0-9fb6-cfb6b81b5df0" class="mdxtable" border="0" cellpadding="2" cellspacing="1"><tbody><tr><th class="corner-heading" colspan="1" rowspan="1" nowrap="">&nbsp;</th><th class="heading-heading" colspan="1" rowspan="1" nowrap="">
<img src="http://centp40:8080/pentaho/jpivot/table/drill-position-other.gif" border="0" height="9" width="9">Measures</th></tr><tr><th class="heading-heading" colspan="1" rowspan="1" nowrap=""><img src="http://centp40:8080/pentaho/jpivot/table/drill-position-other.gif" border="0" height="9" width="9">Full</th>
<th class="column-heading-even" colspan="1" rowspan="1" nowrap=""><input name="wcf82885f10" title="Natural Order" src="http://centp40:8080/pentaho/jpivot/table/sort-natural.gif" border="0" height="9" type="image" width="9"><img src="http://centp40:8080/pentaho/jpivot/table/drill-position-other.gif" border="0" height="9" width="9">Quantity</th>
</tr><tr><th class="row-heading-even" colspan="1" rowspan="1" nowrap=""><div style="margin-left: 0em"><input title="" name="wcfda86e2a8" src="http://centp40:8080/pentaho/jpivot/table/drill-position-expand.gif" border="0" height="16" type="image" width="16">#null</div>
</th><td class="cell-even" nowrap="">&nbsp;</td></tr><tr><th class="row-heading-odd" colspan="1" rowspan="1" nowrap=""><div style="margin-left: 0em"><input title="" name="wcffa65f0a4" src="http://centp40:8080/pentaho/jpivot/table/drill-position-expand.gif" border="0" height="16" type="image" width="16">APAC</div>
</th><td class="cell-odd" nowrap="">12,878</td></tr><tr><th class="row-heading-even" colspan="1" rowspan="1" nowrap=""><div style="margin-left: 0em"><input title="" name="wcf1e773826" src="http://centp40:8080/pentaho/jpivot/table/drill-position-expand.gif" border="0" height="16" type="image" width="16">EMEA</div>
</th><td class="cell-even" nowrap="">49,578</td></tr><tr><th class="row-heading-odd" colspan="1" rowspan="1" nowrap=""><div style="margin-left: 0em"><input title="" name="wcf2db3f517" src="http://centp40:8080/pentaho/jpivot/table/drill-position-expand.gif" border="0" height="16" type="image" width="16">Japan</div>
</th><td class="cell-odd" nowrap="">4,923</td></tr><tr><th class="row-heading-even" colspan="1" rowspan="1" nowrap=""><div style="margin-left: 0em"><input title="" name="wcf8a8a9a30" src="http://centp40:8080/pentaho/jpivot/table/drill-position-expand.gif" border="0" height="16" type="image" width="16">NA</div>
</th><td class="cell-even" nowrap="">37,952</td></tr></tbody></table> 
        
        </p><div> 
        <br class="webkit-block-placeholder"></div></td>
        <td valign="top">
        
        <br></td></tr></tbody></table>But I would want to see the Andy member alongside the Children.<br><br>I can only get it to display when specifically called out like so.<br><br>with member [Markets.Full].[Andy] as 'Aggregate([Markets.Full].[All Markets].Children)'<br>
select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,<br>&nbsp; {[Markets.Full].[Andy], [Markets].[All Markets].Children} ON ROWS<br>from [SteelWheelsSales]<br><br>It also appears that mondrian does not let you add members at other levels other than the root level.&nbsp; Is this correct?<br>
<br>Any ideas or thoughts on getting a calculated member on a lower level?<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">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br></blockquote></div><br></div></div></body></html>