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.
- Use file name as runtime target name
- Automatically Build when OK pressed.
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:
Don't check anything in Profile tab as shown below:
- Copy needed Vignette Business Integration Studio DLLs
- Run as Console application
- If you want status bar check that box
you will see your execution file in the list as shown below:
you can give the location of executible file in your batch file and run it using scheduler like window scheduler.
hi
ReplyDeleteCan u post the process of,backup of planning repository?
Thanku in advance
Can u pls post sample businesrule n for what it was created.
ReplyDeleteThanku
Hi
ReplyDeletethis is chinni.I urgenty need of the SDLC process of an essbase project plsssssssssss
thanku in advance
Hi Chinni,
ReplyDeletecan you email me at ppasup123@gmail.com
Thanks
Dornakal
To backup Planning repository, export all HSP_xxxxx Oracle tables from the Oracle schema.
ReplyDeleteExamples 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
Thanks for taking time to post on backup of planning and business rule.
ReplyDelete