HFM Task Flows provides a way to automatize HFM tasks (consolidations, data extracts, etc…). JHAT tool is another way to automatize these tasks using a batch file and the HFM API. It is the former HAT updated to be compliant with the last HFM release. JHAT offers the opportunity to use any scheduler to launch HFM tasks and provide a better flexibility than Task Flows.
How does it work?
JHAT utility is present in the path hereunder:
The batch file embeds all libraries, paths and other references to execute HFM tasks:
- Home settings
- Library settings
- Java and JHAT execution settings
Before the first run, it’ mandatory to create “setenv.cmd” file and set the parameter EPM_ORACLE_INSTANCE_FOR_JHAT to point to the EPM instance:
A text file provides the tasks to be executed against HFM. Basically, the structure of the file is as below:
- Consolidate() (or other HFM function)
You only have to provide the file previously create as argument and call the utility to run the task:
jhat.bat -I E:\JHAT\test.txt
Use “jhat.bat -H” command to explore the available options:
This utility can be used to launch consolidations, data load, data extraction, etc…
Some available functions from the HFM API:
As the tool is based on batch file, it’s easy to schedule using Windows Task Scheduler or any other enterprise scheduling tool (Control M, Dollar U, etc…).