0 Replies Latest reply: Feb 1, 2011 9:44 PM by 836134 RSS

    Dimension Hierarchy Problem

    836134
      I have a table which has 2 columns as Req ID , Parent ID.These are raw tables.Now the values in Req ID are:
      Req1
      Req1.1
      Req1.2
      Req1.1.1
      Req1.1.1.1

      These are the values in the column of Req ID.And the values in Parent id will determine the parent of one requirement ID.
      Now i want to create a dimension hierarchy where i can drill from Req1 -> Req 1.1 ->Req1.1.1->Req1.1.1.1
      Req1.2

      This should be till 6 levels.Please suggest how it can be done ?

      Edited by: 833131 on Feb 1, 2011 7:44 PM