Planning Utility’s in Hyperion Plannings

Planning Utility’s

When you installed planning software then you will get some of the planning utilities along with the product and those are available in the following path:

C:/Hyperion/Planning/bin

We use the Cube refresh utility to refresh the cube from the command-line interface. Use the following syntax:

Cube refresh/A: application name /U: username

[/P: password][/C|/R][/D][/F[S|V]]

We use the Form default command to Export out the data forms from one server to a local file system with .xml Extension and then import these form definitions into another planning server. We use this utility to migrate the forms from development to production server.

Following is the syntax:

FormDefUtil<import/export><filename/formname/-all>

<server><username><password><application>

Export Security utility will be used to export the existing Dimension access from the planning application to a flat-file. This utility is useful to back up the existing Dimension access and can be reused in case of an application crash using import security using this following syntax.

[importsecurity.cmd “ app name, user, password,<delimiter

(sl_cdma/sl_spae/sl_semmicolon)>,<sl_clearall>”]

Export security / A=appname,/U=username,/p=password,[/S=searchcriteria] |[/S_User=user];[/S_Group][/S_Member=mem] [/To_File=Filename]

ImportSecurity.cmd “app.name,user,password,<delimiter

(SL_CDMA/SL_SPACE/SL_COLON/SL_SEMICOLON)>,(SL_CLEARALL)>”

Note:- Import Security command expects all the dimensional access information is available in a file called secfile.txt    

Alias Tables

Alias Tables are used to maintain the different names for a description for planning Dimension members. By default, we get One Alias table and we can create Nine (9) more Alias tables

Steps:-

• Open the planning application
• Click on Administration
• Click on Alias Tables
• Click on Add
• Enter the Name for Alias tables
• Click on OK
• Open any Dimension members
• Click on Edit
• Click on Dropdown list for Alias, there select the table that you have created just now, enter the appropriate alias name
• Click on Save

Now before UAT starts we have to train the End Users to set up the Alias table that is appropriate to his department using the following steps.

• Click on File
• Click on Preferences
• Click on Planning’
• Click on the Application’s settings tab
• Under the Alias setting, Click on the Dropdown list for your Alias table
• Select the one and click on OK

Note:- To view the Alias names in a Data form, open the data form in Edit mode there select the Dimensions on row/column. Then click on an icon called dimension properties go-head and click on an icon called dimension called properties and by default, the display has been enabled for only member name. Select the checkbox for member Alias. Clicks submit and save.

Inclined to build a profession as Hyperion Planning Training? Then here is the blog post on, explore Hyperion Planning Training

Task List

The task is an activity such as Data entry, using a web form (or) executing a Business Rule. Tasks are created by the Administrator and assign these tasks to Users or Groups.

Steps:-

• Open the planning application as an Administrator
• Click on Administration
• Click on Manage Tasklist
• Click on create on your LHS to create the Tasklist folder
• Click on create on your RHS to create a task list
• Enter the appropriate name, and click on OK
• Select the Task list and click on Edit
• Another window will pop-up then clicks on the Add Child, Enter the Task Name and click on the Type drop-down list, choose appropriate types, such as Data form or Business rule or workflow…
• Then enable the checkbox for a due date if you to specify the target Date, Month, Time to finish this task
• Enable the checkbox on repeat and enter the required number of hours or days.
• Similarly, enable the checkbox for the alert to enable the Email Notification for End-User
• Set the Date & Time
• Enable the checkbox for repeat and enter the number of hours
• Click on the property tab then it will display all the related planning objects according to your selection such as Data forms or Business Rules.
• Click on Close
• Now select Task list and then click on Assign Access, Click on Add-access, it will displays all users and groups. Select the required user or group and select the type of access. If type access is assigned then the same user needs to execute the task and if the type of access is managed then the user can reassign this task to someone else
• Click on Add
• Click on Close

Now the End-user will receive a notification Email about the task assignment

• He opens the planning application
• Clicks on View
• Click on Tasklist
• A window will pop-up, expand the task list and Double click on the task list folder then click on the task list on your RHS. Then the task name will appear as an URL
• Click on that; take appropriate action such as Date entry or Business Rule execution. Go back to the task list then enable the checkbox under complete then the status will be changed from Incomplete to complete
• Click on Close

Composite Data form

A Composite Data form was used to display more than one Data form in a single Data form Note:- Apart from Administrator an interactive user can also create a Task List and a planner cannot create a Tasklist

Application Owner

When a planning application is created by a technical Administrator, by default he acts as an application owner until he assigns someone like an application owner. The prerequisite to becoming an application owner, you should be provisioned with an Administration role under planning projects in shared services. Then log in to the planning application as an Administrator, click on Administration, Click on Application Settings then click on the Dropdown list under Assign Application owner, select appropriate user, and click on save.