Pushing Data with a Utility

Pushing data to a reporting application can take some time, so administrators may want to schedule the data push during non-peak hours using the PushData utility. The utility is installed in the planning1 directory. For the full path to planning1, see About EPM Oracle Instance.

To launch the PushData utility:

  1. From the planning1 directory on the server where Oracle Hyperion Planning is installed, enter this syntax at the Command Prompt:

    PushData [-f:passwordFile] /U:username /A:sourceApplication /M:applicationMapping [/C]

    Parameter Description
    [-f:passwordFile]

    Optional: If an encrypted password file is set up, use as the first parameter in the command line to read the password from the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.

    /U:username The name of the Planning administrator
    /A:sourceApplication The name of the source Planning application from which to push data
    /M:applicationMapping The name of the application mapping that defines the push data range (see Mapping an Application for Reporting)
    [/C] Optional: Clears the data range in the target reporting application before pushing data
  2. If you are prompted, enter the password.

Note:

You can check the Job Console for the execution status. You can also view the results in the PushData log in the Planning logs directory. For the full path, see About EPM Oracle Instance.

Examples:

PushData /U:admin /A:plnapp /M:LineItemsToExpenses /C

PushData -f: password.txt /U:admin /A:plnapp /M:LineItemsToExpenses /C

PushData /U:admin /A:plnapp /M:LineItemsToExpenses