300+[LATEST] Oracle Hyperion Planning Interview Questions and Answers

Q1. How Does Essbase Recover From A Database Crash?

After a database crash or server interruption, Essbase automatically recovers a database after rolling back the tractions that were active at that time.

Q2. What Is The Meaning Of A Block Locking System?

The Essbase Services, also called analytic will make a lock to each of the blocks that encapsulate the childs of the initial block, this is what a block locking system me.

Q3. When Do We Generally Use Build Rules Files?

To automate the process of creating dimensions with thousands of members.

Q4. Why Are Filters Used?

If you want to grant access to all dimensions then you wouldn’t use a filter. Just grant read access for the database to the user and/or group. The only reasonyou would use a filter is if you wanted to restrict access.

Q5. What Are Dense And Sparse Dimensions?

Dense: A dimension which has the high probability that data exists for every combination of dimension members.

Sparse Dimension: A dimension which has low probability that data exists for every combination of dimension members.

Q6. Can We Have Multiple Databases In Single Application?

Yes, in this one database per application.

Q7. What Is The Role Of The Never Consolidate Operator (^)?

It stops member from becoming consolidate on all dimensions.

Q8. Can We Build Dimensions Directly From Data Sources Without Using Rule Files?

No.

Q9. Explain Dense And Sparse Dimensions?

Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which has low probability that data will exist for every combination of dimension members.

Q10. What Is Uda (user Defined Attributes). How Are They Different Thanaliases?

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

Q11. What Are Filters?

A method of controlling access to database cells in essbase. A filter is the most detailed level of security, allowing you to define varying access levels different users can have to individual database values.

Q12. Define Hyperion?

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, scorecarding, consolidation, Workspace, Master Data Management and Foundation.

Q13. What Is The Extension Of Cal Scripts, Batch Files, Outline, And Rule File?

Rule file is .rulCalc Script is – .cscBatch files – .batoutline – .otl

Q14. Can We Query A Member For Its Uda In A Calculation Script?

Yes. You can query a member for its UDA in a calculation script.

Q15. What Are The Different Types Of Log Files?

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

  • Application log
  • Essbase.log
  • Configtool.log
  • eas_install.log
  • ess base server-install.log

Q16. How Is Data Stored In The Essbase Database?

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

Q17. Explain Attributes?

Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the db in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data. For example, to retrieve “coke with 8 Oz with bottles”.