To all

Is there a quick way to tell a the highest number of children for any member
in a dimension without iterating through each member?

Thanks in advance

Howard.Taylor@ domain below
www.o2olap.com
Microsoft Certified Partner

It depends on what you mean by iterating, as many MDX functions cause
iteration under the covers. It's doable in MDX, sans procedural code, if
that's what you mean.

When looking for max children, is that throughout all levels, or just a
given level? Do you want to know the number of children and/or the parent
member?

public @ the domain below
www.tomchester.net

"Howard Taylor [O2OLAP]" <Remove.Howard.Taylor (AT) o2olap (DOT) com> wrote

Tom

Thanks for the reply. I need to know the highest number of children for a
dimension, i.e. if you had a 100 members and one of them had 20 children and
the others less than 20, I need to get the number 20 without iterating
through each of the members.

Thanks
Howard.Taylor@ domain below
www.o2olap.com
Microsoft Certified Partner

"Tom Chester" <nospam_public (AT) tomchester (DOT) net> wrote

Why not update a calc measure or a property in the parent via a DTS package
when the cube is built?

Steve

"Howard Taylor [O2OLAP]" <Remove.Howard.Taylor (AT) o2olap (DOT) com> wrote

Steve

This would not be appropriate for some generic functionality, but thanks for
the response.

Howard

"Steve Smith" <steve.smith (AT) nowhere (DOT) co.uk> wrote