Hi,
You may like to read my earlier post Hyperion Essbase Interview Questions.
Today I will be posting few more questions on Hyperion Essbase more from an Administrative perspective.
The questions and answers have been designed by me and are not copied from anywhere.
Que:1 What are LRO's( Linked Reporting Objects)?
Answer: 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 migtarion activities.
Que:2 What are the specified roles other than Aministrator to view sessions, disconnect sessions or kill users requests for a particular application?
Answer: You should have the role of Application manager for the specified application.
Que:3 What are the three options specified in Username and Password management under security tab in Essbase server proprties.
Answer: 1. Login attempts allowed before username is disabled.
2. Number of inactive days before username is diabled.
3. Number of days before user must change password.
Que:4 Why do objects gets locked and when does this happens?
Answer: Objects gets locked to prevent users to make simultaneous and conflicting changes to Essbase database objects. By default whenever an object is accessed through Aministrative services console or Excel spreadsheet add-in, it gets locked.
Que: 5 I have created an application with one database in Essbase at test environment and now needs to copy the entire application with all security permissions to the production server which is not connected to the test server. How can I do that?
Answer: You can acheive this using migration wizard to migrate an application to a text file which you can take physically to the production server.
To know how you can do that, take a look at this post Essbase Application Migration.
Que:6 From the above question, When I migrated the application to the production server I do not see any data in the Essbase database. What has gone wrong and how to correct this?
Answer: Nothing has gone wrong. Migration utility does not migrate the actual data. If you want to copy the exact data from the test machine, get it exported using export utility and import it on production machine.
Que:7 Referring to the above question, Can I still do this if my production server and test server are two different operation systems. Explain.
Answer: While exporting the database, you can write the database data to an ASCII text file which enables you to load data on different platforms.
Que:8 How can we backup an aggregate storage database?
Answer: To back up an aggregate storage database, copy the application directory ARBORPATH/app/appname.
Que:9 How does Essbase recover from a database crash?
Answer: After a database crash or server interruption, Essbase automatically recovers a database after rolling back the transactions that were active at that time.
Que:10 How can you make a Max L script run at a specified time?
Answer: MaxL scripts can be called from a BAT file which is used for scheduling.
More questions will be coming soon...
