Importing Data Form Definitions

The ImportFormDefinition utility is in the planning1 directory. For the full path to planning1, see About EPM Oracle Instance.

  To launch ImportFormDefinition:

  1. From the planning1 directory, enter the command using this syntax:

    ImportFormDefinition [-f:passwordFile] /A:appname /U:username /F:formname /D:filename [/AR] [/AC] [/SR] [/SC] [/KC] [/KR]

    Table 51. ImportFormDefinition Utility Parameters

    Setting

    Purpose

    Required?

    [-f:passwordFile]

    If an encrypted password file is set up, you can use this option as the first parameter in the command line to run the utility with the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.

    No

    /A

    Application name.

    Yes

    /U

    Administrator user name.

    Yes

    /F

    Data form name.

    Yes

    /D

    Name and location of the Essbase Column Export Format data file. The location can be the full path and file name, or any format required for the operating system to find the file.

    Yes

    /AR

    Add rows from the data file (on by default). Disable by specifying /-AR. For example, you can define rows in Planning and import only column definitions.

    No

    /AC

    Add columns from the data file (on by default). Disable by specifying /-AC.

    No

    /KC

    Keep member selections for columns in the data form (on by default). Clear columns by specifying /-KC. Data forms must have at least one column definition. If you clear columns but do not add them, the data form is not saved, and an error displays.

    No

    /KR

    Keep member selections for rows in the data form (on by default). Clear member selections in rows by specifying /-KR. Data forms must have at least one row definition. If you clear rows but do not add them, the data form is not saved, and an error displays.

    No

    /SR

    Sort rows in the data form (on by default). Disable by specifying /-SR.

    No

    /SC

    Sort columns in the data form (on by default). Disable by specifying /-SC.

    No

  2. If prompted, enter your password.

For example:

ImportFormDefinition /A:MyPlan /U:Admin /F: "My Budget" /D:exportfilename /AR /-AC

Creating the data form can take some time, depending on the amount of data in the file.

ImportFormDefinition imports the definition to the Planning data form, ensuring that all cells having data in the data file are represented on the data form. For cells in the data file that contain “#MISSING,” rows or columns are not added to the data form.

Notes: