[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