[Mondrian] Aggregate Table

Ravi Prakash ravi.prakash.shahi at gmail.com
Tue Jun 28 05:41:24 EDT 2016


Hi All,

- I am using Saiku with Mondrian Version 4
- I am trying to make Saiku use Aggregate table

1. I have a Fact Table: *auction_fact*
Columns
1. Id
2. Date
3. Hour
4. Name
5. requests
6. Wins

2. I have created two Aggregate Fact table, both with Lost dimension.
What I understood from
<http://mondrian.pentaho.com/documentation/aggregate_tables.php#Recognizing_default>
is agg_.+_${fact_table_name} is the default template.
I have not made any changes in *DefaultRulesSchema.xml*

i. *agg_nh_**auction_fact* (With lost id, Hour)

1. Date
2. Hour
3. Name
4. requests
5. Wins

ii. *agg_nh_**auction_fact* (With lost id, Hour, Name )

1. Date
2. Hour
3. requests
5. Wins

3. I have made below changes in mondrian.xml

mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true

4. I have not made any changes to the auction_cube.xml, I have not
mentioned anything related to Aggregate tables.

- I am getting below Exceptions when try to run queries

at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
at mondrian.olap.Util.newInternal(Util.java:2543)
at mondrian.olap.Util.newError(Util.java:2559)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:535)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
Caused by: java.lang.UnsupportedOperationException: obsolete
at mondrian.olap.Util.deprecated(Util.java:1326)
at mondrian.rolap.RolapStar$Table.getJoinCondition(RolapStar.java:934)
at mondrian.rolap.aggmatcher.AggGen.init(AggGen.java:245)
at mondrian.rolap.aggmatcher.AggGen.<init>(AggGen.java:63)
at
mondrian.rolap.BatchLoader$Batch.generateAggregateSql(FastBatchingCellReader.java:1447)
at
mondrian.rolap.BatchLoader$Batch.loadAggregation(FastBatchingCellReader.java:1280)
at mondrian.rolap.BatchLoader$Batch.load(FastBatchingCellReader.java:1272)
at mondrian.rolap.BatchLoader.load(FastBatchingCellReader.java:885)
at
mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:999)
at
mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:965)
at
mondrian.rolap.agg.SegmentCacheManager$Actor.run(SegmentCacheManager.java:957)
... 1 more

- Do I need to make any changes, shouldn't mondrian be able to search the
for the aggregate tables?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160628/8a827733/attachment.html 


More information about the Mondrian mailing list