Oracle Hyperion Interview Questions | Part - 2

1: What is an alternative to create metaoutline, rule file and load data.
 

A : Integration services and in version 11, we have Essbase studio.

  

2: Can we start and stop an application individually. How ca this be used to increase performance.

 

A: Yes. We can manage our server resources by starting only the applications which receive heavy user traffic. When an application is started, all associated atabases are brought to the memory.

3: We have created an application as unicode mode. Can we change it later to non-unicode mode.

A : No.

4: How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different.

A : Hyperion Administrative services console provides a migration utility to do this but onluy the application, database objects are migrated and no data is transferred. the answers to other two questions are Yes.

5: A customer wants to run two instances of an Essbase server on a same machine to have both test env and Development env on the same server. Can he do that?

 A: Yes. We can have multiple instances of an Essbase server on a single machine and there will be dfferent sets of windows services for all these instances.

6 suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.

A: Using (~) exclude from consolidation operator.

7: What does never consolidate operator(^) do?

A: It prevents members from being consolidate across any dimension.

8: Can we have multiple metaoutlines based on one OLAP model in Integration services?

Ans: Yes

9: Can we have an metaoutline based on two different OLAp models.

Ans: No.

10: What is hybrid analysis?

A: Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.

11: Why top-down calculation less efficient than a bottom-up calculation?Being less efficient, why do we use them.

A: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

12: On what basis you will decide to invoke a serial or parellel calculation method.

A: If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.

13: What is block locking system?

A : Analytic services(or Essbase Services) locks the block and all other blocks which contain the childs of that block while calculating this block is block locking system.

14: What are the types of partitioning options available in Essbase?

Ans: 1. Replicated partition. 2. Transparent partition 3. Linked partition.

15: Dynamic calc decreases the retreival time and increases batch database calculation time. How true is the statement?

A : The statement should be just opposite. As dynamic calc members are calculated when requested, the retreival time should increase.

16: A customer has a cube with 13 dimensions and the performance was fine. Now they have added two more dimensions in the existing cube and the performance becomes very very slow. Customer said logically nothing wrong with the two new dimensions they have added. What could be the reason for slowdown.

A : Even I dont have any clue. I experienced this few days back with a customer. If you can throw some light on this, please post your answer.