Forum Stats

  • 3,837,732 Users
  • 2,262,289 Discussions
  • 7,900,377 Comments

Discussions

Categories

Run Consolidation on HFM 11.2 using JHAT utility

User_RUHNJ
User_RUHNJ Member Posts: 54 Blue Ribbon
in Financial Consolidation

I am trying to use JHAT utility to run consolidations on my HFM 11.2 application. I have created setenv.cmd file and updated my jhat.bat accordingly. Then I have created TestConsol.txt file to pass the consolidation parameters. It looks like below

image.png


LEQ is the entity name. I get below errors when I run the jhat.bat

image.png


I doubt if there is a problem with the POV i am passing via txt file. I could not find a syntax to pass the consolidation variables. Can somebody help me on this?

Tagged:
· Share on TwitterShare on Facebook

Comments

  • Anand Thota
    Anand Thota Member Posts: 32 Red Ribbon

    Hi,

    Please try with below POV,

    Logon("false", "__Domain__", "__UserName__", "__Password__");

    OpenApplication("__Server__", "__App__");

    SetPOV("Scenario","Year", "Month", "<Scenario View>", "Entity", "<Entity Currency>", "Account", "[ICP Top]", "Custom1", "Custom2", "Custom3", "Custom4");

    Consolidate("AllWithData");

    CloseApplication();

    Logout();

    Please change the Scenario, entity, account and custom dimension members as per your requirement.

    Thanks,

    Anand Thota.

    · Share on TwitterShare on Facebook
  • User_RUHNJ
    User_RUHNJ Member Posts: 54 Blue Ribbon

    Thanks Anand for responding. I tried passing POV in suggested format. Still I am receiving below null point exception error. I am created setenv.cmd file on the HFM server.


    D:\Oracle\Middleware\EPMSystem11R1\..\jdk1.8.0_181\bin\java.exe -client -cp ;D:\Oracle\Middleware\EPMSystem11R1\..\oracle_common\modules\oracle.webservices_11.1.1\wsclient.jar;D:\Oracle\Middleware\EPMSystem11R1\..\oracle_common\modules\oracle.jrf_11.1.1\jrf.jar;D:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server\jhat.jar;D:\Oracle\Middleware\EPMSystem11R1\common\jlib\11.1.2.0\epm_j2se.jar;D:\Oracle\Middleware\EPMSystem11R1\common\jlib\11.1.2.0\epm_hfm_web.jar -D"EPM_ORACLE_INSTANCE=D:\Oracle\Middleware\user_projects\epmsystem1" -D"java.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration" -D"oracle.core.ojdl.logging.config.file=D:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server\jhat_logging.xml" -D"logging.folder=D:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\jhat" -D"org.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger" oracle.epm.fm.jhat.JHATMain -ID:\JHAT\29Mar21T1.txt

    java.lang.NullPointerException

    at oracle.epm.fm.jhat.ProcessFile.readFileAndExecute(ProcessFile.java:76)

    at oracle.epm.fm.jhat.JHATMain.main(JHATMain.java:30)

    java.lang.NullPointerException

    at oracle.epm.fm.jhat.ProcessFile.readFileAndExecute(ProcessFile.java:119)

    at oracle.epm.fm.jhat.JHATMain.main(JHATMain.java:30)

    · Share on TwitterShare on Facebook
  • Anand Thota
    Anand Thota Member Posts: 32 Red Ribbon

    Hi,


    Please find the below blogs that will help you for initial setup.

    Using JHAT to automate HFM tasks - ALwAYSON (neonn.com)

    Improve HFM user experience with JHAT “on the fly” - ALwAYSON (neonn.com)

    Oracle Hyperion Financial Management (HFM) Automation Using Java Heap Analysis Tool (JHAT) (performancearchitects.com)

    Thanks,

    Anand Thota.

    User_RUHNJ
    · Share on TwitterShare on Facebook
  • User_RUHNJ
    User_RUHNJ Member Posts: 54 Blue Ribbon
    edited Mar 30, 2021 12:20PM

    Thanks Anand. Issue was resolved for me after enclosing the file name in quotes when running the JHAT command.

    i.e., jhat.bat -I”D:\JHAT\hfmconsolcommand.txt” -O”D:\JHAT\hfmconsolcommand.log”

    · Share on TwitterShare on Facebook
  • Anand Thota
    Anand Thota Member Posts: 32 Red Ribbon

    can you confirm, which POV syntax you are using ?

    you can close the discussion, if everything is okay .


    Thanks,

    Anand Thota

    · Share on TwitterShare on Facebook
  • User_RUHNJ
    User_RUHNJ Member Posts: 54 Blue Ribbon

    Logon("false", "", "admin", "password1" );

    OpenApplication("HFMCluster", "TestApp");

    SetPOV("Actual", "2020", "Oct", "<Scenario View>", "LEQ", "<Entity Currency>", "A1011", "[ICP None]", "[None]", "[None]", "[None]", "[None]");

    Consolidate("Impacted");

    CloseApplication();

    Logout();


    POV order -Scenario, Year, Period, View, Entity, Account, ICP, C1, C2, C3, C4


    Regarding closing the discussion I do not see an option for that.

    · Share on TwitterShare on Facebook
  • Anand Thota
    Anand Thota Member Posts: 32 Red Ribbon

    i think you can mark as solution accepted.


    Thanks,

    Anand Thota

    · Share on TwitterShare on Facebook