Automate HAL Load

Hi All,

good morning.

today we will see how we can autoamte HAL job (Flow diagram)

If you are loading a large number of members, HAL chokes if you don't automate it (.exe etc).

Here are the steps one should follow to autoamate a HAL job.

Step:1

Complete the flow diagram as shown below

Step:2
Drag and drop Window Executible from Palleate.

Step:3
Open the window executible. Go to Runtime Target tab.

give the location of the flow diagram.

Browse to the location, where you want to store the executible file.

Step:4
Check

• Use file name as runtime target name
• Automatically Build when OK pressed.

Step:5
don't check anything in Flow Diagrams tab as shown below:

Step:6

Don't check anything in Management tab as shown below:

Step:7
In Logging tab give the location of your log file.

Step:8
Don't check anything in Profile tab as shown below:

Step:9
Check

• Copy needed Vignette Business Integration Studio DLLs
• Run as Console application
• If you want status bar check that box

Step:10
Hit OK

Step :11

you will see your execution file in the list as shown below:

Step:12

you can give the location of executible file in your batch file and run it using scheduler like window scheduler.

Load dimension members into Planning Application using HAL from Relational Database

Hi Guys,

Good afternoon.

please find the process of loading metadata into planning application using HAL (Hyperion Application Link).

In the example below, I am loading employee dimension using HAL from SQL server table.

You can also load it from flat file (text file or .csv file)

I am using following adapters to complete loading:

1. Variable


2. Planning Adapter and


3. ODBC adapter.

The complete loading flow diagram is shown below:

The first adapter is Variable adapter.

we use this adapter to give log in information and application details.

The second adapter is Planning adapter. We use this adapter as a connector to Planning application. This adapter is fed from variable adapter. Make sure that you change setting to connector in this adapter.

In the General tab you can give custom defined name to adapter like Planning Connector etc.

In the Methods tab you should specify which dimension you are loading in the drop down menu. In this example we changed the dimension to employee as we are loading meta data related to employee.

The third adapter is planning adapter again. Make sure that you change the drop down to load as shown below:

You can specify the name of the adapter. For example Planning load adapter etc.

In the methods section you should specify the dimension you are loading to. In this example we are using Employee.

The last adapter is ODBC adapter.

You should create a DSN for the relational database in the location where you are running the HAL job. Then connect to the relational database.

Select the table which has metadata information.

Once you have all the information. Connect to ports as shown below and save and then run to load metadata.

Hope this helps.

How to delete members in planning using HAL

Hi
good morning.
Deleting members in planning is challenging to do manually as it consume lots of time specially if you more than 5 members to delete. we can use Hyperion Application Link (HAL) to delete precisely the members we don't need.

Here are the steps to follow on how to delete members using HAL

Step:1
prepare a text document or .CSV file of the list of members you want to delete in Parent, Child format.

Step:2
Open a new flow diagram and add flat file adapter, Planning adapter and Variable adapter as shown below. When you select a Planning adapter, the names of ports and the number of ports are determined by the dimension to which members are deleted. Most ports reflect the properties and custom attributes of the selected dimension.




Step : 3
Open a Variable adapter and type Delete in port name column and
in the Initial Value column type

Delete Level 0 .........................(If you want to delete the member if it has no children)
Delete Idescendants ............(If you want to delete the member and its descendants)
Delete Descendants ............. (If you want to delete the descendants but not the member)




Step.4:
Upload the flat file with members to delete as shown below:



After the execution of HAL, you should refresh planning application to push the changes to essbase.