Hyperion Financial Data Quality Management Interview Questions and Answers updated 2022

1.What is Hyperion Financial Management?

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.

2.What are the benefits of Hyperion Financial Management?


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.

3.Define Hyperion?

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

4.Explain Olap and mention if it is related to HYPERION FINANCIAL MANAGEMENT ?

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 OLAPtechnology present in the market. These are ROLAP, MOLAP and HOLAP.

An example of ROLAP is BO. Here we deal with tables and they act 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.

5.In Machine profile, which user id and Password will be given?

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

6.Is it possible to organize one-to-many mapping in FDM?

yes it is possible.

7.Which database consists of Financial data quality management?

Relational database management system (RDBMS)

8.Where are the data stores in the FDM application?

Each FDM Application contains four directories. 1) inbox 2) outbox 3) data 4) reports.

These are the directories which store the data.

Improve your skills with >>   Oracle Enterprise Data Quality   >>   Oracle Identity Analytics

Related Courses: Oracle Identity Analytics  >>  Oracle WebLogic

9.What are the types of mapping?

Explicit, in, like, and between mappings.

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

10.How to access the FDM web client?

Open the Hyperion FDM Web Client by selecting Programs oracle EPM Financial Data Quality

Management Web Server Components Web Logon.

11.Where do you have to get or import the data to FDM?

By importing GL files or from other external data sources.

12.Explain the data load process in FDM?

Please explain about import, export, validate and check.

13.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.

14.Hyperion fdm contains two types of locations

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

15.What are the methods to build maps?

Build maps internally within fdm.
Build maps externally imported to fdm.
Copy the existing location map to another location.
Assign mapped location to parent to other location.

Related Courses:  Fusion Middleware and OBIEE

Related Courses:  Oracle Data Integrator