aggregate tables not used

[darkmanta]

Hi everybody,

I'm using jasper reports server 4.2.1 Build: 20111017_0932

I have designed a cube that is working well but as it is growing (3 million records) it's becaming slow.

I have built and deployed 3 ad-hoc aggregate tables using "Pentaho Aggregation Designer" and the resulting OLAP schema is working as usual but is still not using the aggregate tables. 

mondrian.properties file is like this: 

---

# Allow the use of aggregates
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.native.topcount.enable=true
mondrian.native.filter.enable=true

# mondrian.properties
mondrian.result.limit=50000
mondrian.olap.NullMemberRepresentation=[NULL]

# For XML/A JSPs
mondrian.test.connectString=Provider=mondrian;Jdbc=jdbc:odbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;Catalog=/WEB-INF/queries/FoodMart.xml;

mondrian.rolap.nonempty=false
mondrian.olap.fun.crossjoin.optimizer.size=100000
mondrian.native.crossjoin.enable=true
mondrian.native.nonempty.enable=false
mondrian.rolap.aggregates.generateSql=true
#mondrian.rolap.generate.formatted.sql

---

Any suggestion is highly appreciated. Thank you.

[karlose]

Se que ha pasado algo de tiempo, pero tengo el mismo inconveniente y me gustaria saber si alguien ha logrado solucionarlo o encontrar algo mas al respecto