<div dir="ltr">I've not used Aggregates in about 10 years so I'm probably not the best person to ask, but I would look here: <a href="https://github.com/pentaho/mondrian/blob/lagunitas/demo/FoodMart.mondrian.xml#L461">https://github.com/pentaho/mondrian/blob/lagunitas/demo/FoodMart.mondrian.xml#L461</a> In Mondrian 4 they are defined within Measure Groups.<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:56, 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 Tom, Thanks a lot!!<div><br></div><div>Could you please point me to some good link explaining how to define Aggregate tables at cube level, I am mostly looking for Aggregate table with Lost dimension, I am not able to find a good sample example.<br><br><div class="gmail_quote"><div dir="ltr">On Tue, 28 Jun 2016 at 15:15 <<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Mondrian mailing list submissions to<br>
<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:mondrian-owner@pentaho.org" target="_blank">mondrian-owner@pentaho.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Mondrian digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Aggregate Table (Ravi Prakash)<br>
2. Re: Aggregate Table (Tom Barber)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 28 Jun 2016 09:41:24 +0000<br>
From: Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>><br>
Subject: [Mondrian] Aggregate Table<br>
To: Mondrian developer mailing list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>>,<br>
"<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>" <<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>><br>
Message-ID:<br>
<<a href="mailto:CAJQWdUDK31k57qS5Rpvdt-qJ02M3b4R2U2ivT3JJVbWWxkdG-g@mail.gmail.com" target="_blank">CAJQWdUDK31k57qS5Rpvdt-qJ02M3b4R2U2ivT3JJVbWWxkdG-g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi All,<br>
<br>
- I am using Saiku with Mondrian Version 4<br>
- I am trying to make Saiku use Aggregate table<br>
<br>
1. I have a Fact Table: *auction_fact*<br>
Columns<br>
1. Id<br>
2. Date<br>
3. Hour<br>
4. Name<br>
5. requests<br>
6. Wins<br>
<br>
2. I have created two Aggregate Fact table, both with Lost dimension.<br>
What I understood from<br>
<<a href="http://mondrian.pentaho.com/documentation/aggregate_tables.php#Recognizing_default" rel="noreferrer" target="_blank">http://mondrian.pentaho.com/documentation/aggregate_tables.php#Recognizing_default</a>><br>
is agg_.+_${fact_table_name} is the default template.<br>
I have not made any changes in *DefaultRulesSchema.xml*<br>
<br>
i. *agg_nh_**auction_fact* (With lost id, Hour)<br>
<br>
1. Date<br>
2. Hour<br>
3. Name<br>
4. requests<br>
5. Wins<br>
<br>
ii. *agg_nh_**auction_fact* (With lost id, Hour, Name )<br>
<br>
1. Date<br>
2. Hour<br>
3. requests<br>
5. Wins<br>
<br>
3. I have made below changes in mondrian.xml<br>
<br>
mondrian.rolap.aggregates.Use=true<br>
mondrian.rolap.aggregates.Read=true<br>
<br>
4. I have not made any changes to the auction_cube.xml, I have not<br>
mentioned anything related to Aggregate tables.<br>
<br>
- I am getting below Exceptions when try to run queries<br>
<br>
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)<br>
at mondrian.olap.Util.newInternal(Util.java:2543)<br>
at mondrian.olap.Util.newError(Util.java:2559)<br>
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:535)<br>
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45)<br>
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448)<br>
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446)<br>
at java.util.concurrent.FutureTask.run(FutureTask.java:262)<br>
at<br>
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<br>
at<br>
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<br>
... 1 more<br>
Caused by: java.lang.UnsupportedOperationException: obsolete<br>
at mondrian.olap.Util.deprecated(Util.java:1326)<br>
at mondrian.rolap.RolapStar$Table.getJoinCondition(RolapStar.java:934)<br>
at mondrian.rolap.aggmatcher.AggGen.init(AggGen.java:245)<br>
at mondrian.rolap.aggmatcher.AggGen.<init>(AggGen.java:63)<br>
at<br>
mondrian.rolap.BatchLoader$Batch.generateAggregateSql(FastBatchingCellReader.java:1447)<br>
at<br>
mondrian.rolap.BatchLoader$Batch.loadAggregation(FastBatchingCellReader.java:1280)<br>
at mondrian.rolap.BatchLoader$Batch.load(FastBatchingCellReader.java:1272)<br>
at mondrian.rolap.BatchLoader.load(FastBatchingCellReader.java:885)<br>
at<br>
mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:999)<br>
at<br>
mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:965)<br>
at<br>
mondrian.rolap.agg.SegmentCacheManager$Actor.run(SegmentCacheManager.java:957)<br>
... 1 more<br>
<br>
- Do I need to make any changes, shouldn't mondrian be able to search the<br>
for the aggregate tables?<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20160628/8a827733/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.pentaho.org/pipermail/mondrian/attachments/20160628/8a827733/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Tue, 28 Jun 2016 10:44:16 +0100<br>
From: Tom Barber <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>><br>
Subject: Re: [Mondrian] Aggregate Table<br>
To: Mondrian developer mailing list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
Cc: "<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>" <<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>><br>
Message-ID:<br>
<CAEM=<a href="mailto:DjPHtMhZMpLLLwMYEyj%2BLCv7BtSRqwjCEeJFJ0Gx-ovjWA@mail.gmail.com" target="_blank">DjPHtMhZMpLLLwMYEyj+LCv7BtSRqwjCEeJFJ0Gx-ovjWA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Ravi<br>
<br>
My understanding of aggregates in Mondrian 4 is that the autodetect has<br>
been removed and you need to list them explicitly in the schema.<br>
<br>
Tom<br>
<br>
--------------<br>
<br>
Director Meteorite.bi - Saiku Analytics Founder<br>
Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">+44(0)5603641316</a><br>
<br>
(Thanks to the Saiku community we reached our Kickstart<br>
<<a href="http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/" rel="noreferrer" target="_blank">http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/</a>><br>
goal, but you can always help by sponsoring the project<br>
<<a href="http://www.meteorite.bi/products/saiku/sponsorship" rel="noreferrer" target="_blank">http://www.meteorite.bi/products/saiku/sponsorship</a>>)<br>
<br>
On 28 June 2016 at 10:41, Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>> wrote:<br>
<br>
> Hi All,<br>
><br>
> - I am using Saiku with Mondrian Version 4<br>
> - I am trying to make Saiku use Aggregate table<br>
><br>
> 1. I have a Fact Table: *auction_fact*<br>
> Columns<br>
> 1. Id<br>
> 2. Date<br>
> 3. Hour<br>
> 4. Name<br>
> 5. requests<br>
> 6. Wins<br>
><br>
> 2. I have created two Aggregate Fact table, both with Lost dimension.<br>
> What I understood from<br>
> <<a href="http://mondrian.pentaho.com/documentation/aggregate_tables.php#Recognizing_default" rel="noreferrer" target="_blank">http://mondrian.pentaho.com/documentation/aggregate_tables.php#Recognizing_default</a>><br>
> is agg_.+_${fact_table_name} is the default template.<br>
> I have not made any changes in *DefaultRulesSchema.xml*<br>
><br>
> i. *agg_nh_**auction_fact* (With lost id, Hour)<br>
><br>
> 1. Date<br>
> 2. Hour<br>
> 3. Name<br>
> 4. requests<br>
> 5. Wins<br>
><br>
> ii. *agg_nh_**auction_fact* (With lost id, Hour, Name )<br>
><br>
> 1. Date<br>
> 2. Hour<br>
> 3. requests<br>
> 5. Wins<br>
><br>
> 3. I have made below changes in mondrian.xml<br>
><br>
> mondrian.rolap.aggregates.Use=true<br>
> mondrian.rolap.aggregates.Read=true<br>
><br>
> 4. I have not made any changes to the auction_cube.xml, I have not<br>
> mentioned anything related to Aggregate tables.<br>
><br>
> - I am getting below Exceptions when try to run queries<br>
><br>
> at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)<br>
> at mondrian.olap.Util.newInternal(Util.java:2543)<br>
> at mondrian.olap.Util.newError(Util.java:2559)<br>
> at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:535)<br>
> at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:45)<br>
> at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:448)<br>
> at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:446)<br>
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)<br>
> at<br>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<br>
> at<br>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<br>
> ... 1 more<br>
> Caused by: java.lang.UnsupportedOperationException: obsolete<br>
> at mondrian.olap.Util.deprecated(Util.java:1326)<br>
> at mondrian.rolap.RolapStar$Table.getJoinCondition(RolapStar.java:934)<br>
> at mondrian.rolap.aggmatcher.AggGen.init(AggGen.java:245)<br>
> at mondrian.rolap.aggmatcher.AggGen.<init>(AggGen.java:63)<br>
> at<br>
> mondrian.rolap.BatchLoader$Batch.generateAggregateSql(FastBatchingCellReader.java:1447)<br>
> at<br>
> mondrian.rolap.BatchLoader$Batch.loadAggregation(FastBatchingCellReader.java:1280)<br>
> at mondrian.rolap.BatchLoader$Batch.load(FastBatchingCellReader.java:1272)<br>
> at mondrian.rolap.BatchLoader.load(FastBatchingCellReader.java:885)<br>
> at<br>
> mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:999)<br>
> at<br>
> mondrian.rolap.BatchLoader$LoadBatchCommand.call(FastBatchingCellReader.java:965)<br>
> at<br>
> mondrian.rolap.agg.SegmentCacheManager$Actor.run(SegmentCacheManager.java:957)<br>
> ... 1 more<br>
><br>
> - Do I need to make any changes, shouldn't mondrian be able to search the<br>
> for the aggregate tables?<br>
><br>
><br>
><br>
> _______________________________________________<br>
> Mondrian mailing list<br>
> <a href="mailto:Mondrian@pentaho.org" target="_blank">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>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20160628/65e9b288/attachment.html" rel="noreferrer" target="_blank">http://lists.pentaho.org/pipermail/mondrian/attachments/20160628/65e9b288/attachment.html</a><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">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>
<br>
End of Mondrian Digest, Vol 114, Issue 6<br>
****************************************<br>
</blockquote></div></div></div>
</blockquote></div><br></div>