[Mondrian] IgnoreUnrelatedDimensions clarification

Matt Campbell mcampbell at pentaho.com
Thu Jul 9 14:03:45 EDT 2015

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.


But if I put All from Dim 4 on an Axis I get the rollup, I assume because of ignoreunrelateddimensions.


So with Ignore Unrelated don't you get the rolled up All value if you put a level on the axis?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150709/e80d612e/attachment.html 

More information about the Mondrian mailing list