[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