The OneCloud Oracle Hyperion Financial Management (HFM) BizApp provides HFM-specific capabilities to automate the most widely-used HFM administrative functions for enhanced application management. OneCloud seamless integrates with applications that are used every day in an easy and intuitive setup that understands HFM. For documentation on all available commands, see the Oracle HFM Command Reference.
Oracle HFM compatibility
The OneCloud BizApp for Oracle HFM is compatible with all versions of HFM 18.104.22.168 or greater. If you require support for earlier versions of Oracle HFM (i.e. 9.x or 11.1.2.x), use the Oracle HFM Legacy BizApp or contact email@example.com.
OneCloud connects Oracle Hyperion Financial Management via the published Java API.
To automate functionality within your Oracle HFM environment from OneCloud, you’ll need to navigate to the connection manager to create a connection.
Need a specialized Oracle HFM Command?
If there are specific Oracle HFM operations that your company is looking to perform firstname.lastname@example.org to discuss the requirements and the possibility to incorporate the capability into OneCloud.
From here, choose Oracle HFM from the service drop-down and select the appropriate Runner. Now, enter values for the following fields:
|Username||TextField||Oracle HFM username|
|Password||TextField||Oracle HFM password|
|EPM Home||TextField||Path to the home directory for the EPM system|
|EPM Instance||TextField||Path to the EPM Instance|
|HFM Cluster||TextField||HFM Cluster|
The following is an example of a working connection. Please substitute your own values.
The following file is a sample HFM POV (Point of View) configuration used with the Extract Data to File and Extract Data to Database commands. As a best practice, this file should be stored as OneCloud File Resources and used as a variable.
[DATA_SUBSET],SCENARIO,"BudV1",[MEMBER] [DATA_SUBSET],YEAR,"2007",[MEMBER] [DATA_SUBSET],PERIOD,January,[MEMBER] [DATA_SUBSET],PERIOD,March,[MEMBER] [DATA_SUBSET],PERIOD,May,[MEMBER] [DATA_SUBSET],ACCOUNT,"[None]","Sales",[MEMBER] [DATA_SUBSET],ACCOUNT,"NetProfit","TotalAssets","OtherInfo","Validation",[MEMBER] [DATA_SUBSET],ENTITY,"EastRegion",a,B,[ALLMEMBERS]