Interview Questions.

Q1. In What Way Is Data Storage Made In The Database Of Essbase ?

In Essbase (a database based on files)the facts garage is made in 2GB PAG documents that have a sequential way of growing.

Q2. Can We Have Multiple Databases In One Single Application?

Yes. But most effective one database according to application is suggested.

Depend on which database that you are going to create. For Example: If you are developing ASO then we are able to’t create more that 1 db in line with utility. If you're growing BSO then you may create more than 1 db in line with application

Q3. How Is Data Stored In The Essbase Database?

Essbase is an report based totally database wherein the facts is saved in PAG files of two GB every and grows sequentially.

Q4. On What Basis You Will Decide To Invoke A Serial Or Parallel Calculation Method ?

If we've a unmarried processor, we will use serial calculation but if we've more than one processors we can break the project into threads and lead them to run on exceptional processors.

Q5. 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?

Yes. We will have more than one times of an Essbase server on a unmarried machine and there will be exceptional units of home windows services for a majority of these times.

Q6. Explain Why We Use Hyperion ?

We have IIS for HFM although there may be no IIS for OLAp’s. If there is no IIS then it's far a time taking method to recover monetary statistics.

Q7. Is It Possible To Query A Member For Uda In Calculating Scripts ?

Yes, we are able to query participants for UDA in calculating scripts.

Q8. What Is Hyperion ?

Hyperion is a document that empowers you to access the data quick. The affiliation changed into sold by means of Oracle in 2007 and has continued upgrading the product. The Fancy call of Hyperion is Business Intelligence and its motto is to aid higher business decision-making.

Q9. What Is The Explanation For A Higher Efficiency Of A Bottom-up Calculation Than A Top-down Calculation ?

The clarification in the back of this is figuring a higher measure of blocks than required and for the right consequences to show up there's a prerequisite for creating a top-down calculation.

Q10. Explain Custom Based Macro ?

Custom described macros uses an inner Ess base macro language that enables to combine calculation features and also beneficial to function on more than one input parameters.

Q11. Can We Start And Stop An Application Individually. How Can This Be Used To Increase Performance.?

Yes. We can control our server sources with the aid of beginning handiest the programs which acquire heavy person visitors. When an utility is began, all associated databases are brought to the memory.

Q12. What Impact Do Attribute Dimensions Have On The Performance Of Reports ?

The impact of the Attribute dimensions at the overall performance of the reports could be very excessive because of the dynamic calculation made referencing the reviews. If the quantity of attribute dimensions shown inside the reviews is excessive, this will have a bad impact on overall performance.

Q13. What Do You Mean By Dirty Block ?

A facts block containing cells which have been modified because the last calculation. Upper stage blocks are marked as dirty if their baby blocks are dirty (that is, had been updated)

Q14. How Can We Backup An Aggregate Storage Database?

To lower back up an mixture storage database, copy the utility listing ARBORPATH/app/appname.

Q15. What Is Oracle Hyperion Financial Management (hfm) ?

Oracle Hyperion Financial Management (HFM) is a complete Web-primarily based application that offers international financial alliance, reporting and exam in a unmarried, fairly scalable software program answer.  Oracle Hyperion Financial Management, part of the Oracle EPM Suite, supports the collection, consolidation and reporting of financial effects in multiple GAAPs as well as IFRS, and the reconciliation of differences most of the various requirements. Hyperion Financial Management can be deployed quick to combine information from more than one Oracle and non-Oracle tractional systems, provide top-facet reporting that conforms to IFRS requirements, and help companies make the trition to IFRS.

Q16. What Are The Types Of Database Restructuring ?

The  methods through which a database restructure is brought on:

Implicit Restructures

Dense restructure

Sparse restructure

Outline-simplest restructure

Explicit Restructures

Q17. What Are The Ways To Improve Performance During Data Loads ?

There are numerous methods to optimize load

@Grouping of Sparse member mixtures

@Making the information supply as small as possible

@Making source fields as small as viable

@Positioning the facts within the same order as the outline

@Loading from Essbase Server

@Managing parallel statistics load processing

Q18. Can We Create More Than 2 Dimensions Using Only One Build Rule File ?

Yes, we are able to try this however it's far encouraged to use separate rule file for every size

Q19. How Does Attribute Dim Impact Report Performance ?

Attribute dim surprisingly effect the document performance as the attributes are calculated vigorously whilst referenced in the document. For very massive range of characteristic dim displayed within the record, the overall performance may want to extraordinarily decrease. While filling the records, you have implemented each the selection and the rejection standards to a identical document. The file could be rejected.

Q20. How Is Data Stored In The Essbase Database ?

Essbase is an file primarily based database wherein the records is stored in PAG files of 2 GB each and grows sequentially.

Q21. What Is The Role Of Provider Services.?

To talk between Essbase and Microsoft office gear.

Q22. How Can We Create Rule File, Load Data Or Metaoutline In A Different Way ?

We can make it the use of Integration services and the ESSbase studio from the version 11.

Q23. What Are The Three Primary Build Methods For Building Dimensions ?

The 3 number one construct strategies for constructing dimensions are:-

Generation references

Parent-Child references

Level references

Q24. How Does Essbase Recover From A Database Crash ?

After a database crash or server interruption, Essbase automatically recovers a database after rolling returned the tractions that were energetic at that point.

Q25. What Is The Real Base For Calling A Parallel Or A Serial Method For Making The Calculations?

We will use the serial calculation most effective when we've got one processor and whilst we've got a couple of the operation may be cut up into threads in an effort to paintings on the various available processors.

Q26. With The Aid Of A Single Build Rule File Can We Make At Least 2 Dimensions ?

Yes, but a distinct rule record must be used for every size.

