Hyperion Essbase Interview

Hyperion Essbase Interview Questions

1.Can we have multiple meta outlines based on one OLAP model in Integration services?

 Ans: Yes

2.What are LRO’s( Linked Reporting Objects)?

Ans: They are specific objects like files, cell notes or URL’s associated with specific data cells of Essbase

 database. You can link multiple objects to a single data cell. These linked objects are stored in the server.

 These LRO’s can be exported or imported with the database for backup and migration activities.

3.What are the three primary build methods for building dimensions?

Ans:

Generation references

Level references

                  Parent-Child references

4.How does UDA’s impact database size?                                   

Ans: There will be no impact on the database as the UDA’s doesn’t store data in the database.

5.Can we have an meta outline based on two different OLAp models.

Ans: No.

6.Can we create UDA’s and apply it to Dense as well as Sparse dimensions?

Ans: Yes

7.Types of Partitions available in Essbase?

Ans: Three types of partitions are there.

                        Transparent partition: A form of shared partition that provides the ability to access and manipulate

        remote data  transparently as though it is part of your local database. The remote data is retrieved from

        the data source each time you request it. Any updates made to the data are written back to the data source

 and become immediately accessible to both local data target users and transparent data source users

Replicated Partition:

Linked Partition:

8.What is hybrid analysis?

Ans: Lower level members and associated data remains in relational database where as upper level members

 and associated data resides in Essbase database.

9.Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we

10.On what basis you will decide to invoke a serial or parallel calculation method.

Ans: 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.

11.How can you display UDA’s in reports?

Ans: UDA’s values are never displayed in the reports and hence do not impact report performance.

12.While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome?

Ans: The record will be rejected.

13.What are the specified roles other than Administrator to view sessions, disconnect sessions or kill users requests for a particular application?

Ans: You should have the role of Application manager for the specified application.

14.What is block locking system?

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

15.What are the three options specified in Username and Password management under security tab in Essbase server properties.

Ans: 1. Login attempts allowed before username is disabled.

2.   Number of inactive days before username is disabled.

3.   Number of days before user must change password.

16.Can we have multiple databases in one single application? Ans: Yes. But only one database per application is recommended.

Depend on which database that you are going to create. For Example: If you are creating ASO then we can’t create more that 1 db per application. If you are creating BSO then you can create more than 1 db per application

17.How is data stored in the Essbase database?

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

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

Ans: No