Migrating Data Maps between PBCS/EPBCS instances

Migrating Data Maps between PBCS/EPBCS instances

This is applicable only for the data maps created by the Admins/Users, Not for the system created ones like the following 

For the Custom-created Data Maps, you can migrate using LCM

Navigate to the Tools 

 

Under Migration, Go to the Core 

Invoking PushData.sh as ad-hoc or scheduled job from Hyperion Workspace

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