Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: hasAll=false

  1. #1
    Join Date
    Nov 2010

    Default hasAll=false

    Can somebody explain the hasAll. When it is best to set it to true?


  2. #2


    From the Documentation:
    3.3.2 The 'all' member

    By default, every hierarchy contains a top level called '(All)', which contains a single member called '(All {hierarchyName})'. This member is parent of all other members of the hierarchy, and thus represents a grand total. It is also the default member of the hierarchy; that is, the member which is used for calculating cell values when the hierarchy is not included on an axis or in the slicer. The allMemberName and allLevelName attributes override the default names of the all level and all member.

    If the <Hierarchy> element has hasAll="false", the 'all' level is suppressed. The default member of that dimension will now be the first member of the first level; for example, in a Time hierarchy, it will be the first year in the hierarchy. Changing the default member can be confusing, so you should generally use hasAll="true".

    The <Hierarchy> element also has a defaultMember attribute, to override the default member of the hierarchy:
    <Dimension name="Time" type="TimeDimension" foreignKey="time_id">
    <Hierarchy hasAll="false" primaryKey="time_id" defaultMember="[Time].[1997].[Q1].[1]"/>
    ps. Forum mods, why does it take approximately a day (not exaggerating) before a forum reply shows up? Does not exactly make for a nice user experience here.
    pps. Hm, this one showed up rather quickly I have to say
    Last edited by dknippers; 10-12-2012 at 09:35 AM.

  3. #3
    Join Date
    Nov 2010


    thanks. I understand this part. But my question is more of: why would someone wants to set hasAll=false if they can use something like [Dim].[All].children? Does it make sense to set hasAll=false for parent-child hierarchy? How come if I set hasAll=false mondrian is executing more sql queries than hasAll=true?

    somebody have tried running descendants([Dim].[Hier]) where Hier is a parent-child hierarchy and hasAll=false? I was never successful to see it work in jpivot, it always give an error.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.