Hi.. at one point I had implemented a "Level" property addition to the schema to allow the addition of a calculated member at other than root levels (mondrian Jpivot). If you're interested, I can find the code and send it to you.. I'm not sure if it is compatible with the current version of mondrian, or if it would be an 'accepted' solution, but it worked .. which was the important part for me :)<br>
Cheers<div><br><div class="gmail_quote">On Sat, Oct 22, 2011 at 12:49 PM, Pedro Alves <span dir="ltr"><<a href="mailto:pmgalves@gmail.com">pmgalves@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<u></u>
<br>
Afaik your conclusion is correct. + 1 on that feature, would be extremely useful <br>
<br>
<br>
<br>
-pedro<br><br><div class="gmail_quote">Andy Grohe <<a href="mailto:agrohe21@gmail.com" target="_blank">agrohe21@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
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>
[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></p><table border="0" cellpadding="2" cellspacing="1"><tbody><tr><th colspan="1" rowspan="1" nowrap> </th><th colspan="1" rowspan="1" nowrap>
<img border="0" height="9" width="9">Measures</th></tr><tr><th colspan="1" rowspan="1" nowrap><img border="0" height="9" width="9">Full</th>
<th colspan="1" rowspan="1" nowrap><input name="wcf82885f10" title="Natural Order" border="0" height="9" type="image" width="9"><img border="0" height="9" width="9">Quantity</th>
</tr><tr><th colspan="1" rowspan="1" nowrap><div style="margin-left:0em"><input title="" name="wcfda86e2a8" border="0" height="16" type="image" width="16">#null</div>
</th><td nowrap> </td></tr><tr><th colspan="1" rowspan="1" nowrap><div style="margin-left:0em"><input title="" name="wcffa65f0a4" border="0" height="16" type="image" width="16">APAC</div>
</th><td nowrap>12,878</td></tr><tr><th colspan="1" rowspan="1" nowrap><div style="margin-left:0em"><input title="" name="wcf1e773826" border="0" height="16" type="image" width="16">EMEA</div>
</th><td nowrap>49,578</td></tr><tr><th colspan="1" rowspan="1" nowrap><div style="margin-left:0em"><input title="" name="wcf2db3f517" border="0" height="16" type="image" width="16">Japan</div>
</th><td nowrap>4,923</td></tr><tr><th colspan="1" rowspan="1" nowrap><div style="margin-left:0em"><input title="" name="wcf8a8a9a30" border="0" height="16" type="image" width="16">NA</div>
</th><td nowrap>37,952</td></tr></tbody></table>
<p></p><p>
</p></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> {[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. Is this correct?<br>
<br>Any ideas or thoughts on getting a calculated member on a lower level?<br>
</blockquote></div><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>
<br></blockquote></div><br></div>