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
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
