Most Asked Hyperion Interview Questions and Answers
What does “DOU” mean?
In reference to RPG, DOU means (Do Until).This will execute a loop matched with an End or End do
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
The result is that the loop will not execute and the value of X will be 1.
Which property helps us to consider using ACE ?
A very little population of inter company data forces us to consider using ACE.
Which two functions can produce a report that includes only Elimination entities?
Two functions which can produce a report that includes only Elimination entities are a Fixed Name List and Dynamic Name List.
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.
What are the three primary build methods for building dimensions?
The following are the three primary build methods for building dimensions :-
1) Generation references
2) Level references
3) Parent-Child references.
Differentiate between ASO & BSO?
1) We cannot write back in ASO although we can write back in BSO.
2) Most dimensions in ASO are sparse whereas in BSO most of them are dense.
3) We cannot create more than 1 database in ASO but we can create more than 1 db per application. If we have more than 10 dimensions then we should opt for ASO.
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”.
Can we run on the same machine two instances of the same Essbase server and each one will have the test environment and the development environment?
We will respond with yes, because we can have two instances of Essbase with various sets of services on the same machine.
If we have A as the dimension and B,C as members of it how can we stop b and c from rolling up to A?
We can do it with (~)exclude of the consolidation operator.