HI guys

I am using SQL AS 2000

In cube editor, I created a calculated member and used the parent
member setting so that I could put the calculated member in a specific
place in the dimension. All worked well.

My question:

I can do the same thing from MDX script using CREATE MEMBER statement.
However I can't find the syntax for specifying the PARENT MEMBER
anywhere.

Does anyone know how to do it, or if it is impossible?

Do i have to use DSO ?


Cheers,
Tim

If my memory is good....

the create member under a specific parent, the syntax should be:
create member <dimension>.<parent member key>.<new member>

create member <dimension>.<new member> will create the member under the "All
member"

<girtbysea (AT) gmail (DOT) com> wrote