[Mondrian] Cache is not being used.

Julian Hyde jhyde at pentaho.com
Thu Oct 21 18:52:46 EDT 2010


Mondrian does not currently roll up values within the cache.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Venkatesh U
Sent: Thursday, October 21, 2010 4:44 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Cache is not being used.


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,Non
EmptyCrossJoin([NI].Members,NonEmptyCrossJoin([LocationArea].Members,NonEmpt
yCrossJoin([Service].Members,NonEmptyCrossJoin([Product].Members,NonEmptyCro
ssJoin([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;Catalo
g=/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/503a7a57/attachment.html 


More information about the Mondrian mailing list