<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18975"></HEAD>
<BODY>
<DIV><SPAN class=243235122-21102010><FONT color=#000080 size=2
face="Lucida Sans">Mondrian does not currently roll up values within the
cache.</FONT></SPAN></DIV>
<DIV><SPAN class=243235122-21102010><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=243235122-21102010><FONT color=#000080 size=2
face="Lucida Sans">Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Venkatesh
U<BR><B>Sent:</B> Thursday, October 21, 2010 4:44 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Cache is not being
used.<BR></FONT><BR></DIV>
<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">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></BLOCKQUOTE></BODY></HTML>