Help Desk

Submit a ticket My Tickets
Welcome
Login

Oracle Hyperion Financial Management BizApp


Premium BizApp

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 11.1.2.4 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 support@onecloud.io.

Connection Setup

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 support@onecloud.io 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: 

InputTypeDetail
UsernameTextFieldOracle HFM username 
PasswordTextFieldOracle HFM password
EPM HomeTextFieldPath to the home directory for the EPM system
EPM InstanceTextFieldPath to the EPM Instance
HFM ClusterTextFieldHFM Cluster

Connection Example

The following is an example of a working connection. Please substitute your own values.

Sample Configuration File

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]
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.