Hi ,
I want to drill from jobname to it's parent job and to see the parent jobs start/end time.
I have two tables first one has data like this
jobname,description,start_time,end_time
Table1:
LOAD Jobname,
DESCRIPTION,
Start_Time,
End_Time,
FROM
[..\xxx.qvd] (qvd);
All the jobs are in this table (child as well as parent job)
and in the second table we have data like
child_jobname, parent_jobname
Table2:
LOAD Child_JobName as Jobname,
Parent_Jobname
FROM
[..\yyy.qvd](qvd);
I am joining jobname with child_jobname .
Then i am creating hierarchy to get all the related jobname/parent job name
Parent_to_Child:
HierarchyBelongsTo(Jobname,ParentID,Job_description,[ancestor ID],AncestorName)
load
Child_JobName as Jobname ,
Parent_Jobname as ParentID,
Child_JobName as Job_description
FROM
[..\yyy.qvd]
(qvd);
I have gantt chart where i am plotting jobname and its start time and end time. Now i have created a drill down group using Jobname and [ancestor ID]
Now when i drill from jobname to ancestor ID i am not getting ancestor id start time and end time.
I guess the granularity is in the jobname level.
Even if i click ancestor id it is showing job timing of child .
could anyone help me how to make data such a way so that i can drill from child to its parent.
It has one to many relationship means one child job would have many parent jobs.
For security reason , I can't share data .
Thank you,