<div dir="ltr">That's because if I say that I want the NON EMPTY members of a given level, it is dependent on the measure that I've evaluated. The empty members will not be the same for a different measure / calculated member. <div><br></div><div>The cache of level members only applies to fully populated sections of the level. </div><div><br></div><div>Once the full list of members is cached, it is easy for subsequent to cross reference it with the cache of cells and filter out the empty tuples.</div><div><br></div><div>About <span style="font-family:Calibri,sans-serif;font-size:15px">mondrian.native.nonempty.</span><span style="font-family:Calibri,sans-serif;font-size:15px">enable</span>. This property controls whether the empty tuples are computed by the DBMS (native) or not. As a general rule of thumb, it i always faster to compute non-empty tuples in the DBMS, because we combine this operation with other optimizations, like cross joins and filters.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 16, 2015 at 2:34 PM, Ganong, Kenneth <span dir="ltr"><<a href="mailto:ken.ganong@truvenhealth.com" target="_blank">ken.ganong@truvenhealth.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">I am trying to understand the significance of storing vs. not storing non-empty members in cache. The test case “testLevelMembersWithoutNonEmpty” in the NonEmptyTest.java seems to be asserting that the NON EMPTY [Customers].[Name].Members
is NOT in cache while it also asserts that [Customers].[Name].Members is in cache. Could someone please help me understand the purpose of this – why NON EMPTY members should not be in cache while we expect the [Customers].[Name].Members to be in cache?
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Setting the property mondrian.native.nonempty.enable=false in mondrian.properties seems to do the opposite. What does this property do with caching and NON-EMPTY?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"> Ken<u></u><u></u></p>
</div>
</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>