Interview Questions.

Q1. How Does Essbase Recover From A Database Crash?

After a database crash or server interruption, Essbase routinely recovers a database after rolling lower back the tractions that had been lively at that point.

Q2. What Is The Meaning Of A Block Locking System?

The Essbase Services, also known as analytic will make a lock to every of the blocks that encapsulate the childs of the initial block, that is what a block locking machine me.

Q3. When Do We Generally Use Build Rules Files?

To automate the procedure of making dimensions with hundreds of contributors.

Q4. Why Are Filters Used?

If you want to grant get admission to to all dimensions then you definitely wouldn’t use a filter out. Just furnish read get admission to for the database to the user and/or institution. The best reasonyou could use a filter is if you wanted to restrict access.

Q5. What Are Dense And Sparse Dimensions?

Dense: A size which has the high opportunity that statistics exists for each combination of dimension members.

Sparse Dimension: A size which has low opportunity that information exists for each aggregate of size participants.

Q6. Can We Have Multiple Databases In Single Application?

Yes, on this one database in line with utility.

Q7. What Is The Role Of The Never Consolidate Operator (^)?

It stops member from turning into consolidate on all dimensions.

Q8. Can We Build Dimensions Directly From Data Sources Without Using Rule Files?

No.

Q9. Explain Dense And Sparse Dimensions?

Dense measurement is a measurement in which most information exists for each combination of dimension members whereas sparse dimensions are the dimensions which has low chance that records will exist for each mixture of size individuals.

Q10. What Is Uda (consumer Defined Attributes). How Are They Different Thanaliases?

UDA represents the elegance of the members. Aliases are just other names of the participants. Both are exceptional and feature unique usage.

Q11. What Are Filters?

A approach of controlling get admission to to database cells in essbase. A filter is the most precise level of safety, allowing you to outline various get right of entry to degrees distinct customers can must individual database values.

Q12. Define Hyperion?

Hyperion is Business Intelligence (BI) and Business Performance Management (BPM) tool. It is the marketplace leader in Operational , Financial and Strategic Planning.

It contains the packages for reporting, Planning , dashboards, Analysis, scorecarding, consolidation, Workspace, Master Data Management and Foundation.

Q13. What Is The Extension Of Cal Scripts, Batch Files, Outline, And Rule File?

Rule file is .RulCalc Script is – .CscBatch documents – .Batoutline – .Otl

Q14. Can We Query A Member For Its Uda In A Calculation Script?

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

Q15. What Are The Different Types Of Log Files?

So many log documents are there in ess base, but the essential log files are:

Application log

Essbase.Log

Configtool.Log

eas_install.Log

ess base server-set up.Log

Q16. How Is Data Stored In The Essbase Database?

Essbase is an file based database in which the facts is stored in PAG files of 2 GB each and grows sequentially.

Q17. Explain Attributes?

Classification of a member in a dimension is referred to as an characteristic. We can do choice of institution contributors based on their associated attributes. We can also specify an attribute while acting calculations and at the side of we are able to use calculation features. As instance, the db in Sample Basic with product measurement has some attributes like package type, length, and flavor. We can add attributes to the size and can retrieve information. For instance, to retrieve “coke with 8 Oz with bottles”.