'Re: [Mondrian] IgnoreMeasureForNonJoiningDimension'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: mondrian
Subject: Re: [Mondrian] IgnoreMeasureForNonJoiningDimension
From: Matt Campbell <mkambol () gmail ! com>
Date: 2013-02-25 16:09:25
Message-ID: CAEhiZCRu6PD+nb=nnU64KQtDnVqGz_mf2bkYUC8c1upHTy9cMw () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

I've created MONDRIAN-1457 for the bug I mentioned at the bottom of my last
email.  On Friday I committed a fix to IgnoreMeasureForNonJoiningDimension
tests in 4.0.  I think it will still be worth considering removing the
functionality if no one is using it.  Unlike the similarly named
IgnoreUnrelatedDimensions,
there's no precedent for IgnoreMeasureForNonJoiningDimension in other OLAP
engines, and it seems more likely to cause confusion than anything.

On Thu, Feb 21, 2013 at 6:14 PM, Matt Campbell <mcampbell@pentaho.com>wrote=
:

> This afternoon I started working on a task to fix some failing tests on
> lagunitas involving the  IgnoreMeasureForNonJoiningDimension property
> (MONDRIAN-1437).  Despite having been involved in the original request fo=
r
> this feature, it took me a little while to wrap my head back around the
> functionality.  ****
>
> ** **
>
> Here=92s my memory of the use case that prompted my former employer to pu=
sh
> for this a few years back.  With healthcare data, analysts may want to su=
m
> up claims data that=92s coming from different sources.  For example, [Net
> Payment] is defined as the sum of payments from the Drug Claims cube and
> payments from the Hospital Claims cube.  These two cubes have very simila=
r
> but not identical dimensionality.****
>
> ** **
>
> Our users would create reports with a dimension that joins to one but not
> both of these two cubes, and then be very surprised at the totals.  In th=
e
> example below the [Drug] dimension does not join to the Hosp cube:****
>
> ** **
>
> *Drug *
>
> *Net Payment*
>
> *Net Pay Drug*
>
> *Net Pay Hosp*
>
> FLECAINIDE ACETATE ****
>
> 758.79****
>
> 758.79****
>
> ** **
>
> MAXAIR AUTOHALER ****
>
> 1,689.79****
>
> 1,689.79****
>
> ** **
>
> MENOSTAR ****
>
> 1,482.10****
>
> 1,482.10****
>
> ** **
>
> NITROGLYCERIN ****
>
> 766.60****
>
> 766.60****
>
> ** **
>
> PROVENTIL AEROSOL ****
>
> 609.48****
>
> 609.48****
>
> ** **
>
> *TOTAL*
>
> 11536.24****
>
> 5306.76****
>
> 6229.48****
>
> ** **
>
> Since the total would be defined with [Drug].[All Drug], the [Net Pay
> Hosp] column ends up with an odd looking number, and the [Net Payment]
> column does not seem to add up correctly.  Easy to explain to someone
> versed in MDX, not so easy to explain to the typical analyst.****
>
> ** **
>
> Enter IgnoreMeasureForNonJoiningDimension.  The thought was that we neede=
d
> something essentially the opposite of ValidMeasure or
> IgnoreUnrelatedDimensions.  ValidMeasure forces unrelated dimensions to t=
he
> All level.  We needed something that would cause evaluation to be null ev=
en
> if the unrelated dimension *was* at the All level.  I worked with a
> developer from ThoughtWorks to get this enhancement in and passing cases
> with Cognos generated MDX.****
>
> ****
>
> We used this functionality briefly before hitting enough other border
> cases around totals that we moved to an alternative fix involving more
> complex Cognos report specs. ****
>
> ** **
>
> I=92m curious now whether anyone else is using this functionality.  If yo=
u
> are, it would be good to hear your use cases so we make sure they=92re
> accounted for in 4.x.  If no one is using it, it seems like a potential
> candidate for the chopping block.****
>
> ** **
>
> As I=92ve been poking at it today, I=92ve noticed some things that seem b=
roken
> even in Mondrian 3.x.  For example, with
> IgnoreMeasureForNonJoiningDimension enabled, the following two queries gi=
ve
> different results in 3.x.  The first ignores the measure with the
> non-joining Gender dimension and returns null, the second query returns
> 196,770.888.****
>
> ** **
>
> WITH MEMBER [Measures].[memberArrayValueCalc] as ****
>
>   '( measures.[warehouse sales], [Gender].[All Gender], [Product].[All
> Products] )'****
>
> SELECT ****
>
>    [Measures].[memberArrayValueCalc] on 0 ****
>
> FROM ****
>
>   [warehouse and sales]****
>
> ** **
>
> ** **
>
> SELECT ****
>
>   ([Measures].[warehouse sales], [Gender].[All Gender], [Product].[All
> Products] ) on 0 ****
>
> FROM ****
>
>   [warehouse and sales]****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> _______________________________________________
> Mondrian mailing list
> Mondrian@pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>

