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>