<div>Greetings,</div>
<div> </div>
<div>I am also new to Mondrian. Appreciate if your could let me know how to connect to Oracle. I copied the Oracle thin driver to apache/tomcat folder. But unable to connect to Oracle database. I am only able to run with access database.
</div>
<div> </div>
<div>Which all XML files need to be changed</div>
<div>(server.xml and datasources.xml)</div>
<div> </div>
<div>Please do mail me the syntax also</div>
<div> </div>
<div>Thanks</div>
<div> </div>
<div>Hari Nair<br><br> </div>
<div><span class="gmail_quote">On 3/3/07, <b class="gmail_sendername"><a href="mailto:Pranav.Matekar@zycus.com">Pranav.Matekar@zycus.com</a></b> <<a href="mailto:Pranav.Matekar@zycus.com">Pranav.Matekar@zycus.com</a>> wrote:
</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br><font face="sans-serif" size="2">hi</font> <br><br><font face="sans-serif" size="2">i am new to this group
</font> <br><font face="sans-serif" size="2">currently i am evaluating mondrian</font> <br><br><font face="sans-serif" size="2">i have done some testing on mondrian </font><br><font face="sans-serif" size="2">with 6,000,000 records
</font> <br><br><font face="sans-serif" size="2">and 60,000 elements in one dimension </font><br><font face="sans-serif" size="2">and 6000 elements in others 10 dimensions</font> <br><br><font face="sans-serif" size="2">i have used top in top, ie. top 10 supplier of top 10 categories (60,000 suppliers ), via using generate and topcount
</font> <br><font face="sans-serif" size="2">it's taking more than 10 min</font> <br><br><font face="sans-serif" size="2">and if i am applying filters on this query</font> <br><font face="sans-serif" size="2">result is not coming
</font> <br><br><font face="sans-serif" size="2">i am currently testing via oracle</font> <br><font face="sans-serif" size="2">i have created indexing on each column of star schema</font> <br><font face="sans-serif" size="2">
i have done analyze schema on oracle </font><br><br><font face="sans-serif" size="2"> </font> <br><font face="sans-serif" size="2">i used following setting</font> <br><font face="sans-serif" size="2">mondrian.native.topcount.enable=true
</font> <br><font face="sans-serif" size="2">mondrian.rolap.CachePool.costLimit=2147483647</font> <br><font face="sans-serif" size="2">mondrian.rolap.queryTimeout=600</font> <br><br><font face="sans-serif" size="2">i checked logging of mondrian
</font> <br><font face="sans-serif" size="2">it's doing top in memory</font> <br><font face="sans-serif" size="2">for 60,000 elements, if mondrian is doing top in memory and i am using top in top for this dimension with filters
</font> <br><font face="sans-serif" size="2">getting result in 1 min is difficult.</font> <br><br><font face="sans-serif" size="2">is there any solution for this problem?</font> <br><br><font face="sans-serif" size="2">thank you.
</font> <br><br><font face="sans-serif" size="2"><br>Pranav</font><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" target="_blank">
http://lists.pentaho.org/mailman/listinfo/mondrian</a><br><br></blockquote></div><br><br clear="all"><br>-- <br><a href="http://cfo-portal.blogspot.com/">http://cfo-portal.blogspot.com/</a>