[Mondrian] IgnoreUnrelatedDimensions clarification

Tom Barber tom at analytical-labs.com
Thu Jul 9 15:24:32 EDT 2015


Thanks Matt

I'd forgotten about ValidMeasure, and that indeed does make it work.

Regards,

Tom

On 9 July 2015 at 19:03, Matt Campbell <mcampbell at pentaho.com> wrote:

>
>
> ignoreUnrelatedDimensions is still not completely reliable—wrapping
> measures in ValidMeasure is the safer option.  It was put in as an
> experimental feature but never fully solidified.  I’d love to see it
> completed.  SSAS treats that (sensibly) as the default behavior.
>
>
>
>
>
>
>
> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> *On Behalf Of *Tom Barber
> *Sent:* Thursday, July 09, 2015 9:00 AM
> *To:* Mondrian developer mailing list
> *Subject:* [Mondrian] IgnoreUnrelatedDimensions clarification
>
>
>
> Hi guys
>
>
>
> This might be me, it might be a bug in M4 but I thought i'd check first.
>
>
>
> I have a question from a user about ignoreUnrelatedDimension=true on
> measure groups so I played around with it and wasn't sure what the expected
> outcome is.
>
>
>
> 2 Fact tables(fact_1, fact_2) each have 1 measure, 6 Dimensions 1-6 all
> join on Fact 1 but only 1-3 join on Fact 2.
>
>
>
> As expected you put dim 1 on rows and dim 2 on columns and measure 1 and
> measure 2 on an axis and you get a nice crosstab, if I put Dim 4 on instead
> of one of the dims, measure 2 vanishes.
>
>
>
>
>
> https://dl.dropboxusercontent.com/u/8503756/mondrian/ex1.png
>
> https://dl.dropboxusercontent.com/u/8503756/mondrian/ex2.png
>
>
>
> But if I put All from Dim 4 on an Axis I get the rollup, I assume because
> of ignoreunrelateddimensions.
>
>
>
> https://dl.dropboxusercontent.com/u/8503756/mondrian/ex3.png
>
>
>
> So with Ignore Unrelated don't you get the rolled up All value if you put
> a level on the axis?
>
>
>
> Cheers
>
>
>
> Tom
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150709/7afe9e9b/attachment-0001.html 


More information about the Mondrian mailing list