[Mondrian] Question about the hasAll in Dimension
Julian Hyde
jhyde at pentaho.com
Tue Feb 24 20:44:05 EST 2009
I don't see the problem. That query should not return 'all' members of
[Warehouse] or [Product] dimensions because it is phrased to use
<Level>.Members not <Hierarchy>.Members. I tried it, and it doesn't return
any 'all' members.
I get:
Salem <outbind://184/mondrian/jpivot/table/drill-position-other.gif> High
Quality Frying Pan 253.0
Salem <outbind://184/mondrian/jpivot/table/drill-position-other.gif> Lake
Turkey Hot Dogs 250.0
Los Angeles <outbind://184/mondrian/jpivot/table/drill-position-other.gif>
High Top Fancy Plums 232.0
Spokane <outbind://184/mondrian/jpivot/table/drill-position-other.gif>
American Beef Bologna 225.0
Tacoma <outbind://184/mondrian/jpivot/table/drill-position-other.gif>
Sunset 75 Watt Lightbulb 238.0
Tacoma <outbind://184/mondrian/jpivot/table/drill-position-other.gif>
Fantastic Muffins 233.0
Tacoma <outbind://184/mondrian/jpivot/table/drill-position-other.gif>
American Pimento Loaf 233.0
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Alston Wong
Sent: Tuesday, February 24, 2009 1:31 PM
To: mondrian at pentaho.org
Subject: [Mondrian] Question about the hasAll in Dimension
Hi All,
I am new to mondrian. I just have a simple question that how to set
HasAll=false temporary assume that all the dimension hasAll="true" but i
don't want to have [All] in the result for the specific mdx request.
Following is the MDX i would like to run:
SELECT
{[Measures]. [Units Shipped]} ON COLUMNS,
TopCount (
Generate ( [Warehouse].[City].Members,
TopCount ( CrossJoin ({ [Warehouse].CurrentMember},
[Product].[Product Name].Members
), 7, [Measures].[Units Shipped]
)
), 7, [Measures].[Units Shipped]
) ON ROWS
FROM Warehouse
Since all my dimension hasAll="true", so this top 7 will included all the
subrequest [All] on the sublevel and the number of [All] will be depended on
how may city i have.
Is there any way to hasAll or filter out all the [All] members result?
Thank you,
Alston
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090224/50ce470f/attachment.html
More information about the Mondrian
mailing list