Help Require to resolve the hierarchy problem

[vikasmahajan]

Dear all

I have following script  for creating hierarchy parent child wise now I require empname to be display along with level names so make changes in sql script and bring empname  , now when I load this data empname are visible , But when I select Sales Group this is disable shown in gray not linked  please see attached jpg file also attaching the sql script 

Qv Script

DIM_GeoHQMaster:

HIERARCHY(CHILD_ID, PARENT_ID, [HQ], [Parent Name], [HQ], [Path Name], '/')

LOAD Hqid AS [HQ Code],

     Hqname AS [HQ],

     GeoLevelName AS [Level Name],

     CHILD_ID,

     PARENT_ID,

     GeoCount ,

     Rmcount,

     [EmpName],

     [Email]

FROM

[..\Qvds\DIM_GeoHQMaster.qvd]

(qvd);

Sql Script

UPDATE a  

SET a.EmpName = b.EmpName  FROM DIM_QV_GeoHQMaster a

INNER JOIN  [100.0.7.22].[SIM_BI].[dbo].[SIM_MKTEMP_MAST] b

  on a.Hqid =b.EmpArea  and  a.Sgid = b.EmpSgid

  WHERE a.Sgid = b.EmpSgid  and a.Hqid = b.EmpArea

But still i am not able to get employee names' please help me to resolve the same.

Regards

Vikas