Hello People!
I was wondering if anyone had tried to run a Hyperion report or job from a DataStage job or Sequencer. DataStage and Hyperion are installed on two separate Windows servers.
Sorry if I left out important details, I have never tried it before and have no idea how to go about it.
Thanks for your help.
Ken
Can a Hyperion / Essbase job be launched from DataStage?
Moderators: chulett, rschirm, roy
Can a Hyperion / Essbase job be launched from DataStage?
Regards - Ken Breetz
Keep me in the circle of trust
Keep me in the circle of trust
Anything you can script, DataStage can 'launch'. Two primary ways: from a Sequence job the Execute Command stage would do the trick, or it could be done before/after a Server job using ExecDOS or ExecSH.
Curious though, what role would DataStage play here? Other than the launcher, that is?
Curious though, what role would DataStage play here? Other than the launcher, that is?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Chulett,
Thanks for the idea! I forgot about ExecDOS. I could string a BAT file together to do the work and launch it from a job.
For this particular task, the role of DataStage would just be a scheduler or launcher. We use Cybermation to run all our Sequencers. So our Business Analysts want DataStage to run their Hyperion reports that will have dependencies on certain DataStage jobs.
Your next question would then be, why can't you just use Cybermation to run Hyperion reports? Good question! I will ask to see if this a possibility.
Ken
Thanks for the idea! I forgot about ExecDOS. I could string a BAT file together to do the work and launch it from a job.
For this particular task, the role of DataStage would just be a scheduler or launcher. We use Cybermation to run all our Sequencers. So our Business Analysts want DataStage to run their Hyperion reports that will have dependencies on certain DataStage jobs.
Your next question would then be, why can't you just use Cybermation to run Hyperion reports? Good question! I will ask to see if this a possibility.
Ken
Regards - Ken Breetz
Keep me in the circle of trust
Keep me in the circle of trust