i have a dimension named 'sdoc' which has 2 members
1) symptom word( first hierarchical level) and
2) doc id (second hierarchical level)

more than one 'symptom word' can have the same 'doc id'.
i want to know which all symptom words have a particular doc id (say 10.)
if i give [10].parent then it returns only the first parent whereas it
actually has more than one parent.
how to retrieve all the parents.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200605/1

You don't mention which version of AS you are using, but I get the
feeling that you are using AS 2000 as I feel that it's join semantics
make this sort scenario slightly easier to get working as you don't need
to understand the specifics of configuring a many to many dimension.

Technically I think you probably have many doc id members with the same
name rather than 1 member with many parents. (any given member can only
have one parent)

If you reference a member by just it's name (as in [10]) AS will return
the first member (from any dimension) which has that name.

The MDX to find all the parent members for a set of doc ids with the
same name would look something like the following:


GENERATE(FILTER(sdoc.[doc id].members,sdoc.CurrentMember.Name = "10") ,
{sdoc.CurrentMember.parent})


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <60792e6ed0fb0@uwe>, u21556@uwe says...