Be careful with the non-collapsed dimensions. This feature needs the tables to be in a snowflake form. If the dimension table is a single table and you join on the non-last level, you will get a cartesian product.<br><br>Luc<br>
<br><div class="gmail_quote">On Mon, Jan 14, 2013 at 12:04 PM, Pedro Alves <span dir="ltr"><<a href="mailto:pmgalves@gmail.com" target="_blank">pmgalves@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
IT IS WORKING!<br>
<br>
<br>
However, I had to skip the first level of a hierarchy, marking the<br>
second level as collapsed= false.. something I've never used before and<br>
seems to be exactly for this :p<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
-pedro<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
<br>
<br>
On 01/14/2013 05:01 PM, Julian Hyde wrote:<br>
> yes, it should be used.<br>
><br>
> furthermore, mondrian knows that it is safe to roll up any attributes that are functionally dependent on the measure column. (e.g. if you have computed count(distinct customer_id), and you have in the agg table the distinct count for male and female customers in each state, you can compute the number of distinct customers in each state by adding the distinct males and females.)<br>
><br>
> Julian<br>
><br>
><br>
> On Jan 14, 2013, at 8:52 AM, Pedro Alves <<a href="mailto:pmgalves@gmail.com">pmgalves@gmail.com</a>> wrote:<br>
><br>
>><br>
>><br>
>> I know we can't aggregate distinct-count measures like we do with the<br>
>> others.<br>
>><br>
>> But if a query matches a specific aggregation table's bitkey,<br>
>> couldn't/shuoldn't it be used?<br>
>><br>
>><br>
>><br>
>> -pedro<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" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><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" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><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" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</div></div></blockquote></div><br>