Top 17 Oracle Hyperion Planning Interview Questions You Must Prepare 19.May.2024

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

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.

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

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.

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.

Yes, in this one database per application.

It stops member from becoming consolidate on all 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.

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

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.

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.

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

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

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

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

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