Oracle Hyperion FM Interview Questions & Answers

1. What is HFM?

Ans: Oracle Hyperion Financial Management is a financial consolidation and reporting application built with advanced Web technology. It provides financial managers the ability to rapidly consolidate and report financial results, meet global regulatory requirements, reduce the cost of compliance and deliver confidence in the numbers.

2. How many standard dimensions are there in HFM?

Ans. There are 12 standard dimensions in HFM.

3. How do you create members in HFM?

Ans: Using manage metadata, we create child or sibling.

4. How do you create ICP members in HFM?

Ans: ICP members are not created by us directly. In Account/Entity dimension, if we check IsICP, then the system will consider the member as an ICP member.

5. Explain about Enity curr adj member in HFM

Ans: We give entity currency adjustments to POV when we are loading journals.

6. What are rules used for? How many rules an application can have?

Ans. Rules are used to automate the calculations of data within an application. An application can have

Rules are used to:

• Calculate data entry level amounts for a specific entity, scenario and period.
• Prevent data entry for a specific cell in a specific entity, scenario and period.

• Allow input at the parent entity level.

• Calculate data that cannot be calculated through a hierarchical aggregation such as ratios or variance analysis.

• Perform allocations from a parent entity to a list of base entities.

• Perform complex currency conversions, calculate exchange rate differences or perform other calculations necessary for your consolidation.

• Define formulas to dynamically calculate accounts.

• Specify the accounts in the application that support intercompany transactions.
  

7. What is application profile, can we change application profile at any point of time?

Ans. An application profile contains language, calendar, frequency, and period information    for an Application. No, application profile once created, cannot be changed.

8. What are custom top members?

Custom top member is a member of Account Dimension, where we have to mention which top member in the hierarchy of a custom dimension is valid for the account. Only the specified member, including all descendants, is valid for the account.

9. What is the Node security?

Ans: Node security is a member in Application Settings. There are 2 parameters- entity level/parent level. If we mention entity level. Security is given at the node level. If we mention parent level, security is given at parent level (including its children).

10. What is data audit in HFM?

Ans: Data audit feature is used to view data changes performed by users. We can filter the data changes by date range, application server, user and the dimension members of cells.

(EnableDataAudit metadata attribute is available in Scenario and Account dimensions.)