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 Planning is installed, enter this syntax at the Command Prompt:

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

    ParameterDescription
    [-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:usernameThe name of the Planning administrator
    /A:sourceApplicationThe name of the source Planning application from which to push data
    /M:applicationMappingThe name of the application mapping that defines the push data range (see Mapping Applications 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