National Geographic POD

Monday, February 23, 2009

Migration of DataForms in Hyperion Planning

The goal of this post is to explain how to migrate data forms from one environment to another in planning applications. The automation of this process helps to reduce time and leaves no scope for human error.

FormDefUtil.cmd utility can be used to move data form definitions from one Planning application to another. Data form definitions can be exported or imported from an XML file. This utility is extremely useful when Data forms need to be moved from a development environment to a production environment.This utility uses a command line interface and is installed in the bin directory (D:Hyperion\Planning\bin). This utility runs only on Windows-based systems (even if application servers are on UNIX). Only administrators can run it. The utility is located on Planning server as shown below.



Steps to export Data Forms :

1. Launch the FormDefUtil.cmd utility from the bin directory using this syntax:

formdefutil export Formname/-all server name user name password application



The utility creates an XML file in D:Hyperion/Planning/bin and logs errors in FormDefUtil.log in the directory from which you run the utility (by default bin). You can copy the utility to any directory and launch it from there to save files to another directory.




Steps to Import Data Forms :

1. Launch the FormDefUtil.cmd utility from the bin directory using this syntax:

formdefutil import Location of Formnames server name user name password application




This completes migration of data forms from one environment to another in planning applications.

3 comments:

  1. Hi Dornakal,
    Can please post the step by step process of installation and configuration of Hyperion planning 9.3

    Thanks,
    Mahesh.

    ReplyDelete
  2. Hi Mahesh,
    good morning.
    sure will do in near future.
    have a great day.

    with best wishes,
    Dornakal.

    ReplyDelete
  3. I have migrated the forms using FormDefUtil.cmd - it failed to migrate all forms in one shot because it had missing members. So I had to load the missing members through workspace and load the forms again and again. It was exhausting exercise but was done.
    Now that the Forms are imported and I can see them but can't open or access them. Please tell me why I can't open them ? or how to open them ?

    ReplyDelete

Salvador Dali Fine Art of the Day