Display Names of Geo Levels in Hirarchy

[vikasmahajan]

Dear All,

I Have problem with hirarchy following is script in my qvw  I want to display employee names along with HQ is linked I made changes in sql script and brig employee names in front of Head Qtrs  and in load I have added employee name but employee names showing me as blank.

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,

     [EmpName],   <-------------------------------------[ Added New Column in Hirerchy]

     [Email]

FROM

[..\Qvds\DIM_GeoHQMaster.qvd]

(qvd);

How to link  employee - SGID+HQID  is link between both tables.

Thanks

Vikas