Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unhappy Unanswered: retrieving parent(ascendants)

    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.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by sherin
    more than one 'symptom word' can have the same 'doc id'.
    So....there is a one-to-many relationship between 'doc id' and 'symptom word'?
    Quote Originally Posted by sherin
    if i give [10].parent then it returns only the first parent whereas it actually has more than one parent.
    So....there is a one-to-many relationship between 'symptom word' and 'doc id'?

    Huh?

    In database relationships, records normally have only one parent....

    Please post the DDL code for the tables you are referencing, along with the SQL code you have tried.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •