Home / Hyperion DRM

Hyperion Planning Interview Question and Answers

Rating: 5
Views: 4077
by Yamuna Karumuri
Last modified: February 25th 2021

If you're looking for Hyperion Planning Interview Questions & Answers for Experienced or Freshers, you are in the right place. There are a lot of opportunities from many reputed companies in the world. According to research Hyperion Planning has a market share of about 8.5%.

So, You still have the opportunity to move ahead in your career in Hyperion Planning Development. Mindmajix offers Advanced Hyperion Planning Interview Questions 2021 that helps you in cracking your interview & acquire a dream career as Hyperion Planning Developer.

If you want to enrich your career and become a professional in Hyperion Planning, then visit Mindmajix - a global online training platform: "Hyperion Planning Training" This course will help you to achieve excellence in this domain. 

Hyperion Interview Questions - Table of Contents

1. What is Hyperion?

2. What is Hyperion Planning?

3. What is Oracle Hyperion Financial Management (HFM)?

4. What are the different types of LOG Files?

5. What are attributes?

Top Hyperion Interview Questions

Q1) What is Hyperion?

Ans: Hyperion is a database that allows you to access the data very quickly. The company was bought by Oracle in 2007 and Oracle has continued to improve the product. The Fancy name of Hyperion is Business Intelligence and it aims to support better business decision-making.

Thus a BI system can be called a decision support system (DSS). Though the term business intelligence is sometimes used as a synonym for competitive intelligence because they both support decision making, BI Uses technologies, processes, and application to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes, and disseminates information with a topical focus on company competitors.

Q2) What is Hyperion Planning?

Ans: Hyperion Planning is a budgeting and forecasting application from Oracle formerly owned by Hyperion Solutions Corporation. Hyperion Planning uses Essbase (s multidimensional database product sold by Hyperion) as a database and calculation engine, a relational repository for business logic, and includes a web-based user interface.

The software allows you to add planning or forecast data to actuals. You can use Web Forms to add the planning data or use the Excel SmartView tool. Most of the Hyperion reporting tools work great with planning.

Q3) What is Oracle Hyperion Financial Management (HFM)?

Ans: Oracle Hyperion Financial Management (HFM) 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, part of the Oracle EPM Suite, supports the collection, consolidation, and reporting of financial results in multiple GAAPs as well as IFRS, and the reconciliation of differences among the various standards.

Hyperion Financial Management can be deployed quickly to integrate data from multiple Oracle and non-Oracle transactional systems, provide top-side reporting that conforms to IFRS requirements, and help organizations make the transition to IFRS.

Q4) What are the different types of LOG Files?

Ans: So many log files are there in Essbase, but the important log files are:
1. Application.log
2. Essbase.log
3. Configtool.log
4. eas_install.log
5. ess base server-install.log
Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time.  Now can we build the dimension? No. If gen 2 and gen 4 exists, we must assign gen 3.

Checkout Hyperion Planning Tutorials

Q5) What are attributes?

A classification of a member in a dimension. You can select and group members based on their associated attributes. You can also specify an attribute when you perform calculations and use calculation functions.

Eg: The database in Sample Basic which has product dimensions has some attributes like size, package type, and flavor. We can add these attributes to the dimensions where we can retrieve the data like for example to retrieve “coke with 8 Oz with bottles”, this is useful for generating reports.

Q6) What is TB First and TB Last?

Ans:

TB First: in the Sample.Basic database, the accounts member Opening Inventory is tagged as TB First. Opening Inventory consolidates the value of the first month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Jan.
TB Last: in the Sample.Basic database, the accounts member Ending Inventory is tagged as TB Last. Ending Inventory consolidates the value for the last month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Mar.

Q7) How does Attribute dim impact report performance?

Ans:

a) They highly impact the report performance as the attributes are calculated dynamically when referenced in the report. For the very large number of attribute dim displayed in the report, the performance could drastically reduce.
b) While loading the data, you have applied both the selection criteria as well as rejection criteria to the same record.
c) The record will be rejected.

Q8) Mention the main Features in Hyperion Planning v11.1.2.3?

Ans: 

The latest release of Oracle Hyperion Planning, v11.1.2.3, offers new key features for users and administrators, including ASO support within Planning, more flexibility to import and export metadata, and task list report visualizations. MijaDeering, Principal Solutions Manager at Edgewater Ranzal, provides an overview of these and other features of the newest Planning release.

Her presentation also includes a live demo of key features and an opportunity for viewers to ask questions and better understand the product’s enhancements. Oracle Hyperion Planning is a centralized, Microsoft Office and Web-based planning, budgeting, and forecasting solution that integrates financial and operational planning processes and improves business predictability.  It allows organizations to reduce planning, budgeting, and forecasting cycles by weeks or months and improve the accuracy of plans and forecasts.

Microsoft Office products are used as an interface into Oracle Hyperion Planning, so the learning curve for users is minimized, and Planning speeds up the time it takes to update plans and refreshes reports.  The cost of ownership is reduced through superior application deployment, management tools, and packaged data integration.?

Q9) How is data stored in the Essbase database?

Ans: Essbase is a file-based database where the data is stored in PAG files of 2 GB each and grows sequentially.

Q10) What is the difference between UDA’s and Attribute dimensions?

Ans: Attribute dimensions provide more flexibility than UDA’s. Attribute calculation dimensions which include five members with the default names sum, count, min, max, and avg are automatically created for the attribute dimensions and are calculated dynamically.