I would like to get the children of a member, but exclude one or more
children, is that a simple MDX query?

[Dimension].[Member].Chilren - [Dimension].[ExclusionMember]

or something like that?

Thanks again for all the help!

Derrick

You can use the Except function, or simply do set subtraction...

{ MyDim.Members - {MyDim.[X]} }

public @ the domain below
www.tomchester.net


"Derrick" <derrick1298 (AT) excite (DOT) com> wrote

Derrick

The questions you have been asking on the forum remind me of another OLAP
product I started selling in 1991, but dropped when MS AS Beta 2000 came
out. I guess that is also how you know others on this forum whose OLAP
company took on the technology in +-1996. If you would like to see what is
possible through a Webex demo then please feel free to call me. There are
no obligations.

Howard.Taylor@ domain below
www.o2olap.com
+44 20 8785 4811

"Derrick" <derrick1298 (AT) excite (DOT) com> wrote