Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Duplicate hierarchy entrys on Lower Childs as Pare

Author  Topic  Digital Starting Member 8 Posts Posted - 2009-04-07 : 06:41:33 Hi all I know the title is a little strange but i'll explain i have a Dimesion displaying varibles of ¦¦Country¦¦City¦¦Venue Type¦¦Owner¦¦Site¦¦ my first hierarcy is the full list ¦¦Country¦¦>City¦¦>Venue Type¦¦>Owner¦¦>Site¦¦ i have set up all the relationships correctly adding the key columns to what make it level uniqu and have setup where the ridgid relationships are my second hierarcy start like this ¦¦Venue Type¦¦>Owner¦¦>Site¦¦ Basically i get something that look like this Airport Airport Airport Hotel Hotel Entertainment Entertainment which i believe is showing all the ¦¦City¦¦ Venue types i know the realation has to be there for the first hierarchy BUT now the Venue Type has become the Parent in the Second hierarcy how do i stop the duplication and have Venue type as parent?? Digital