[Mondrian] Iterable ResultStyle vs List ResultStyle

Robin Tharappel rtharappel at prospricing.com
Tue Sep 4 17:03:57 EDT 2007



In reviewing tracker 1755778 (Cross Join with Filter returns empty
result set), it appears that the type of ResultStyle impacts the result
set returned in some cases. Using JDK 1.5 the Iterable ResultStyle will
be used and the List ResultStyle will be used with JDK 1.4.  Given the
following MDX:


WITH SET [#DataSet#] as 'Filter(Crossjoin({[Store].[All Stores]},
{[Customers].[All Customers]}), 
[Measures].[Unit Sales] > 0)' 
SELECT {[Measures].[Unit Sales]} ON COLUMNS, 
{[#DataSet#] } ON ROWS FROM Sales



Using the Iterable ResultStyle (with JDK 1.5) an empty result set is
returned. However if I force the ResultStyle to List the correct result
set is returned. It appears that the List implementation is evaluating
the expressions while the list is created.  The Iterable implementation
evaluates the expressions during iteration. Should the Iterable
ResultStyle evaluate the expressions when it is created (similar to the
List ResultStyle) ?  







The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070904/5a35ee73/attachment.html 

More information about the Mondrian mailing list