[Mondrian] Segment rollup issue

Luc Boudreau lucboudreau at gmail.com
Tue Oct 8 11:30:27 EDT 2013


Also, would you mind adding an assertion in the code? I can't think of any
situation where a segment should be constrained on no values at all. This
would always result in an empty segment.

Luc


On Tue, Oct 8, 2013 at 11:27 AM, Luc Boudreau <lucboudreau at gmail.com> wrote:

> Sounds like it is using the last segment of the ones that need to be
> rolled up and it can't find the value '1998' explicitly, so it fails.
>
> Your assumption is right. The resulting segment should be constrained on
> 1998. That's the only possible valid result.
>
> Luc
>
>
> On Tue, Oct 8, 2013 at 11:23 AM, Matt Campbell <mcampbell at pentaho.com>wrote:
>
>>
>> We've had an issue for quite awhile where some small set of tests fail
>> infrequently with the error "Query required more than 12 iterations".  I
>> think I now have a general idea of what's going on, and thought I'd
>> describe what I've seen in case others have insight.
>>
>> In some tests (e.g. FunctionTest.testLastPeriods()) a cell request is
>> made for [1998].[Q1].  The cache at this point contains the following two
>> segments:
>>
>> Axes:[
>>     {time_by_day.the_year=('1998')}
>>     {time_by_day.quarter=(*)}
>>     {time_by_day.month_of_year=('2','3','4','5','6','7')}]
>>
>> Axes:[
>>     {time_by_day.the_year=(*)}
>>     {time_by_day.quarter=(*)}
>>     {time_by_day.month_of_year=('1','8','9','10','11','12')}]
>>
>>
>> Which get rolled up to
>>
>> Axes:[
>>     {time_by_day.the_year=)}
>>     {time_by_day.quarter=(*)}]
>>
>>
>> Note that the_year=<blank>, which occurs when the values list is non-null
>> but empty.  Because the_year has an empty values list, the cell request for
>> [1998].[Q1] cannot be answered, and we repeat the cycle, again rolling up
>> the same 2 segments.
>>
>> I believe the rolled up segment in this case should be constrained by
>> '1998'.  Does that sound right?
>>
>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20131008/86da1f63/attachment.html 


More information about the Mondrian mailing list