50 TOP Hyperion Essbase Interview Questions and Answers pdf

List of top 50 hyperion interview questions and answers,hyperion tutorials for freshers beginners and experienced pdf free download.
1.  What are the two storage options available in Essbase and what are the differences?
2.  Can we build dimensions directly from data sources without using rule files.
3.  When do we generally use build rules files?
4.  What are the three primary build methods for building dimensions?
5.  In what case we can define generation 1 to a field in generation build method.
6.  Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time. Can we build the dimension.
7.  Can we create more than 2 dimensions using only one build rule file.
8.  Can we query a member for its UDA in a calculation script.
9.  How does UDA's impact database size?
10. What is the difference between UDA's and Attribute dimensions?
11. How does Attribute dimensions and UDA's impact batch calculation performance?
12. How can we display UDA's in reports? How do they impact report report performance.
13. How does Attribute dim impact report performance?
14. 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.
15. How is data stored in the Essbase database?
16. Can we have multiple databases in one single application?
17. Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.
18. What are the file extensions for an outline, rule file and a calc script.
19. What is the role of provider services.
20. What is an alternative to create meta outline, rule file and load data.
21. Can we start and stop an application individually. How can this be used to increase performance.
22. We have created an application as unicode mode. Can we change it later to non-unicode mode.
23. 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.
24. 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?
25. 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.
26. What does never consolidate operator (^) do?
27. Can we have multiple meta outlines based on one OLAP model in Integration services?
28. Can we have an meta outline based on two different OLAP models.
29. What is hybrid analysis?
30. Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them.
31. What is block locking system?
32. What are the types of partitioning options available in Essbase?
33. Dynamic calc decreases the retrieval time and increases batch database calculation time. How true is the statement?
34. 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 slow. Customer said logically nothing wrong with the two new dimensions they have added. What could be the reason for slow down.
35. Can we have multiple meta outlines based on one OLAP model in Integration services?
36. What are LRO's( Linked Reporting Objects)?
37. What are the three primary build methods for building dimensions?
38. How does UDA's impact database size?
39. Can we have an meta outline based on two different OLAP models.
40. Can we create UDA’s and apply it to Dense as well as Sparse dimensions?
41. Types of Partitions available in Essbase?
44. What is hybrid analysis?
45. Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them.
46. On what basis you will decide to invoke a serial or parallel calculation method.
47. How can you display UDA’s in reports?
48. 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?
49. What are the specified roles other than Administrator to view sessions, disconnect sessions or kill users requests for a particular application?
50. What is block locking system?

0 comments: