Category Archives: Hyperion Interview Questions

What is the meaning of a block locking system? | Hyperion Questions

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

Posted in Hyperion Interview Questions | Leave a comment

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

We will use the serial calculation only when we have one processor and when we have more than one the operation can be split into threads that will work on the various available processors.

Posted in Hyperion Interview Questions | Leave a comment

What is the explanation for a higher efficiency of a bottom-up calculation than a topdown calculation? | Hyperion Questions

The reason for this is calculating a higher amount of blocks than needed and for the right results to show up there is a need for making a top-down calculation.

Posted in Hyperion Interview Questions | Leave a comment

What is the true meaning of a hybrid analysis? | Hyperion Questions

The members with a higher level along with the data associated will stay in the Essbase database while the members of a smaller level and their associated data will live in the relational database.

Posted in Hyperion Interview Questions | Leave a comment

Is it possible to have a metaoutline built on two separate OLAP models? | Hyperion Questions

No, it’s not possible.

Posted in Hyperion Interview Questions | Leave a comment

Is it possible to have several metaoutlines in the Integration services that are built on a single OLAP model? | Hyperion Questions

The answer is yes.

Posted in Hyperion Interview Questions | Leave a comment

What is the role of the never consolidate operator(^)? | Hyperion Questions

It stops member from becoming consolidate on all dimensions.  

Posted in Hyperion Interview Questions | Leave a comment

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? | Hyperion Questions

We can do it with (~)exclude of the consolidation operator.

Posted in Hyperion Interview Questions | Leave a comment

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? | Hyperion Questions

We will respond with yes, because we can have two instances of Essbase with various sets of services on the same machine.

Posted in Hyperion Interview Questions | Leave a comment

In what way can migrating of an application from the test environment be made if we want to move it in the production environment, also can we do this from Windows to Unix or if the test environment is different from the production environment? | Hyperion Questions

There is a tool given to us by the Hyperion Administrative services but this only helps with the migration of the application and the objects database while the data is not migrating. In the other two cases the answer is … Continue reading

Posted in Hyperion Interview Questions | Leave a comment