[Attachment #5 (text/html)]

<div dir="ltr">I&#39;ve created MONDRIAN-1457 for the bug I mentioned at the bottom \
of my last email. On Friday I committed a fix to IgnoreMeasureForNonJoiningDimension \
tests in 4.0. I think it will still be worth considering removing the functionality \
if no one is using it. Unlike the similarly named IgnoreUnrelatedDimensions, \
there&#39;s no precedent for IgnoreMeasureForNonJoiningDimension in other OLAP engines, and it \
seems more likely to cause confusion than anything.<div>

<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Feb \
21, 2013 at 6:14 PM, Matt Campbell <span dir="ltr">&lt;<a \
href="mailto:mcampbell@pentaho.com" \
target="_blank">mcampbell@pentaho.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div>This afternoon I started working on a task to fix some failing \
tests on lagunitas involving the IgnoreMeasureForNonJoiningDimension property \
(MONDRIAN-1437). Despite having been involved in the original request for this \
feature, it took me a little while to wrap my head back around the functionality. \

Here’s my memory of the \
use case that prompted my former employer to push for this a few years back. With \
healthcare data, analysts may want to sum up claims data that’s coming from different \
sources. For example, [Net Payment] is defined as the sum of payments from the Drug \
Claims cube and payments from the Hospital Claims cube. These two cubes have very \
similar but not identical dimensionality.

Our users would create \
reports with a dimension that joins to one but not both of these two cubes, and then \
be very surprised at the totals. In the example below the [Drug] dimension does not \
join to the Hosp cube:

<p class="MsoNormal"><u></u> <u></u></p><table border="1" cellspacing="3" \
cellpadding="0" width="453" \
style="width:271.5pt;background:white;border-top:none;border-left:none;border-bottom:solid \
#d5d5d5 1.0pt;border-right:solid #d5d5d5 1.0pt">

<tbody><tr><td width="168" style="width:100.95pt;border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#e5e5e5;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal" \
style="line-height:12.0pt;vertical-align:baseline">

<b><span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">Drug \
<u></u><u></u></span></b></p></td><td width="73" style="width:43.8pt;border-top:solid \
#d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt">

<p class="MsoNormal" align="center" \
style="text-align:center;line-height:12.0pt;vertical-align:baseline"><b><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">Net \
Payment<u></u><u></u></span></b></p>

</td><td style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal" align="center" \
style="text-align:center;line-height:12.0pt;vertical-align:baseline">

<b><span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">Net \
Pay Drug<u></u><u></u></span></b></p></td><td style="border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt">

<p class="MsoNormal" align="center" \
style="text-align:center;line-height:12.0pt;vertical-align:baseline"><b><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">Net \
Pay Hosp<u></u><u></u></span></b></p>

</td></tr><tr><td width="168" valign="top" style="width:100.95pt;border-top:solid \
#d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal">

<span style="font-size:9.0pt">FLECAINIDE ACETATE <u></u><u></u></span></p></td><td \
width="73" nowrap style="width:43.8pt;border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">758.79<u></u><u></u></span></p>

</td><td nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p \
class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline">

<span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">758.79<u></u><u></u></span></p></td><td \
nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222"><u></u> \
<u></u></span></p>

</td></tr><tr><td width="168" valign="top" style="width:100.95pt;border-top:solid \
#d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal">

<span style="font-size:9.0pt">MAXAIR AUTOHALER <u></u><u></u></span></p></td><td \
width="73" nowrap style="width:43.8pt;border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">1,689.79<u></u><u></u></span></p>

</td><td nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p \
class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline">

<span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">1,689.79<u></u><u></u></span></p></td><td \
nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222"><u></u> \
<u></u></span></p>

</td></tr><tr><td width="168" valign="top" style="width:100.95pt;border-top:solid \
#d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal">

<span style="font-size:9.0pt">MENOSTAR <u></u><u></u></span></p></td><td width="73" \
nowrap style="width:43.8pt;border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">1,482.10<u></u><u></u></span></p>

</td><td nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p \
class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline">

<span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">1,482.10<u></u><u></u></span></p></td><td \
nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222"><u></u> \
<u></u></span></p>

</td></tr><tr><td width="168" valign="top" style="width:100.95pt;border-top:solid \
#d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal">

<span style="font-size:9.0pt">NITROGLYCERIN <u></u><u></u></span></p></td><td \
width="73" nowrap style="width:43.8pt;border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">766.60<u></u><u></u></span></p>

</td><td nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p \
class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline">

<span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">766.60<u></u><u></u></span></p></td><td \
nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222"><u></u> \
<u></u></span></p>

</td></tr><tr><td width="168" valign="top" style="width:100.95pt;border:solid #d5d5d5 \
1.0pt;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p \
class="MsoNormal"><span style="font-size:9.0pt">PROVENTIL AEROSOL \
<u></u><u></u></span></p>

</td><td width="73" nowrap style="width:43.8pt;border:solid #d5d5d5 \
1.0pt;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p class="MsoNormal" \
align="right" style="text-align:right;line-height:12.0pt;vertical-align:baseline">

<span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">609.48<u></u><u></u></span></p></td><td \
nowrap style="border:solid #d5d5d5 1.0pt;border-right:none;padding:3.0pt 7.5pt 3.0pt \
3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222">609.48<u></u><u></u></span></p>

</td><td nowrap style="border:solid #d5d5d5 1.0pt;border-right:none;padding:3.0pt \
7.5pt 3.0pt 3.75pt"><p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222"><u></u> \
<u></u></span></p>

</td></tr><tr><td width="168" style="width:100.95pt;border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;background:#f9f9f9;padding:3.0pt 7.5pt \
3.0pt 3.75pt"><p class="MsoNormal" \
style="line-height:12.0pt;vertical-align:baseline">

<b><span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222;background:yellow">TOTAL<u></u><u></u></span></b></p></td><td \
width="73" nowrap style="width:43.8pt;border-top:solid #d5d5d5 \
1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222;background:yellow">11536.24<u></u><u></u></span></p>

</td><td nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt"><p \
class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline">

<span style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222;background:yellow">5306.76<u></u><u></u></span></p></td><td \
nowrap style="border-top:solid #d5d5d5 1.0pt;border-left:solid #d5d5d5 \
1.0pt;border-bottom:none;border-right:none;padding:3.0pt 7.5pt 3.0pt 3.75pt">

<p class="MsoNormal" align="right" \
style="text-align:right;line-height:12.0pt;vertical-align:baseline"><span \
style="font-size:8.5pt;font-family:&quot;inherit&quot;,&quot;serif&quot;;color:#222222;background:yellow">6229.48<u></u><u></u></span></p>

</td></tr></tbody></table> Since the total would be defined with [Drug].[All Drug], the [Net \
Pay Hosp] column ends up with an odd looking number, and the [Net Payment] column \
does not seem to add up correctly. Easy to explain to someone versed in MDX, not so \
easy to explain to the typical analyst.

Enter \
IgnoreMeasureForNonJoiningDimension. The thought was that we needed something \
essentially the opposite of ValidMeasure or IgnoreUnrelatedDimensions. ValidMeasure \
forces unrelated dimensions to the All level. We needed something that would cause \
evaluation to be null even if the unrelated dimension was at the All level. I \
worked with a developer from ThoughtWorks to get this enhancement in and passing \
cases with Cognos generated MDX.

We used this \
functionality briefly before hitting enough other border cases around totals that we \
moved to an alternative fix involving more complex Cognos report specs. \

I’m curious now whether \
anyone else is using this functionality. If you are, it would be good to hear your \
use cases so we make sure they’re accounted for in 4.x. If no one is using it, it \
seems like a potential candidate for the chopping block.

As I’ve been poking at \
it today, I’ve noticed some things that seem broken even in Mondrian 3.x. For \
example, with IgnoreMeasureForNonJoiningDimension enabled, the following two queries \
give different results in 3.x. The first ignores the measure with the non-joining \
Gender dimension and returns null, the second query returns \
196,770.888.

<p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas"><u></u> <u></u></span></p><p \
class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas;color:blue">WITH</span><span \
style="font-size:9.5pt;font-family:Consolas"> <span style="color:blue">MEMBER</span> \
[Measures].[memberArrayValueCalc] <span style="color:blue">as</span> \
<u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas">  <span style="color:#a31515">&#39;( \
measures.[warehouse sales], [Gender].[All Gender], [Product].[All Products] \
)&#39;</span><u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas;color:blue">SELECT</span><span \
style="font-size:9.5pt;font-family:Consolas"> <u></u><u></u></span></p><p \
class="MsoNormal" style="margin-left:.5in;text-autospace:none">

