Generate dynamic reports with hyperlinks?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
StefL
Participant
Posts: 47
Joined: Fri Feb 25, 2005 3:55 am
Location: Stockholm
Contact:

Generate dynamic reports with hyperlinks?

Post by StefL »

I've downloaded the JobReport routine from ADN and it seems to work fine. I'm just somewhat curious to how it differs from the standard 'generate html report' functionality that already exists in Designer? There's not that much difference from what I can tell, apart from that a bitmap picture of the job design is not automatically generated by JobReport.

What I'd like to know is if there's any functionality that automatically generates reports for say a Server Job called from within a Job Sequence when you generate a report for the sequence, and then includes a hyperlink to the job's report where the job is referenced in the sequence report. That way you'd be able to browse all sequences and jobs called from within a sequence and access information on the level you desire.
That would truly make the documentation useful and complete, and it's a functionality I'd very much like to have. Manually editing all sequencer reports to add links doesn't seem like a feasible way to accomplish this even if it's of course 'possible'.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
with version 7.5 (I'm not sure prior versions have it) you can generate a client side html report of any job containing the graphical job design.
this can also be built via commad line invocation.

some utilities on ADN are implemented in releases over time, usually when they are posted the current version doesn't provide that functionality.

(900 Mark)

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
StefL
Participant
Posts: 47
Joined: Fri Feb 25, 2005 3:55 am
Location: Stockholm
Contact:

Post by StefL »

Yes, I've realised that much. That is, I've found and used the 'generate html report' button in Designer, which generates an html report including a bitmap picture of the job or sequence design.

What I'd like to accomplish though is that if I create a report for a sequence, I'd like it to have hyperlinks for jobs called, hyperlinks that in turn open a similar report for the job.
I can of course generate all the reports and then manually update the sequence report with hyperlinks to the jobs - but for a large project it would be easier if that function could be automated.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

KgdGenHtml does exactly that. Run KgdGenHtmlJobDocs and set CategoryToDoc to the sequence name you want to document. It will build an index page and link to all the job pages produced by JobReport.

Here is an example http://www.duke-consulting.com/KimD/Kgd ... Index.html I used this to document itself. Here is another example http://www.duke-consulting.com/KimD/Etl ... Index.html when I used to document EtlStats.
Mamu Kim
Post Reply