<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>
<div><br>
</div>
<div>That looks correct, assuming you have key links on your agg table. &nbsp;If you have the collapsed attribute values you can use &lt;CopyLink&gt;.</div>
<div><br>
</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:12pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>&lt;<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>&gt; on behalf of kevin melo &lt;<a href="mailto:kevinmelo92@gmail.com">kevinmelo92@gmail.com</a>&gt;<br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Date: </span>Tuesday, February 23, 2016 at 10:31 AM<br>
<span style="font-weight:bold">To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Aggregation tables and AggPattern<br>
</div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Thanks Matt, i already saw that example and i use him to create the shared dimension.
<div><br>
</div>
<div>One lat question, about aggregation tables.</div>
<div><br>
</div>
<div>I Have a physical table call 'agg_fat_proc' and i want use him, he have 3 measure and one dimension, then i have to create the MeasureGroup like:</div>
<div>
<div>&lt;MeasureGroup table=&quot;agg_fat_proc&quot; type=&quot;aggregate&quot;&gt;</div>
<div><span class="" style="white-space:pre"></span>&lt;Measures&gt;</div>
<div><span class="" style="white-space:pre"></span>&lt;MeasureRef aggColumn=&quot;amount&quot; &nbsp;name=&quot;amount&quot;/&gt;</div>
<div><span class="" style="white-space:pre"></span>&lt;MeasureRef aggColumn=&quot;price&quot; name=&quot;price&quot;/&gt;</div>
<div><span class="" style="white-space:pre"></span>&lt;MeasureRef aggColumn=&quot;fact_count&quot; name=&quot;fact_count&quot;/&gt;</div>
<div><span class="" style="white-space:pre"></span>&lt;/Measures&gt;</div>
<div>&lt;/MeasureGroup&gt;</div>
<div>&lt;DimensionLinks&gt;</div>
<div><span class="" style="white-space:pre"></span>&lt;ForeignKeyLink dimension=&quot;myDimension&quot; foreignKeyColumn=&quot;iddimension&quot;/&gt;</div>
<div>&lt;/DimensionLinks&gt;</div>
</div>
<div><br>
</div>
<div>That's Correct?</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-02-23 11:45 GMT-03:00 Matt Campbell <span dir="ltr">
&lt;<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>&gt;</span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div><br>
</div>
<div>Yes, you’ll have to create an ‘aggregate’ type MeasureGroup for each agg table you want to use with a cube.</div>
<div><br>
</div>
<div>For your dimension usage question, yep, that’s about right, although I don’t think you wrap the shared dimensions in an outer &lt;Dimensions&gt; tag.&nbsp; You can use the M4 Foodmart schema as an example: &nbsp;<a href="https://github.com/pentaho/mondrian/blob/lagunitas/demo/FoodMart.mondrian.xml" target="_blank">https://github.com/pentaho/mondrian/blob/lagunitas/demo/FoodMart.mondrian.xml</a></div>
<div><br>
</div>
<div>
<div></div>
</div>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span class=""><span style="font-weight:bold">From: </span>&lt;<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>&gt; on behalf of kevin melo &lt;<a href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>&gt;<br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>&gt;<br>
</span><span style="font-weight:bold">Date: </span>Tuesday, February 23, 2016 at 9:41 AM<br>
<span style="font-weight:bold">To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Aggregation tables and AggPattern<br>
</div>
<div>
<div class="h5">
<div><br>
</div>
<div>
<div>
<div dir="ltr">Hmm i understand.
<div><br>
</div>
<div>1. Then i have to create every single agg_table inside my cube as GroupMeasure?</div>
<div><br>
</div>
<div>1. And another question, for me to use the 'DimensionUsage' in mondrian 4 i have to create a schema dimension, and then inside my cube i have to reffer this dimension? Something like:</div>
<div>&lt;Schema&gt;</div>
<div>&nbsp; &nbsp; &lt;Dimension&gt;&lt;/Dimension&gt;</div>
<div>&nbsp; &nbsp; &lt;Cube&gt;</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &lt;Dimensions&gt;</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Dimension source=&quot;mydimension&quot;/&gt;</div>
<div>&nbsp; &nbsp; &nbsp; &nbsp; &lt;/Dimensions&gt;</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-02-23 11:24 GMT-03:00 Matt Campbell <span dir="ltr">
&lt;<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>&gt;</span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div>
<div><br>
</div>
<div>There’s no support for “implicit” recognizing of aggregate tables in Mondrian 4— you do need to explicitly set up your aggregate definitions in your schema.</div>
<div><br>
</div>
<div>In M3 the implicit recognizer can be convenient, but it can also be a big source of headaches and complexity since it muddies the waters around which aggregate tables are picked up and why.</div>
<div>
<div></div>
</div>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>&lt;<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>&gt; on behalf of kevin melo &lt;<a href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>&gt;<br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Date: </span>Tuesday, February 23, 2016 at 8:43 AM<br>
<span style="font-weight:bold">To: </span>Mondrian list &lt;<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>&gt;<br>
<span style="font-weight:bold">Subject: </span>[Mondrian] Aggregation tables and AggPattern<br>
</div>
<div>
<div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Good day,
<div><br>
</div>
<div>I have a question about the mondrian 4.</div>
<div><br>
</div>
<div>In Mondrian 3 you can use the 'AggPattern' to get all AggTables without write all theirs attributes in the schema.</div>
<div><br>
</div>
<div>But in mondrian 4 how i can do that? I Have to write every single aggregation inside my GroupMeasures?</div>
<div>Or have any way to use the 'AggPattern' in mondrian 4?</div>
<div><br>
</div>
<div>I saw the <a href="http://mondrian.pentaho.com/head/documentation/schema.php#Schema_eleme" target="_blank">
documentation</a>&nbsp;but it's seeing it is out of date some things.</div>
<div><br>
</div>
<div>Can you guys help me?</div>
</div>
</div>
</div>
</div>
</div>
</span></div>
<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>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</span></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>
</div>
</div>
</span>
</body>
</html>