[Mondrian] Segment rollup issue

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


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/572756fa/attachment-0001.html 


More information about the Mondrian mailing list