Top Hyperion Interview Questions and Answers

What is Hyperion?

Hyperion is a file that empowers you to access the data quickly. The association was bought by Oracle in 2007 and has continued upgrading the product. The Fancy name of Hyperion is Business Intelligence and its motto is to support better business decision-making.

What is Hyperion Planning?

Hyperion Planning is an accounting and forecasting application from Oracle formerly controlled by Hyperion Solutions Corporation. It uses Essbase as a database and calculation engine, a relational repository for business method of reasoning, and fuses a web-based user interface.  The Software allows you to add planning or forecast data to actuals.

What is Oracle Hyperion Financial Management (HFM)?

Oracle Hyperion Financial Management (HFM) is a complete Web-based application that provides global financial alliance, reporting and examination 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.

What are the different types of LOG Files?

The important LOG files are:

  1. Application.log
  2. Configtool.log
  3. Essbase.log
  4. ess base server-install.log
  5. eas_install.log

What are attributes?

A grouping of a member in a dimension. You can select and group members based on their related attributes. You can in like manner show an attribute when you perform calculations and use functions.

E.g. the database in Sample Basic which has product dimension 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.

Hyperion-QA

What are TB First and TB Last?

TB First: The accounts member Opening Inventory in the Sample.Basic database is tagged as TB First. Opening Inventory combines the value of the first month in every quarter and uses that value for that month’s parent.

E.g. the value for Qtr1 is the same as the value for Jan.

TB Last: The accounts member Ending Inventory in the Sample.Basic database is tagged as TB Last. Ending Inventory combines the value for the last month in every quarter and uses that value for that month’s parent.

E.g. the value for Qtr1 is the same as the value for Mar.

How does Attribute dim impact report performance?

Attribute dim highly impact the report performance as the attributes are calculated vigorously when referenced in the report. For very large number of attribute dim displayed in the report, the performance could extremely decrease. While filling the data, you have applied both the selection and the rejection criteria to a same record. The record will be rejected.

Explain why we use Hyperion?

We have IIS for HFM although there is no IIS for OLAp’s. If there is no IIS then it is a time taking process to recover financial data.

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

  • Attribute dimensions offers more flexibility than UDA’s.
  • Attribute calculations dimensions include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are computed dynamically.

Can we start and stop an application individually and how to increase performance using this?

We can manage our server resources by starting only applications which get heavy user traffic. Right when an application is started, memory is joined by all related data bases.

Explain custom based macro?

Custom defined macros makes use of an internal Ess base macro language that enables to combine calculation functions and also helpful to operate on multiple input parameters.

Explain data file cache?

It signifies buffer in memory which contains compressed data files (.PAG ).

Which two functions can produce a report that includes only Elimination entities?

The two functions are:

  • Fixed Name List
  • Dynamic Name List.

Explain Dense and Sparse Dimensions?

Dense dimension: It is a dimension in which most data exists for every combination of dimension members.

Sparse dimension: It is a dimension which has less probability that data will exist for every combination of dimension members.

What are the three primary build methods for building dimensions?

The three primary build methods for building dimensions are:-

  • Generation references
  • Parent-Child references
  • Level references

What impact do Attribute dimensions have on the performance of reports?

The impact of the Attribute dimensions on the performance of the reports is very high due to the dynamic calculation made referencing the reports. If the number of attribute dimensions shown in the reports is high, this will have a negative impact on performance.

What is the explanation for a higher efficiency of a bottom-up calculation than a top-down calculation?

The clarification behind this is figuring a higher measure of blocks than required and for the right results to show up there is a prerequisite for making a top-down calculation.

What is the real base for calling a parallel or a serial method for making the calculations?

We will use the serial estimation exactly when we have one processor and when we have more than one the operation can be part into strings that will wear down the diverse available processors.

What is the meaning of a block locking system?

The Essbase Services also known analytic will make a lock to all the blocks that capture the Childs of the initial block, this process is block locking system.

Next
Previous
One Comment

Add a Comment

Your email address will not be published. Required fields are marked *