Awesome Top 100 Hyperion Essbase Interview questions and Answers Part -2



Here is part-2 of the Series Top 100 Hyperion Essbase Interview questions and Answers

26)  Can we start and stop an application individually. How can this be used to increase performance.
Answer

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

27) 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 migration activities.

 

28) What is UDA (user defined attributes). How are they different than Aliases.
Answer UDA represents the class of the members. Aliases are just another names of the members. both are different and has different usage.

29) Can we query a member for its UDA in a calculation script.
Answer

Yes. You can query a member for its UDA in a calculation script.

30) 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.

31) What is hybrid analysis?
Answer

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

32) How to create Essbase application?

Answer

  1. a) Open Essbase Administrative Services 11.1.12.
  2. b) Enter the username and password to Logon into the Administration Server.
  3. c) Inside Essbase select Application and then select Create application,
  4. d) Either Block or Aggregate and name it.
  5. e) Select the application and choose the option create the DATABASE And name it.
  6. f) Select “outline à Edit”
  7. g) Using left click select “Add Child”. Similarly add required child and sibling as required and configure dimension and member property.
  8. h) database and using left click “Create à Rule File”.
  9. e) Select that database and using left click “load data à Select data file and rule file”

 

33) 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.

34) 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.

 

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

Answer

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.

 

36) What does never consolidate operator (^) do?
Answer

It prevents members from being consolidate across any dimension.

37) What are the different types of LOG Files?
Answer

The important log files are
1. Application log
2. Essbase.log
3. Configtool.log
4. eas_install.log
5. essbaseserver-install.log

6) opmn.log

7) Essbase_odl.log
38) 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.

39) How do you optimize outline?
Answer

Usually the outline is optimized using the hourglass design for dimension ordering i.e.,
· Dimension with Accounts tag
· Dimension with Time tag
· Largest Dense dimension
· Smallest dense dimension
· Smallest Sparse dimension
· Largest Sparse dimension

40) What are the ways to improve performance during data loads?
Answer

There are several ways to optimize load

  1. Grouping of Sparse member combinations
    2. Making the data source as small as possible
    3. Making source fields as small as possible
    4. Positioning the data in the same order as the outline
    5. Loading from Essbase Server
    6. Managing parallel data load processing

41) What are the design considerations for calculation optimization?

Answer

You can configure a database to optimize calculation performance. The best configuration for the site depends on the nature and size of the database.
· Block Size (8Kb to 100Kb) and Block Density
· Order of Sparse Dimensions
· Incremental Data Loading
· Database Outlines with Two or More Flat Dimensions
· Formulas and Calculation Scripts

 

42) What is SmartView?

Answer

It is a Web-deployed thin client that is embedded in a client spreadsheet application and Enables you to retrieve data and create ad hoc reports and it Provides integration with Microsoft Office products. This provides a single Excel interface to analyze data

 

43) What is outline?

Answer

Outline is Tree structure for dimension hierarchies and it also contains Consolidations and mathematical relationships between members

 

44) What are applications and database in Essbase?

Answer

Applications

 

Contain databases and shared scripts

Reside on the server where Essbase Server is installed

Run application server processes

Databases

 

Are repositories for multidimensional analytic data

Contain database objects and security definitions

 

45) We have created an application as Unicode mode. Can we change it later to non-Unicode mode.
Answer No.

46) What are the specified roles other than Administrator to view sessions, disconnect sessions or kill user’s requests for a particular application?
Answer You should have the role of Application manager for the specified application

 

47) What are different type of Essbase cache?

Answer

Hyperion Essbase Interview questions and Answers

48)  I have write access to one dimension, other dimensions i have read access, is it possible to load data into dimensions?

49) what is difference between shift and relative functions and where you used them?

50) what is relative function?


Leave a Reply