Exporting and Importing Hyperion Planning Data Forms
Hyperion Planning has FormDefUtil.cmd to export and import dataforms.
The default path for version 11.1.1 is onC:\Hyperion\products\Planning\bin
Only Admin can have rights to do export and import
The default path for version 11.1.1 is onC:\Hyperion\products\Planning\bin
Only Admin can have rights to do export and import
Step 1: open the command prompt
Cmd
Cmd
Step 2: Default path is C:\Hyperion\products\Planning\bin
Set that path C:\Hyperion\products\Planning\bin press enter
Set that path C:\Hyperion\products\Planning\bin press enter
Step 3: Export the data form from the application (This will export all the data forms)
The correct syntax for exporting the data form is:
The correct syntax for exporting the data form is:
Case sensitive, make sure that use F,D and U are capital letters
FormDefUtil.cmd export -all king admin Sample
FormDefUtil.cmd export -all king admin Sample
here King is my server name, admin is my user name and Sample is application name
FormDefUtil.cmd export -all servername username application name
Step 4: It will ask for the password
Enter u r password
Step 5: If it is successful, will display below message
[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
C:\Hyperion\common\config\9.5.0.0\product\planning\9.5.0.0\planning_1.xml
displayName = Planning
componentTypes =
[INFO] RegistryLogger – REGISTRY LOG INITIALIZED
C:\Hyperion\common\config\9.5.0.0\product\planning\9.5.0.0\planning_1.xml
displayName = Planning
componentTypes =
priority = 50
version = 9.5.0.0
build = 1
location = C:\Hyperion\products\Planning
taskSequence =
version = 9.5.0.0
build = 1
location = C:\Hyperion\products\Planning
taskSequence =
task =
using Java property for Hyperion Home C:\Hyperion
Setting Arbor path to: C:\Hyperion\common\EssbaseRTC\9.5.0.0
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Entering A
udit Client http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Initializi
ng Manager for the serverhttp://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.manager.AuditContext – Creating N
ew Audit Client Instance …. http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Audit Clie
nt has been created for the serverhttp://paolynl.misnet.com.ph:28080/interop/Au
dit
Form exported complete.
Form exported complete.
Form exported complete.
No composite form found.
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime– Writi
ng Audit Records for migrated Artifacts …
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime– Store
d Audited Data Successfully !!!
Setting Arbor path to: C:\Hyperion\common\EssbaseRTC\9.5.0.0
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Entering A
udit Client http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Initializi
ng Manager for the serverhttp://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.manager.AuditContext – Creating N
ew Audit Client Instance …. http://paolynl.misnet.com.ph:28080/interop/Audit
d{ISO8601} INFO main com.hyperion.audit.client.runtime.AuditRuntime – Audit Clie
nt has been created for the serverhttp://paolynl.misnet.com.ph:28080/interop/Au
dit
Form exported complete.
Form exported complete.
Form exported complete.
No composite form found.
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime– Writi
ng Audit Records for migrated Artifacts …
d{ISO8601} INFO Thread-14 com.hyperion.audit.client.runtime.AuditRuntime– Store
d Audited Data Successfully !!!
Step 6: check the data forms in xml file in the following location:
C:\Hyperion\products\Planning\bin
C:\Hyperion\products\Planning\bin
Step 7: To import to the application the following command is the same:
FormDefUtil.cmd import -all localhost admin Sample
Instead of export , we use import
Step 8:Finally check the application.
Please find some more information on export and import data forms
If you want to export all the forms that you have you can type in
FormDefUtil export –all server username application (FormDefUtil export -all localhost admin sampleapp)
If you want to export only one form, you can type in
FormDefUtil export FormName server username application (FormDefUtil export retirement localhost admin sampleapp)
The above export command creates an XML file that you can import in a different environment.
In order to import form in the target planning app, you can type in
FormDefUtil import –all server username application (FormDefUtil import -all localhost admin sampleapp)
SOME MORE
All forms within an application:
FormdefUtil.cmd export -all localhost khoonks (username here) normal (application name here)
it will ask for password
One form that you want to export:
For example, if you want to export a form named "Other Expenses" from the "normal" application, the syntax would be
FormdefUtil.cmd export "Other Expenses" localhost khoonks normal
It will ask for password.
After the execution of the script, the output fill will be seen in the Planning1 folder > D:\oracle\Middleware\user_projects\epmsystem1\Planning\planning1.
Output is an XML file and it is something like "Other Expenses - Capital.xml"
SOME MORE
All forms within an application:
FormdefUtil.cmd export -all localhost khoonks (username here) normal (application name here)
it will ask for password
One form that you want to export:
For example, if you want to export a form named "Other Expenses" from the "normal" application, the syntax would be
FormdefUtil.cmd export "Other Expenses" localhost khoonks normal
It will ask for password.
After the execution of the script, the output fill will be seen in the Planning1 folder > D:\oracle\Middleware\user_projects\epmsystem1\Planning\planning1.
Output is an XML file and it is something like "Other Expenses - Capital.xml"
In order to import only one app, you can type in
FormDefUtil import filenamepluslocationoffile server username application (FormDefUtil import formname.xml localhost admin sampleapp)
After you run the command, if it asks for the password, type in the password and wait for it to run.
Regards,
Kotireddy