<span style="font-size:9.5pt;font-family:Consolas">   \
[Measures].[memberArrayValueCalc] <span style="color:blue">on</span> 0 \
<u></u><u></u></span></p><p class="MsoNormal" \
style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas;color:blue">FROM</span><span \
style="font-size:9.5pt;font-family:Consolas"> <u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas">  [warehouse and \
sales]<u></u><u></u></span></p><p class="MsoNormal" \
style="margin-left:.5in;text-autospace:none">

<span style="font-size:9.5pt;font-family:Consolas"><u></u> <u></u></span></p><p \
class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><p class="MsoNormal" \
style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas;color:blue">SELECT</span><span \
style="font-size:9.5pt;font-family:Consolas"> <u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas">  ([Measures].[warehouse sales], \
[Gender].[All Gender], [Product].[All Products] ) <span style="color:blue">on</span> \
0 <u></u><u></u></span></p>

<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span \
style="font-size:9.5pt;font-family:Consolas;color:blue">FROM</span><span \
style="font-size:9.5pt;font-family:Consolas"> <u></u><u></u></span></p><p \
class="MsoNormal" style="margin-left:.5in;text-autospace:none">

<span style="font-size:9.5pt;font-family:Consolas">  [warehouse and \
sales]<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p><p \
class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p \
class="MsoNormal">

<u></u> <u></u></p><p class="MsoNormal"><u></u> \
<u></u></p></div></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" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> \
<br></blockquote></div><br></div>

_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian

[prev in list] [next in list] [prev in thread] [next in thread] 