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.