Monday, March 9, 2009

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.

























6 comments:

  1. hi
    Can u post the process of,backup of planning repository?

    Thanku in advance

    ReplyDelete
  2. Can u pls post sample businesrule n for what it was created.


    Thanku

    ReplyDelete
  3. Hi
    this is chinni.I urgenty need of the SDLC process of an essbase project plsssssssssss

    thanku in advance

    ReplyDelete
  4. Hi Chinni,
    can you email me at ppasup123@gmail.com

    Thanks
    Dornakal

    ReplyDelete
  5. To backup Planning repository, export all HSP_xxxxx Oracle tables from the Oracle schema.
    Examples of HSP tables - HSP_Object, HSP_Group.
    Also, export Business Rules tables from HBR repository relational database.
    Here is example of Business Rule - it is same as calc script but you can use [variable] to prompt and limit members:
    FIX (&CurrFcst , "Working", "Local", "HSP_InputValue", [Department])
    FIX(&FYofFcstQtr, &fcstmonth: Jan)

    "61100" ="61100_ex"+"61100_adj";
    "15200" = "15200"+ "15200_new_calc" ;
    "61300" ="61300_calc"+"61300_adj";
    :
    :
    :
    above HBR is used to total up accounts.
    [Department] is variable that is retrieved from Webform

    ReplyDelete
  6. Thanks for taking time to post on backup of planning and business rule.

    ReplyDelete