Hyperion Planning Interview Questions and Answers

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

2. What is the Extension of Cal Scripts, Batch files, outline, and Rule File?

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

3. What does “DOU” mean?

In reference to RPG, DOU means (Do Until). This will execute a loop matched with an End or End do

For instance

Eval X=1


Eval X=X=1


This example will go through the loop 4 times with the result of X being 4.

“DOU” is similar to Do While(“DOW”) where the difference lies in that the DOU will always perform 1 pass through the loop and DOW will perform the comparison and only continue into the loop if the condition meets else the program continues after the

End (EndDo).

For example

Eval X=1




The result is that the loop will not execute and the value of X will be 1.

4. 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 reason you would use a filter is if you wanted to restrict access. 

5. Can we create more than 2 dimensions using only one build rule file?

Yes, we can do that but it is recommended to use a separate rule file for each dimension. 

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

7. What is the role of the never consolidate operator (^)?

It stops members from becoming consolidated on all dimensions.

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

9. How does UDA’s impact database size?

Absolutely no impact as UDA’s does not require additional storage space. 

10. When do we generally use build rules files?

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

11. Can we have multiple databases in single application?

Yes, in this one database per application.

12. 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 children of the initial block, this is what a block locking system means.

13. 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 that have a low probability that data will exist for every combination of dimension members.

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

15. What are Dense and Sparse Dimensions?

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

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

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

17. Explain attributes?

Classification of a member in a dimension is known as an attribute. We can do the 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. For example, the DB in Sample Basic with product dimensions 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”.

18. How does Essbase recover from a database crash?

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

19. Can we build dimensions directly from data sources without using rule files?


20. What are the different types of LOG Files?

So many log files are there in ess base, 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