Using JHAT to automate HFM tasks

hi Nguyen, this looks interesting, but we are using HFM 11.1.2.3 and I couldnt find this JHAT tool in our installation folder, nor on Oracle support site. Do you have more information on this that how it can be installed or from where to get it? Thx

Tom

do you have an example on how to call the function ExtractData? I cant figure out the parameters

Hi,

for the Entity you must use lists.

Below an exemple for the Entity dimension:

InitLists ();
AddItemToList(“1″,”Entity”, “NEONN”);

then you must use “1” for the Entity field.

Best regards.

Hi Bhuvaneswari,

You have to ask your HFM developer to give you the right POV to use for the translate.

It depends on the application structure.

Best regards.

Hi,

Is there a way to extract user and group only instead of extracting all (security class, security class access, …) by using the ExtractSecurity function.
Thank you.

Regards

Hi Nizar,
I have used the Jhat.bat file directly from the server. But still I am getting the same error.

Thanks,
Samaresh

Hi Nizar,

I’m getting a null pointer exception issue with the Extract Data function. Any insights?

How to trigger Extended Analytics extract from this?

Best,
AB

Hi,

Below an example how to call Extended analytics :

EAExtract (“MyDSN”,”EA_Simple”,”specified”,”All”,”1″, “All”, “2”, “4”, “All”, “3”, “1”, “2”, “2”, “1”, “1”);

Parameters are below :

1 DSN Name
2 Table Prefix Name
3 Clear Option (All or Specified)
4 Scenario (List ID # or All)
5 Year (List ID # or All)
6 Period List (List ID # or All)
7 View (List ID # or All)
8 Entity (List ID # or All)
9 Value (List ID # or All)
10 Account (List ID # or All)
11 ICP (List ID # or All)
12 Custom1 (List ID # or All)
13 Custom2 (List ID # or All)
14 Custom3 (List ID # or All)
15 Custom4 (List ID # or All)

Can someone help with LOADDATA() I’m using following script to load data, I get Load succeeded but no data is loaded, I do get rejects in the log with message “Line: 1, Error: No section has been specified to determine if this is data, description or line item detail.”
Script:
Logon(“false”, “”, “ID”, “Password”);
OpenApplication(“Server”, “app”);
LoadData(“Replace”, “T:\Oracle\Automation\Datafile.csv”, “T:\Oracle\Automation\logfile_name.log”, “True”,”false”,”,”);
CloseApplication();
Logout();

Questions:
1. What does the True, False and empty “,” pertains to
2. Is there a way to assign rule for the load?
3. What would the file format should be?

Thanks

#===================
#Working version of ExtractData function
#===================

Logon(“false”,””,”admin”,”password”);
OpenApplication(“HFM_Cluster”,”xxxxxx”);

#referring to historical posts…
#Can some kind soul explain know why need to SetPOV before doing extract?
#SetPOV(Scenario,Year,Period,View,Entity,Value,Account,ICP,Custom1,Custom2,Custom3,Custom4)

SetPOV(“Actual”,”2020″,”Dec”,”YTD”,”E123″,””,”ACCT1234″,”[ICP Top]”,”C1Total”,”[None]”,”[None]”,”[None]”);

InitLists ();
AddItemToList(“6″,”Period”,”Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec”);
AddItemToList(“7″,”Entity”,”{ABC_CON.[Hierarchy]}”);
AddItemToList(“8″,”Account”,”{BS_COA.[Hierarchy]};{PL_COA.[Hierarchy]}”);

ExtractData(“d:\\Data_Extract.txt”, “d:\\Data_Extract.log”, “;”, “YTD”, “2021”, “Actual”, “6”, “7”, “8”, “true”);

CloseApplication();
Logout();

######################################
#ExtractData – 10 parameters needed, I labelled them 0-9 for easy reading
#0 = extract file location
#1 = log file location
#2 = delimiter
#3 = .W# Periodic/YTD
#4 = .Y# Year
#5 = .S# Scenario
#6 = .P# Period – “All” or use >> AddItemToList(“6″,”Period”,”….”);
#7 = .E# Entity – “All” or use >> AddItemToList(“7”, “Entity”, “….”);
#8 = .A# Account – “All” or use >> AddItemToList(“8”, “Account” “….”);
#9 = true/false – Include Calculated Data
######################################
## = .I# ICP – Cannot define. Its default as {[Base]};{[System]}
## = .V# Value – Cannot define. Its default as ;[None];
## = .C1 Custom1 – Cannot define. Its default as [Base]
## = .C2 Custom2 – Cannot define. Its default as [Base]
## = .C3 Custom3 – Cannot define. Its default as [Base]
## = .C4 Custom4 – Cannot define. Its default as [Base]