Hyperion FDM Interview Questions & Answers

Question 1. What Is Hyperion Financial Management?

Answer :

Oracle Hyperion Financial Management is a comprehensive, Web-based application that delivers global financial consolidation, reporting and analysis in a single, highly scalable software solution. Oracle Hyperion Financial Management utilizes today’s most advanced technology, yet is built to be owned and maintained by the enterprise’s finance team.

Question 2. What Are The Benefits Of The Hyperion Financial Management?

Answer :

BENEFITS:

• Accelerate reporting cycles – Reduce closing cycles by days, deliver more timely results to internal and external stakeholders.
• Improve transparency and compliance – Helps reduce the cost of compliance (as stipulated by the Sarbanes-Oxley Act, electronic filing, and other regulatory requirements) and support disclosure requirements, such as sustainability reporting.
• Perform strategic analysis – Spend less time on processing and more time on value-added analysis.
• Deliver a single truth – Provide a single version of the truth to support financial management and statutory reporting.
• Easily integrate – Integrate not only with Hyperion products but also with your existing infrastructure.

Question 3. Define Hyperion?

Answer :

Hyperion is Business Intelligence (BI) and Business Performance Management (BPM) tool. It is the market leader in Operational, Financial and Strategic Planning. It contains the applications for reporting, planning, dashboards, Analysis, score carding, consolidation, Workspace, Master Data Management and Foundation.

Question 4. Explain Olap And Mention If It Is Related To Hyperion Financial Management?

Answer :

Hyperion HFM/ Hyperion Planning both are Essbase based. They are front-end tech andEss-base is the back end. Ess-base is a M-OLAP. There are three types of OLAP technology present in the market. These are ROLAP, MOLAP and HOLAP.

An example of ROLAP is BO. Here we deal with table and they acts as a virtual cube. But if we think about Oracle Express Hyperion Essbase and Cognos then they are real cubes. Thus MOLAP. ROLAP+MOLAP=HOLAP.

In case of BO, we need to join to attain the OLAP effect virtually but behind is a joined table. But in Case of MOLAP there is no concept of table it is cube only.

For example a page is a table then a Book is a Cube.

Question 5. In Machine Profile Which User Id And Password Will Give?

Answer :

We have to give admin and password or machine name also provided in machine profile.

Question 6. Is It Possible To Organize One-to-many Mapping In Fdm?

Answer :

Yes it is possible.

Question 7. Which Data Base Consists In Financial Data Quality Management?

Answer :

Relational database management system (RDBMS)

Question 8. Where The Data Stores In The Fdm Application?

Answer :

Each FDM Application contains four directories:

1. Inbox
2. Outbox
3. Data
4. Reports

These are the directories which stores the data.

Question 9. What Are The Types Of Mapping?

Answer :

Explicit, in, like, and between mappings.

Explicit mapping is called one – one mapping and between mappings is called one – many mapping.

Question 10. How To Access The Fdm Web Client?

Answer :

Open the Hyperion FDM Web Client by selecting Programs oracle EPM Financial Data Quality Management Web Server Components Web Logon.

Question 11. Where You Have To Getting Or Importing The Data To Fdm?

Answer :

By importing GL files or from other external data sources.

Question 12. Explain The Data Load Process In Fdm?

Answer :

Explain about import, export, validate and check.The Hyperion FDM desktop is the control center from where a Hyperion FDM application is built and administered.

The desktop has three main areas: Screen Indicator, Hyperion FDM Menus, and the POV bar.

Question 13. The Hyperion Fdm Desktop Is The Control Center From Where A Hyperion Fdm Application Is Built And Administered?

Answer :

The desktop has three main areas: Screen Indicator, Hyperion FDM Menus, and the POV bar.

Question 14. Hyperion Fdm Contains Two Types Of Locations?

Answer :

• Data load
• Controls review.

Location that accepts the data from source file and loads the data by mapping rules to the target file.

Question 15. What Are The Methods To Build Maps?

Answer :

1. Build maps internally with in fdm.
2. Build maps externally import to fdm.
3. Copy existing location map to other location.
4. Assign mapped location is parent to other location.