Q27. What Are The Conditions Affecting Database Restructuring ?

Intelligent Calculation, name adjustments, and method adjustments have an effect on database restructuring:

@If you operate Intelligent Calculation in the database, all restructured blocks are marked as dirty whenever records blocks are restructured. Marking the blocks as dirty forces the following default Intelligent Calculation to be a full calculation.

@If you change a name or a formula, Essbase does no longer mark the affected blocks as grimy. Therefore, you must use a technique other than complete calculation to recalculate the member or the database.

Q28. In What Way Can Migrating Of An Application From The Test Environment Be Made If We Want To Move It In The Production Environment, Also Can We Do This From Windows To Unix Or If The Test Environment I

There is  a tool given to us with the aid of the Hyperion Administrative offerings  but this handiest enables with the migration of the software and the objects database even as the records isn't migrating. In the other two instances the wer is sure.

Q29. Can We Have Multiple Databases In One Single Application ?

Yes. But most effective one database in line with software is usually recommended.

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

It stops member from becoming consolidate on all dimensions

Q31. How Do You Optimize Outline ?

Usually the outline is optimized the usage of the hourglass layout for measurement ordering i.E,

@Dimension with Accounts tag

@Dimension with Time tag

@Largest Dense dimension

@Smallest dense dimension

@Smallest Sparse measurement

@Largest Sparse dimension

Q32. What Are Tb First And Tb Last ?

TB First: The bills member Opening Inventory in the Sample.Basic database is tagged as TB First. Opening Inventory combines the fee of the first month in every area and makes use of that value for that month’s determine.

E.G. The cost for Qtr1 is the same as the cost for Jan.

TB Last: The debts member Ending Inventory within the Sample.Basic database is tagged as TB Last. Ending Inventory combines the cost for the remaining month in each region and makes use of that value for that month’s parent.

E.G. The value for Qtr1 is the same as the price for Mar.

Q33. When Do We Generally Use Build Rules Files ?

To automate the manner of creating dimensions with hundreds of contributors.

Q34. What Is An Alternative To Create Meta Outline, Rule File And Load Data ?

Integration offerings and in model 11, we have Essbase studio.

Q35. Types Of Partitions Available In Essbase?

Three varieties of walls are there.

@Trparent partition: A form of shared partition that provides the capacity to get right of entry to and control far off information trparently as though it is part of your local database. The faraway information is retrieved from the information source whenever you request it. Any updates made to the data are written again to the statistics source and turn out to be without delay reachable to each local data target customers and trparent statistics supply customers

@Replicated Partition

@Linked Partition

Q36. Explain Data File Cache ?

It signifies buffer in memory which incorporates compressed records documents (.PAG ).

Q37. How Can You Measure Fragmentation ?

You can degree fragmentation the usage of the common clustering ratio or common fragmentation Quotient.

Using the average fragmentation quotient

Any quotient above the high stop of the range suggests that reducing fragmentation might also assist overall performance

Small (as much as 200 MB) 60% or higher

Medium (up to two GB) forty% or higher

Large (greater than 2 GB) 30% or higher

Using the average clustering ratio:

The common clustering ratio database statistic suggests the fragmentation degree of the records (.Pag) documents. The maximum price, 1, indicates no fragmentation.

Q38. Why Do Objects Gets Locked And When Does This Happens?

Objects gets locked to save you users to make simultaneous and conflicting changes to Essbase database objects. By default on every occasion an item is accessed via Aministrative services console or Excel spreadsheet upload-in, it receives locked.

Q39. What Impact Has Uda On The Size Of A Database ?

Because UDA’s are not desiring any area similarly, they don’t have any effect on the scale of a database.

Q40. Is It Possible To Begin And End An Application At The Individual Level And Can This Enhance The Performance ?

Yes, it's miles. We can begin only the ones programs which have excessive traffic, in this manner we can shop server assets, the reminiscence may be filled with databases at the beginning of the software.

Q41. What Is The True Meaning Of A Hybrid Analysis ?

The members with a higher level in conjunction with the information associated will stay within the Essbase database while the participants of a smaller stage and their related records will stay inside the relational database.

Q42. What Is The Role Of Provider Services ?

To speak between Essbase and Microsoft office tools.

Q43. What Are The Different Types Of Log Files ?

The vital LOG documents are:

Application.Log

Configtool.Log

Essbase.Log

ess base server-installation.Log

eas_install.Log

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

The Essbase Services also recognized analytic will make a lock to all of the blocks that seize the Childs of the initial block, this method is block locking gadget.

Q45. What File Extensions Are Used For Rule File, Calc Script Or Outline ?

The extensions are: .RUL, .CSC and .OTL.

Q46. Explain Dense And Sparse Dimensions ?

Dense dimension: It is a dimension in which maximum facts exists for every combination of size members.

Sparse size: It is a dimension which has much less opportunity that facts will exist for each combination of measurement contributors.

Q47. What Is Custom Based Macro ?

Essbase macros that we write with Essbase calculator functions and unique macro features. Custom-defined macros use an inner essbase macro language that permits you to combine calculation function and operate on a couple of input parameters.

Q48. How Can You Make A Max L Script Run At A Specified Time?

MaxL scripts may be known as from a BAT record which is used for scheduling.

Q49. What Is The Meaning Of The Two Options From Essbase Regarding Storage And What Separates Them ?

The Aggregate Storage Option or ASO:

Used for more than ten dimensions

The majority of the size might be sparse

It is impossible to put in writing again in ASO.

In the next versions we must be able to write again.

The Block Storage Option or BSO:

@Less dimensions and extra dense dimensions

Q50. What Are The Design Considerations For Calculation Optimization ?

You can configure a database to optimize calculation overall performance. The best configuration for the web site relies upon 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