Hi,<br>it does not roll up from the cache, but when a NonEmptyCrossjoin is fired, it issues group by statement to calculate the aggregates at each possible level, so my expectation is if i issue a crossjoin cache will contain the values for all possible dimension combinations below the attempted crossjoin and from what I have tested, this is working fine up to 6 dimensions.<br>
<br>what i mean here is<br>CJ(a,CJ(b,c)) < CJ- Crossjoin><br>for this cross join mondrian issues SQL as<br><br>sum() without group by<br>group by a<br>group by b<br>group by c<br>group by a,b<br>group by b,c<br>
group by c,a<br>group by a,b,c<br><br>In this case I am issuing a crossjoin of 8 dimensions and the SQL queries are fired the same way mentioned above. The problem is when I issue the same 8 dimension crossjoin query again, it does not use the cache, which works well in case of dimensions less than 5.<br>
<br><br>Thanks,<br>Venkatesh<br><br><br><br><br><br><div class="gmail_quote">On Fri, Oct 22, 2010 at 4:22 AM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<div><span><font color="#000080" face="Lucida Sans" size="2">Mondrian does not currently roll up values within the
cache.</font></span></div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span><font color="#000080" face="Lucida Sans" size="2">Julian</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Venkatesh
U<br><b>Sent:</b> Thursday, October 21, 2010 4:44 AM<br><b>To:</b>
<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br><b>Subject:</b> [Mondrian] Cache is not being
used.<br></font><br></div><div><div></div><div class="h5">
<div></div>Hi,<br> I am firing the below MDX query and every time it Hits
the database and the results are not being fetched from the cache. Can
somebody please help if I am missing some configuration? I have a highly
Sparse data with ( 10 dimensions). How do I ensure that mondrian is using
Sparse type of collection to save the results??<br><br>select
{NonEmptyCrossJoin([DOW].Members,NonEmptyCrossJoin([DiscountBin].Members,NonEmptyCrossJoin([NI].Members,NonEmptyCrossJoin([LocationArea].Members,NonEmptyCrossJoin([Service].Members,NonEmptyCrossJoin([Product].Members,NonEmptyCrossJoin([Month].[2010].[1].[FEBRUARY],<br>
NonEmptyCrossJoin([TOD].Members,NonEmptyCrossJoin([IO].Members,<br>[ForeignNetwork].Members)))))))))}
on rows,<br>{[Measures].Members} on columns<br>from
[ServiceFactsByMonthWC]<br><br><b>Below is my mondrian.properties</b><br><br>#
mondrian.properties<br>mondrian.result.limit=0<br><br># For XML/A
JSPs<br>mondrian.test.connectString=Provider=mondrian;Jdbc=jdbc:oracle:thin:cimdds1/cimdds1@//<a href="http://10.184.17.204:1521/cim;JdbcDrivers=oracle.jdbc.OracleDriver;Catalog=/WEB-INF/queries/testCube.xml" target="_blank">10.184.17.204:1521/cim;JdbcDrivers=oracle.jdbc.OracleDriver;Catalog=/WEB-INF/queries/testCube.xml</a>;<br>
<br>#tracing<br>mondrian.trace.level=2<br>mondrian.native.crossjoin.enable=true<br>mondrian.native.nonempty.enable=true<br>mondrian.result.highCardChunkSize=30000<br>mondrian.native.unsupported.alert=WARN<br><br><b>attached
is the log of Execution.</b><br></div></div></blockquote></div>
<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>