<br>Here's a query I just ran in Analysis Services. If a member is defined on dimension it has 0 children, and it's parent is *not* All. It's level ordinal is 0. <br><br>The other way to define a calculated member is to attach it to another member. The second set of members in my query has a calculated member attached to "All Gender". In that case it's parent *is* all and it's ordinal is 1. It still has 0 children, but now has 2 siblings.<br>
<br><br>with<br> member gender.calculated as 'gender.m'<br>member gender.[All Gender].calculated as 'gender.m'<br>member measures.countChildren as 'gender.calculated.children.Count'<br>member measures.parentIsAll as 'gender.calculated.Parent IS gender.[All Gender]'<br>
member measures.levelOrdinal as 'gender.calculated.Level.Ordinal'<br><br>member measures.definedOnAllLevelOrdinal as 'gender.[all gender].calculated.Level.Ordinal'<br>member measures.definedOnAllLevelParentIsAll as 'gender.[all gender].calculated.Parent IS gender.[All Gender]'<br>
member measures.definedOnAllLevelChildren as 'gender.[all gender].calculated.Children.Count'<br>member measures.definedOnAllLevelSiblings as 'gender.[all gender].calculated.Siblings.Count'<br><br>select { measures.[countChildren], -- returns 0<br>
measures.parentIsAll, -- returns 0<br> measures.levelOrdinal, -- returns 0<br> measures.definedOnAllLevelOrdinal, -- returns 1<br> measures.definedOnAllLevelParentIsAll, -- returns 1<br>measures.definedOnAllLevelChildren, -- returns 0<br>
measures.definedOnAllLevelSiblings -- returns 2<br> } on 0 from sales<br><br><br><div class="gmail_quote">On Feb 17, 2008 11:01 PM, John V. Sichi <<a href="mailto:jsichi@gmail.com">jsichi@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">Will Gorman wrote:<br>> A quick fix to this problem was to not set the all flag for calculated<br>
> members. My question is should these calculated members be created at<br>> the [(All)] level in the first place? Also, should calculated members<br>> have the all member if it exists as a parent?<br><br></div>
Seems like they should be children of the all member when it exists and<br>when no other parent is specified (if specifying a parent were working).<br><br>Maybe there's a way to test what MSAS does in that case?<br><font color="#888888"><br>
JVS<br></font><div><div></div><div class="Wj3C7c">_______________________________________________<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>
</div></div></blockquote></div><br>