Latest Hyperion Planning Essbase Interview Questions with Answers.
Hyperion Interview Questions Answers asked in top MNCs like IBM, HP, TCS, Infosys, Wipro.What are the different types of LOG Files?Answer : So many log files are there in essbase, but the important log files are
1. Application log
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.Answer : No. If gen 2 and gen 4 exists, we must assign gen 3.
What are attributes?Answer : A classification of a member in a dimension. You can select and group members based on their associated attributes. You can also specify an attribute when you perform calculations and use calculation functions. Eg: The database in Sample Basic which has product dimension has some attributes like size, package type, and flavor. We can add these attributes to the dimensions where we can retrieve the data like for example to retrieve “coke with 8 Oz with bottles”, this is useful for generating reports.
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.
What is the difference between UDA's and Attribute dimensions?Answer : Attribute dimensions provides more flexibility than UDA's. Attribute calculations dimensions which include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are calculate dynamically.
How does Attribute dimensions and UDA's impact batch calculation performance?Answer : UDA's- No Impact as they do not perform any inherent calculations.
Attribute dim- No Impact as they perform only dynamic calculations.
What are different types of attributes?Answer : Essbase supports two different types of attributes.
1. User-Defined attributes
2. Simple attributes
User-Defined attributes: The attributes that are defined by the user.
Simple attributes: Essbase supports some attributes, they are: Boolean, date, number, and string.
What are filters?Answer : A method of controlling access to database cells in essbase. A filter is the most detailed level of security, allowing you to define varying access levels different users can have to individual database values.
What is TB First and TB Last?Answer : TB First: in the Sample.Basic database, the accounts member Opening Inventory is tagged as TB First. Opening Inventory consolidates the value of the first month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Jan.
TB Last: in the Sample.Basic database, the accounts member Ending Inventory is tagged as TB Last. Ending Inventory consolidates the value for the last month in each quarter and uses that value for that month’s parent. For example, the value for Qtr1 is the same as the value for Mar.
How can we display UDA's in reports? How do they impact report report performance.Answer : UDA's values are never displayed in the reports and hence do not impact report performance.
How does Attribute dim impact report performance?Answer : They highly impact the report performance as the attributes are calculated dynamically when referenced in the report. For very large number of att dim displayed in the report, the performance could drastically reduce.
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.Answer : The record will be rejected.
How is data stored in the Essbase database?Answer : Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.