Thursday, 13 February 2014

Exporting Planning Metadata Using Outline Load Utility

The utility is available on the machine where planning has been deployed in the folder


Extract Standard Dimension

Outlineload /A:application /U:username /D:DimensionToExtract /E:outputFilename

OutlineLoad /A:Sample /U:admin /D:Account /E:F:/SampleExports/acc_export.csv

Output (Extracted File):

Suppressing Password Prompts in Planning Utilities

When running Planning utilities that prompt for passwords, administrators can use an option to suppress password prompts, for example, when running utilities in batch mode. To enable suppressing password prompts, use the PasswordEncryption utility to create a file that stores a password in encrypted form. After the file is set up, you can run Planning utilities with the [-f:passwordFile] option as the first parameter in the command line to skip the password prompt and use the password from the encrypted file. Each password file contains one password, and is stored in the location that you specify when running the utility.

The PasswordEncryption utility uses a command line interface. By default, the utility is installed in <MIDDLEWARE_HOME>\user_projects\epmsystem1\Planning\planning1\

To enable suppressing password prompts in Planning utilities:

1. Enter this command from the planning1 directory, where passwordFile is the full file path and file name for the password file:

    • Windows: PasswordEncryption.cmd passwordFile
    • UNIX: passwordFile

2. When prompted, enter your password.

The masked password is encrypted and stored in the file and location specified in passwordFile. For other Planning utilities with password prompts, you can use [-f:passwordFile] as the first parameter in the command line to skip the prompt and use the encrypted password from the password file specified in PasswordFile.

Extract Attribute Dimension

Using  /D: parameter, can extract the  attribute dimension

Extracted File Output Format (Member Name/Parent/Alias):

Extract Smart List Metadata

Using /DS:HSP_SMARTLISTS parameter, can extract the Smart Lists

Output (Extracted File):
Add caption
Extract Exchange Rates Tables

Using /DX:HSP_RATES parameter, can extract the Exchange Rates Tables 

Output (Extracted File):


We can also export the PlanningUnit Hierarchies using /D:PlanningUnitHierName parameter

1 comment:

  1. Great thanks John Goodwin. Because of your blog, am learning new things in Hyperion. All credits related to this post is belongs to you.