Top 15 Hyperion Shared Service Interview Question & Answers updated 2022

1.What is Hyperion?

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.

2.What are the three primary build methods for building dimensions?

1.Generation references
2.Level References
3.Parent-Child references

3.Why is a top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them?

In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

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

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.

5.What are the types of partitioning options available in Essbase?

Replicated partition. 2. Transparent partition 3. Linked partition.

6.Can we have multiple databases in one single application?

Yes. But only one database per application is recommended.

7.Can we have one ASO database and one BSO database in one single application? If yes, how and If No, why?

No. Because we define the ASO or BSO option while creating the application and not the database. Hence if the application is ASO, the databases it contains will be that type only.

Enhance your skills with >>  Hyperion ESSBASE   >> Hyperion Financial Reporting

8.What are the file extensions for an outline, rule file and a calc script?

OTL, .RUL and .CSC

9.What are the different types of LOG Files?

So many log files are there in Essbase, but the important log files are:





ess base server-install.logSuppose 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 exist, we must assign gen 3.

10.What is a data file cache?

A buffer in memory that holds compressed data (.PAG) files.

11.A customer wants to run two instances of an Essbase server on the same machine to have both test env and Development env on the same server. Can he do that?

Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.

12.How is data stored in the Essbase database?

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

13.What is the difference between UDA and Attribute dimensions?

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.

14.What is UDA (user defined attributes). How are they different from Aliases?

UDA represents the class of the members. Aliases are just other names of the members. Both are different and have different usage.

15.Mention the main Features in Hyperion Planning v11.1.2.3?

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 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 refresh reports.  The cost of ownership is reduced through superior application deployment, management tools, and packaged data integration.

Related Courses:  Hyperion Financial Data Quality Management

Related Courses: Tibco Spotfire