[Mondrian] Cache is not being used.

[Venkatesh U]

Hi,
 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??

select
{NonEmptyCrossJoin([DOW].Members,NonEmptyCrossJoin([DiscountBin].Members,NonEmptyCrossJoin([NI].Members,NonEmptyCrossJoin([LocationArea].Members,NonEmptyCrossJoin([Service].Members,NonEmptyCrossJoin([Product].Members,NonEmptyCrossJoin([Month].[2010].[1].[FEBRUARY],
NonEmptyCrossJoin([TOD].Members,NonEmptyCrossJoin([IO].Members,
[ForeignNetwork].Members)))))))))} on rows,
{[Measures].Members} on columns
from [ServiceFactsByMonthWC]

*Below is my mondrian.properties*

# mondrian.properties
mondrian.result.limit=0

# For XML/A JSPs
mondrian.test.connectString=Provider=mondrian;Jdbc=jdbc:oracle:thin:cimdds1/cimdds1@
//
10.184.17.204:1521/cim;JdbcDrivers=oracle.jdbc.OracleDriver;Catalog=/WEB-INF/queries/testCube.xml
;

#tracing
mondrian.trace.level=2
mondrian.native.crossjoin.enable=true
mondrian.native.nonempty.enable=true
mondrian.result.highCardChunkSize=30000
mondrian.native.unsupported.alert=WARN

*attached is the log of Execution.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20101021/34926e7c/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.log
Type: application/octet-stream
Size: 85074 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20101021/34926e7c/attachment.obj