<div dir="ltr">Hi Ravi<div><br></div><div>My understanding of aggregates in Mondrian 4 is that the autodetect has been removed and you need to list them explicitly in the schema.</div><div><br></div><div>Tom</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr">--------------<div><br></div><div><div style="font-size:small"><font color="#999999">Director Meteorite.bi - Saiku Analytics Founder</font></div><div style="font-size:small"><font color="#999999">Tel: +44(0)5603641316 </font></div><div style="font-size:small"><font color="#999999"><br></font></div><div style="font-size:small"><font color="#999999">(Thanks to the Saiku community we reached our <a href="http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/" target="_blank">Kickstart</a> goal, but you can always help by <a href="http://www.meteorite.bi/products/saiku/sponsorship" target="_blank">sponsoring the project</a>)</font></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 28 June 2016 at 10:41, Ravi Prakash <span dir="ltr"><<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi All,<div><br></div><div>- I am using Saiku with Mondrian Version 4</div><div>- I am trying to make Saiku use Aggregate table</div><div><br></div><div>1. I have a Fact Table: <b>auction_fact</b></div><div>Columns</div><div>1. Id</div><div>2. Date</div><div>3. Hour</div><div>4. Name</div><div>5. requests</div><div>6. Wins</div><div><br></div><div>2. I have created two Aggregate Fact table, both with Lost dimension. </div><div>What I understood <a href="http://mondrian.pentaho.com/documentation/aggregate_tables.php#Recognizing_default" target="_blank">from</a> is agg_.+_${fact_table_name} is the default template.</div><div>I have not made any changes in <b>DefaultRulesSchema.xml</b></div><div><br></div><div>i. <b>agg_nh_</b><span style="line-height:1.5"><b>auction_fact</b> (With lost id, Hour) </span></div><div><span style="line-height:1.5"><br></span></div><div><div>1. Date</div><div>2. Hour</div><div>3. Name</div><div>4. requests</div><div>5. Wins</div><br></div><div>ii. <span style="line-height:1.5"><b>agg_nh_</b></span><span style="line-height:1.5"><b>auction_fact</b> (With lost id, Hour, Name )</span></div><div><br></div><div><div>1. Date</div><div>2. Hour</div><div><span style="line-height:1.5">3. requests</span><br></div><div>5. Wins</div><br></div><div>3. I have made below changes in mondrian.xml</div><div><br></div><div>mondrian.rolap.aggregates.Use=true<br></div><div>mondrian.rolap.aggregates.Read=true<br></div><div><br></div><div>4. I have not made any changes to the auction_cube.xml, I have not mentioned anything related to Aggregate tables.</div><div><br></div><div><span style="line-height:1.5">- I am getting below Exceptions when try to run queries</span><br></div><div><br></div><div><div><span style="white-space:pre-wrap"> </span>at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.olap.Util.newInternal(Util.java:2543)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.olap.Util.newError(Util.java:2559)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:535)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446)</div><div><span style="white-space:pre-wrap"> </span>at java.util.concurrent.FutureTask.run(FutureTask.java:262)</div><div><span style="white-space:pre-wrap"> </span>at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</div><div><span style="white-space:pre-wrap"> </span>at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</div><div><span style="white-space:pre-wrap"> </span>... 1 more</div><div>Caused by: java.lang.UnsupportedOperationException: obsolete</div><div><span style="white-space:pre-wrap"> </span>at mondrian.olap.Util.deprecated(Util.java:1326)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.RolapStar$Table.getJoinCondition(RolapStar.java:934)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.aggmatcher.AggGen.init(AggGen.java:245)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.aggmatcher.AggGen.<init>(AggGen.java:63)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.BatchLoader$Batch.generateAggregateSql(FastBatchingCellReader.java:1447)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.BatchLoader$Batch.loadAggregation(FastBatchingCellReader.java:1280)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.BatchLoader$Batch.load(FastBatchingCellReader.java:1272)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.BatchLoader.load(FastBatchingCellReader.java:885)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:999)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:965)</div><div><span style="white-space:pre-wrap"> </span>at mondrian.rolap.agg.SegmentCacheManager$Actor.run(SegmentCacheManager.java:957)</div><div><span style="white-space:pre-wrap"> </span>... 1 more</div></div><div><br></div><div>- Do I need to make any changes, shouldn't mondrian be able to search the for the aggregate tables?</div><div><br></div><div><br></div></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>