hierarchy Help

• Smash125

  Hall of Fame

  Points: 3562

  More actions

  October 19, 2012 at 1:58 am

  #143892

  I am trying ti build hierarchy based on FirstName,MiddleName,LastName,ContactID

  My Dimension table contains

  ContactID,EmailAddress,FirstName,LastName,MiddleName,Phone,Title

  My Hierarchy

  FullName - Showing Error in the header saying 'attribute relationship do not exist between one or more levls'

  FirstName

  MiddleName

  LastName

  for each attribute i have changed

  Key Column for middlename

  middlename comes after firstname

  and same with lastname

  firstname,middlename,lastname

  and made the relationship as rigid.

  How to get rid of this error(all errors)

• a4apple

  SSCrazy

  Points: 2620

  More actions

  October 19, 2012 at 1:37 pm

  #1551040

  Smash125 (10/19/2012)

  ---

  I am trying ti build hierarchy based on FirstName,MiddleName,LastName,ContactID

  My Dimension table contains

  ContactID,EmailAddress,FirstName,LastName,MiddleName,Phone,Title

  My Hierarchy

  FullName - Showing Error in the header saying 'attribute relationship do not exist between one or more levls'

  FirstName

  MiddleName

  LastName

  for each attribute i have changed

  Key Column for middlename

  middlename comes after firstname

  and same with lastname

  firstname,middlename,lastname

  and made the relationship as rigid.

  How to get rid of this error(all errors)

  Hi Smash125,

  I had the same issue previously.

  Please go through this video and it will help you figure this out.

  http://www.youtube.com/watch?v=Js4sEkm05ZA

  He used date as example. You can use the same steps for yours. It worked for me.

  Let us know if it worked.

  Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.