Help Require to resolve the hierarchy problem

vikasmahajan — Mon, 21 Jul 2014 07:58:15 GMT

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

topic Help Require to resolve the hierarchy problem in QlikView

Help Require to resolve the hierarchy problem