<div dir="ltr">Thanks</div><div class="gmail_extra"><br><div class="gmail_quote">2016-02-24 10:28 GMT-03:00 Matt Campbell <span dir="ltr"><<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>></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>A collapsed dimension in an aggregate table will have the set of columns containing level values present in the agg table, rather than the dimension key. For that you would use a CopyLink instead of the ForeignKeyLink.</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><<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
</span><span style="font-weight:bold">Date: </span>Tuesday, February 23, 2016 at 11:03 AM<div><div class="h5"><br>
<span style="font-weight:bold">To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Aggregation tables and AggPattern<br>
</div></div></div><div><div class="h5">
<div><br>
</div>
<div>
<div>
<div dir="ltr">What is that Collapsed attribute?</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-02-23 12:59 GMT-03:00 Matt Campbell <span dir="ltr">
<<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>></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>That looks correct, assuming you have key links on your agg table. If you have the collapsed attribute values you can use <CopyLink>.</div>
<div><br>
</div>
<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><span style="font-weight:bold">From: </span><<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
</span><span style="font-weight:bold">Date: </span>Tuesday, February 23, 2016 at 10:31 AM
<div>
<div><br>
<span style="font-weight:bold">To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Aggregation tables and AggPattern<br>
</div>
</div>
</div>
<div>
<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><MeasureGroup table="agg_fat_proc" type="aggregate"></div>
<div><span style="white-space:pre-wrap"></span><Measures></div>
<div><span style="white-space:pre-wrap"></span><MeasureRef aggColumn="amount" name="amount"/></div>
<div><span style="white-space:pre-wrap"></span><MeasureRef aggColumn="price" name="price"/></div>
<div><span style="white-space:pre-wrap"></span><MeasureRef aggColumn="fact_count" name="fact_count"/></div>
<div><span style="white-space:pre-wrap"></span></Measures></div>
<div></MeasureGroup></div>
<div><DimensionLinks></div>
<div><span style="white-space:pre-wrap"></span><ForeignKeyLink dimension="myDimension" foreignKeyColumn="iddimension"/></div>
<div></DimensionLinks></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">
<<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>></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 <Dimensions> tag. You can use the M4 Foodmart schema as an example: <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><span style="font-weight:bold">From: </span><<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><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 <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Mondrian] Aggregation tables and AggPattern<br>
</div>
<div>
<div>
<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><Schema></div>
<div> <Dimension></Dimension></div>
<div> <Cube></div>
<div> <Dimensions></div>
<div> <Dimension source="mydimension"/></div>
<div> </Dimensions></div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-02-23 11:24 GMT-03:00 Matt Campbell <span dir="ltr">
<<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>></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><<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>> on behalf of kevin melo <<a href="mailto:kevinmelo92@gmail.com" target="_blank">kevinmelo92@gmail.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>Mondrian list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><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 <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><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> 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" 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" 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>