[Mondrian] Re: [Fwd: Eigenbase perforce change 8704 for review]
Haridasan T
haridasan.t at gmail.com
Thu Mar 1 08:48:46 EST 2007
Greetings,
Appreciate if you can help me to connect to oracle database from Mondrian
Which all xml files need to be changed
Thanks
Hari Nair
--
On 2/27/07, John V. Sichi <jsichi at gmail.com> wrote:
>
> Followup performance analysis revealed that the overconservatism of this
> fix had a significant negative impact on performance. I'll have someone
> working on an optimal fix, but it may not be for a few weeks. In the
> meantime, if you'd prefer the bug to the performance drag, comment out
> the body of RolapResult.clearNamedSets.
>
> JVS
>
> John V. Sichi wrote:
> > Review comments on the change below are welcome. The test case
> > illustrates why I had to make it, but there's probably a smart way to
> > avoid re-evaluating named set expressions which don't need it.
> >
> > JVS
> >
> > -------- Original Message --------
> > Subject: Eigenbase perforce change 8704 for review
> > Date: Tue, 13 Feb 2007 01:58:01 -0800 (PST)
> > From: John V. Sichi <jsichi at gmail.com>
> > To: Andreas Voss <tonbeller at a-voss.de>, Bart Pappyn
> > <bppn at users.sourceforge.net>, Hartmut Haas <Hartmut_Haas at tonbeller.com>,
> > Julian Hyde <jhyde at users.sourceforge.net>, John V. Sichi
> > <jsichi at gmail.com>, Kinkoi Lo <kinkoi at gmail.com>, Matt Campbell
> > <Matthew.Campbell at thomson.com>, Sam Birney <sbirney at jaspersoft.com>
> >
> > http://p4web.eigenbase.org/@md=d&c=6PU@//8704?ac=10
> >
> > Change 8704 by jvs at jvs.kotick.eigenbase on 2007/02/13 01:58:00
> >
> > MONDRIAN: clear named set cache whenever cache of other
> > expressions is cleared; otherwise, an incorrect value
> > for a named set can be reused
> >
> > Affected files ...
> >
> > ... //open/mondrian/src/main/mondrian/rolap/RolapEvaluator.java#55 edit
> > ... //open/mondrian/src/main/mondrian/rolap/RolapResult.java#89 edit
> > ... //open/mondrian/testsrc/main/mondrian/test/ClearViewTest.java#3 edit
> >
> > Differences ...
> >
> > ==== //open/mondrian/src/main/mondrian/rolap/RolapEvaluator.java#55
> > (ktext) ====
> >
> > 2c2
> > < // $Id: //open/mondrian/src/main/mondrian/rolap/RolapEvaluator.java#54
> $
> > ---
> >> // $Id: //open/mondrian/src/main/mondrian/rolap/RolapEvaluator.java#55
> $
> > 39c39
> > < * @version $Id:
> > //open/mondrian/src/main/mondrian/rolap/RolapEvaluator.java#54 $
> > ---
> >> * @version $Id:
> >> //open/mondrian/src/main/mondrian/rolap/RolapEvaluator.java#55 $
> > 186a187,192
> >> * Clears cached values for all named sets.
> >> */
> >> protected void clearNamedSets() {
> >> }
> >>
> >> /**
> > 659a666,673
> >>
> >> // Clear cached named sets at the same time we clear other
> cached
> >> // expressions. This may be overconservative in some cases,
> but
> >> // without this, there can be bugs when incorrect results get
> >> cached
> >> // for named sets which depend on measures which haven't been
> >> loaded
> >> // yet. See mondrian.test.ClearViewTest.testLer4260 for an
> >> // example.
> >> root.clearNamedSets();
> >
> > ==== //open/mondrian/src/main/mondrian/rolap/RolapResult.java#89 (ktext)
> > ====
> >
> > 2c2
> > < // $Id: //open/mondrian/src/main/mondrian/rolap/RolapResult.java#88 $
> > ---
> >> // $Id: //open/mondrian/src/main/mondrian/rolap/RolapResult.java#89 $
> > 40c40
> > < * @version $Id:
> > //open/mondrian/src/main/mondrian/rolap/RolapResult.java#88 $
> > ---
> >> * @version $Id:
> >> //open/mondrian/src/main/mondrian/rolap/RolapResult.java#89 $
> > 809a810,813
> >> protected void clearNamedSets() {
> >> namedSetValues.clear();
> >> }
> >>
> >
> > ==== //open/mondrian/testsrc/main/mondrian/test/ClearViewTest.java#3
> > (ktext) ====
> >
> > 2c2
> > < // $Id:
> //open/mondrian/testsrc/main/mondrian/test/ClearViewTest.java#2 $
> > ---
> >> // $Id: //open/mondrian/testsrc/main/mondrian/test/ClearViewTest.java#3
> $
> > 20c20
> > < * @version $Id:
> > //open/mondrian/testsrc/main/mondrian/test/ClearViewTest.java#2 $
> > ---
> >> * @version $Id:
> >> //open/mondrian/testsrc/main/mondrian/test/ClearViewTest.java#3 $
> > 164a165,198
> >>
> >> /**
> >> * Tests a bug with incorrect reuse of a named set which can't be
> >> * computed directly against a cold cache.
> >> */
> >> public void testLer4260() {
> >> assertQueryReturns(
> >> "With Set [*BMEL] as \n" +
> >> "'[Education Level].[Education Level].Members' \n" +
> >> "Member [Measures].[*TBM] as \n" +
> >> "'Rank([Education Level].CurrentMember, \n" +
> >> "Order([*BMEL],([Measures].[Unit Sales]),BDESC))' \n" +
> >> "Set [*SM_RSUM_SET_0] as \n" +
> >> "'Filter([*BMEL],[Measures].[*TBM] <= 3)'\n" +
> >> "select [*SM_RSUM_SET_0] on rows, \n" +
> >> "{[Measures].[*TBM], [Measures].[Unit Sales]} on columns
> >> \n" +
> >> "From [Sales]",
> >> fold(
> >> "Axis #0:\n" +
> >> "{}\n" +
> >> "Axis #1:\n" +
> >> "{[Measures].[*TBM]}\n" +
> >> "{[Measures].[Unit Sales]}\n" +
> >> "Axis #2:\n" +
> >> "{[Education Level].[All Education Levels].[Bachelors
> >> Degree]}\n" +
> >> "{[Education Level].[All Education Levels].[High
> >> School Degree]}\n" +
> >> "{[Education Level].[All Education Levels].[Partial
> >> High School]}\n" +
> >> "Row #0: 3\n" +
> >> "Row #0: 68,839\n" +
> >> "Row #1: 2\n" +
> >> "Row #1: 78,664\n" +
> >> "Row #2: 1\n" +
> >> "Row #2: 79,155\n"));
> >> }
> >
> >
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
--
http://cfo-portal.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070301/007253aa/attachment-0001.html
More information about the Mondrian
mailing list