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