The ImportFormDefinition utility is in the planning1 directory. For the full path to planning1, see About EPM Oracle Instance.
To launch ImportFormDefinition:
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
[-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 |
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. | ||
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. | ||
Add columns from the data file (on by default). Disable by specifying /-AC. | ||
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. | ||
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. | ||
Sort rows in the data form (on by default). Disable by specifying /-SR. | ||
Sort columns in the data form (on by default). Disable by specifying /-SC. |
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.
If you disable importing rows or columns, ImportFormDefinition filters imported data by rows or columns defined on the data form.
If you run ImportFormDefinition more than once, it merges new results with the existing data form definition, and, if you also specify sorting, sorts new and existing rows or columns by dimension order.