[Mondrian] IgnoreUnrelatedDimensions clarification

[Tom Barber]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150709/5865e9a1/attachment.html