Background:
Users need to copy the data from the PSBP (Oracle Hyperion Public Sector Planning and Budgeting) manpower
cube to the Opex cube (operating expense), since this is on 11.1.2.3.500 the Mapping
Planning Applications to Reporting Applications is available already to do the job.
The Catch is there is no individual role available (atleast
in 11.1.2.3 500) for running the utility. And giving admin access to run this
utility was not a solution.
We need to have a job which can invoke the Pushdata utility
and we can give access to a user to access only that job, similar to a FR
report or a IR job (yes I am from the IR background J)
Issue:
The solution came to the mind is using publishing a batch file which will call the Pushdata.sh in Workspace so we can provision the job to the required
user.
The Challenge was our
Foundation & Planning were installed on Linux and the Reporting & Analysis was installed in
Windows (this is a different story why it was done this way)
So need to have a perl script to login to the Linux machine
from the windows and then need to call the PushData.sh
Solution:
We installed the strawberry
perl as the perl which comes with EPM do lack some SSH packages needed for
the remote login.
Batch file published to Workspace which calls the below script
