Hi,

If I have the following tree:

Root has children 'A' and 'B'. 'A' has children 'aa' and 'bb'. And
'B' has children 'cc' and 'dd'. And 'aa' has children 'x', 'y', and
'z'.

Now, what I need to do is get the number of descendants of any one of
these nodes in the tree at only one level below. For example, 'aa'
has 3 descendants, where as the root and 'A' has 2 each.

I have to code this using MDX in an OLAP Cube. It seems that
Descendants in MDX is always an absolute term, not relative to where
you are in the tree.

Any help would be much appreciated.

Thanks.

Hichem

hichem.fadali (AT) td (DOT) com (Hichem) wrote in
news:ede1900e.0411072012.6e9fcdc6 (AT) posting (DOT) google.com:

<Snip>
Doesn't using the distance flag of 1 give you what you need, i.e.
Count(Descendants([Your Dimension].[Your Member], 1)) ?

HTH,
Koan

Hi,

But I thought if I used Count(Descendants([Your Dimension].[Your
Member], 1)), it's an absolute value and not relative to where I am in
the tree. For example, I thought that it would return the descendants
of the root, and not of where I am.
If my thinking is incorrect, then it's easy.

Thanks.

Hichem

Koan B <koanb (AT) newsgroups (DOT) nospam> wrote

If you only need the number of immediate descendanst of a member node,
then (MyMember).Children.Count should work. More generally,
Descendants() also has a distance option.

From SQL Server BOL>>
Descendants

Returns the set of descendants of a member at a specified level or
distance, optionally including or excluding descendants in other levels.

Syntax

Level
Descendants(«Member», [«Level»[, «Desc_flags»]])

...

Distance
Descendants(«Member», «Distance»[, «Desc_flags»])

Returns the descendants of a member, specified by «Member», that are
«Distance» steps away in the hierarchy, optionally modified by a flag
specified in «Desc_flags». This syntax is typically used to deal with
ragged hierarchies. Specifying a «Distance» of 0 returns a set
consisting only of the member specified in «Member».
...
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!