Is [all] A Level Aswell As A Member

Looking at the diagram for our ClientId hierarchy I see a pattern that is repeated in most hierarchies: If I expand All then every member of that hierarchy is included - is All a

Solution 1:

All, is the parent member of all the members of an attribute whose propertey "IsAggregatable" is set to TRUE.

ALL is also a level that contains the All-member(s).

Depending what you are using the following statements can return a reasonable result or an Error, so I would it is good to know the difference between ALL and All

Dim.hier.[All].children
Dim.hier.[(All)].children
Dim.hier.[(All)].members
Dim.hier.[ALL].children
Dim.hier.[ALL].members

Hope this clarifies some things

Tom