Oracle Hyperion Interview Questions with Answers
Question: 1. What Is Hyperion ?
Answer:
Hyperion is a file that empowers you to get admission to the statistics quickly. The affiliation was offered by way of Oracle in 2007 and has persevered upgrading the product. The Fancy name of Hyperion is Business Intelligence and its motto is to assist higher business decision-making.
Question: 2. What Is Hyperion Planning ?
Answer:
Hyperion Planning is an accounting and forecasting application from Oracle formerly managed with the aid of Hyperion Solutions Corporation. It uses Essbase as a database and calculation engine, a relational repository for commercial enterprise approach of reasoning, and fuses a web-primarily based person interface. The Software allows you to feature making plans or forecast facts to actuals.
Oracle 9i Interview Questions
Question: three. What Is Oracle Hyperion Financial Management (hfm) ?
Answer:
Oracle Hyperion Financial Management (HFM) is a whole Web-based application that gives international economic alliance, reporting and examination in a single, exceptionally scalable software answer. Oracle Hyperion Financial Management, part of the Oracle EPM Suite, helps the collection, consolidation and reporting of economic results in a couple of GAAPs in addition to IFRS, and the reconciliation of differences some of the various requirements. Hyperion Financial Management can be deployed quickly to combine facts from multiple Oracle and non-Oracle transactional systems, offer pinnacle-facet reporting that conforms to IFRS necessities, and assist groups make the transition to IFRS.
Question: four. What Are The Different Types Of Log Files ?
Answer:
The crucial LOG files are:
Application.Log
Configtool.Log
Essbase.Log
ess base server-install.Log
eas_install.Log
Oracle 9i Tutorial
Question: five. What Are Attributes ?
Answer:
A grouping of a member in a measurement. You can select and organization participants based on their related attributes. You can in like way display an attribute whilst you perform calculations and use capabilities.
E.G. The database in Sample Basic which has product dimension has a few attributes like size, package deal kind, and flavor. We can upload these attributes to the dimensions in which we can retrieve the records like for example to retrieve “coke with eight Oz with bottles”, that is beneficial for producing reviews.
Oracle Interview Questions
Question: 6. What Are Tb First And Tb Last ?
Answer:
TB First: The accounts member Opening Inventory within the Sample.Basic database is tagged as TB First. Opening Inventory combines the cost of the primary month in each area and uses that value for that month’s determine.
E.G. The fee for Qtr1 is the same as the fee for Jan.
TB Last: The money owed member Ending Inventory inside the Sample.Basic database is tagged as TB Last. Ending Inventory combines the cost for the remaining month in each sector and uses that fee for that month’s determine.
E.G. The fee for Qtr1 is the same as the fee for Mar.
Question: 7. How Does Attribute Dim Impact Report Performance ?
Answer:
Attribute dim notably effect the record overall performance because the attributes are calculated vigorously whilst referenced within the report. For very big number of attribute dim displayed in the report, the performance should extraordinarily decrease. While filling the statistics, you have got implemented both the selection and the rejection standards to a identical record. The report might be rejected.
Oracle 11g Tutorial Oracle 11g Interview Questions
Question: 8. Explain Why We Use Hyperion ?
Answer:
We have IIS for HFM despite the fact that there is no IIS for OLAp’s. If there is no IIS then it is a time taking manner to recover financial facts.
Question: nine. What Is The Difference Between Uda’s And Attribute Dimensions ?
Answer:
Attribute dimensions gives extra flexibility than UDA’s.
Attribute calculations dimensions consist of 5 individuals with the default names sum, be counted, min, max and avg are robotically created for the attribute dimensions and are computed dynamically.
Hyperion Financial Management Interview Questions
Question: 10. Can We Start And Stop An Application Individually And How To Increase Performance Using This ?
Answer:
We can control our server resources by starting handiest programs which get heavy user traffic. Right while an software is commenced, memory is joined by way of all related information bases.
Question: 11. Explain Custom Based Macro ?
Answer:
Custom described macros makes use of an internal Ess base macro language that enables to combine calculation features and additionally helpful to operate on a couple of input parameters.
Hyperion Essbase five Interview Questions
Question: 12. Explain Data File Cache ?
Answer:
It signifies buffer in memory which contains compressed information documents (.PAG ).
Oracle 9i Interview Questions
Question: thirteen. Which Two Functions Can Produce A Report That Includes Only Elimination Entities ?
Answer:
The two capabilities are:
Fixed Name List
Dynamic Name List.
Question: 14. Explain Dense And Sparse Dimensions ?
Answer:
Dense dimension: It is a size in which maximum statistics exists for each combination of measurement individuals.
Sparse dimension: It is a dimension which has less opportunity that statistics will exist for every mixture of dimension contributors.
Question: 15. What Are The Three Primary Build Methods For Building Dimensions ?
Answer:
The 3 number one construct strategies for constructing dimensions are:-
Generation references
Parent-Child references
Level references
Oracle HRMS Interview Questions
Question: sixteen. What Impact Do Attribute Dimensions Have On The Performance Of Reports ?
Answer:
The effect of the Attribute dimensions on the overall performance of the reviews is very excessive because of the dynamic calculation made referencing the reports. If the quantity of attribute dimensions proven within the reviews is excessive, this will have a terrible impact on overall performance.
Question: 17. What Is The Explanation For A Higher Efficiency Of A Bottom-up Calculation Than A Top-down Calculation ?
Answer:
The rationalization at the back of that is figuring a better degree of blocks than required and for the right results to reveal up there’s a prerequisite for creating a top-down calculation.
Oracle Forms And Reports Interview Questions
Question: 18. What Is The Real Base For Calling A Parallel Or A Serial Method For Making The Calculations ?
Answer:
We will use the serial estimation exactly while we have one processor and while we have multiple the operation can be element into strings in an effort to wear down the numerous to be had processors.
Oracle Interview Questions
Question: 19. What Is The Meaning Of A Block Locking System ?
Answer:
The Essbase Services also recognized analytic will make a lock to all of the blocks that seize the Childs of the initial block, this process is block locking device.
Question: 20. What Are The Two Storage Options Available In Essbase And What Are The Differences?
Answer:
ASO (Aggregate Storage Option) Used for :
If we have large quantity of dimensions (commonly greater than 10)
Most of the size are sparse
We can not write back in ASO. I heard currently that ASO will even have the write again capability.
BSO (Block Storage Option):
Dimensions are less and dense (endorsed values for no of dim are among 4 and eight).
We can write back for this reason a great deal appropriate for making plans applications.
Financial packages are typically dense systems and ordinary analytical cubes are sparse. Here we also need to understand what these dense and sparse individuals are. When the intersections or cells of dimensions on the whole contain a cost it’s far dense. Say as an instance we’ve got dimensions length(Month or zone) and location and we are calculation the sales amount.
Generally most regions(nations, cities) could have some sales value for a specific month or quarter. Hence we will say that our length dimensions could be dense. But now in place of duration, recollect some other size product. Now there are a few products which are offered in only a few precise regions hence for them there might be no values in different regions or could have very low percent of statistics values subsequently the shape turns into sparse.
Applied Materials Oracle Interview Questions
Question: 21. When Do We Generally Use Build Rules Files ?
Answer:
To automate the system of creating dimensions with heaps of participants.
Question: 22. Why Do Objects Gets Locked And When Does This Happens?
Answer:
Objects gets locked to save you users to make simultaneous and conflicting adjustments to Essbase database gadgets. By default each time an item is accessed through Aministrative services console or Excel spreadsheet add-in, it gets locked.
Question: 23. Can We Create More Than 2 Dimensions Using Only One Build Rule File ?
Answer:
Yes, we can try this but it is encouraged to use separate rule report for every measurement
Oracle Access Manager Interview Questions
Question: 24. What Is Uda( User Defined Attributes). How Are They Different Than Aliases.?
Answer:
UDA represents the elegance of the participants. Aliases are just every other names of the individuals. Both are distinct and has one of a kind utilization.
Oracle 11g Interview Questions
Question: 25. 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.
Question: 26. How Does Uda’s Impact Database Size ?
Answer:
Absolutely no impact as UDA’s does now not require extra garage area.
Dell Oracle Interview Questions
Question: 27. How Does Attribute Dimensions And Uda’s Impact Batch Calculation Performance ?
Answer:
1. UDA’s- No Impact as they do not perform any inherent calculations.
2. Attribute dim- No Impact as they perform simplest dynamic calculations.
Hyperion Financial Management Interview Questions
Question: 28. How Can We Display Uda’s In Reports? How Do They Impact Report Report Performance.
Answer:
UDA’s values are in no way displayed inside the reviews and for this reason do not impact document performance.
Question: 29. How Is Data Stored In The Essbase Database?
Answer:
Essbase is an report based database where the records is stored in PAG files of 2 GB each and grows sequentially.
Oracle Hyperion Planning Interview Questions
Question: 30. Can We Have Multiple Databases In One Single Application ?
Answer:
Yes. But best one database consistent with software is usually recommended.
Question: 31. Can We Have One Aso Database And One Bso Database In One Single Application. If Yes, How And If No, Why.?
Answer:
No. Because we define ASO or BSO alternative even as growing the software and now not database. Hence if the application is ASO, the databases it includes can be that type handiest.
Question: 32. What Is The Role Of Provider Services ?
Answer:
To speak among Essbase and Microsoft workplace gear.
Oracle Financials Interview Questions
Question: 33. What Is An Alternative To Create Meta Outline, Rule File And Load Data ?
Answer:
Integration services and in version 11, we’ve got Essbase studio.
Hyperion Essbase five Interview Questions
Question: 34. Can We Start And Stop An Application Individually. How Can This Be Used To Increase Performance.?
Answer:
Yes. We can control our server assets through starting simplest the programs which obtain heavy user visitors. When an application is started, all associated databases are added to the reminiscence.
Question: 35. 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?
Answer:
Yes. We may have more than one instances of an Essbase server on a unmarried gadget and there can be extraordinary units of windows offerings for most of these instances.
Question: 36. What Is Hybrid Analysis ?
Answer:
Lower degree individuals and associated statistics stays in relational database wherein as upper degree members and related records is living in Essbase database.
Oracle HRMS Interview Questions
Question: 37. Why Top-down Calculation Less Efficient Than A Bottom-up Calculation? Being Less Efficient, Why Do We Use Them ?
Answer:
In the method it calculates more blocks than is important. Sometimes it is vital to perform top-down calculation to get the ideal calculation consequences.
Question: 38. On What Basis You Will Decide To Invoke A Serial Or Parallel Calculation Method ?
Answer:
If we’ve got a unmarried processor, we are able to use serial calculation however if we’ve got more than one processors we can damage the project into threads and lead them to run on exceptional processors.
Question: 39. What Is Block Locking System ?
Answer:
Analytic services (or Essbase Services) locks the block and all different blocks which contain the Childs of that block whilst calculating this block is block locking system.
Question: 40. Dynamic Calc Decreases The Retrieval Time And Increases Batch Database Calculation Time. How True Is The Statement ?
Answer:
The announcement need to be simply opposite. As dynamic calc individuals are calculated when requested, the retrieval time should increase.
Oracle Forms And Reports Interview Questions
Question: forty one. What Are Lro’s( Linked Reporting Objects) ?
Answer:
They are specific gadgets like files, cellular notes or URL’s related to precise records cells of Essbase database. You can hyperlink a couple of items to a single facts cell. These linked objects are stored inside the server. These LRO’s may be exported or imported with the database for backup and migration sports.
Question: 42. Types Of Partitions Available In Essbase?
Answer:
Three styles of walls are there.
1. Transparent partition: A form of shared partition that gives the capability to get admission to and manipulate far off information transparently as even though it is part of your local database. The far off statistics is retrieved from the statistics supply every time you request it. Any updates made to the data are written returned to the records source and emerge as immediately reachable to each nearby statistics goal customers and transparent facts source users
2. Replicated Partition
three. Linked Partition
Applied Materials Oracle Interview Questions
Question: 43. How Can You Display Uda’s In Reports ?
Answer:
UDA’s values are by no means displayed in the reviews and subsequently do not effect document overall performance.
Question: forty four. Can We Have Multiple Databases In One Single Application?
Answer:
Yes. But only one database in line with application is suggested.
Depend on which database that you are going to create. For Example: If you’re creating ASO then we can’t create greater that 1 db in step with application. If you are creating BSO then you could create extra than 1 db per utility
Question: forty five. How Is Data Stored In The Essbase Database ?
Answer:
Essbase is an document primarily based database in which the information is saved in PAG files of two GB each and grows sequentially.
Question: forty six. What Is The Role Of Provider Services.?
Answer:
To talk between Essbase and Microsoft office gear.
Question: 47. A Customer Wants To Run Two Instances Of An Essbase Server On A Same Machine To Have Both Test Environment And Development Environment On The Same Server. Can He Do That ?
Answer:
Yes. We may have a couple of times of an Essbase server on a single machine and there may be distinctive sets of windows offerings for a majority of these instances.
Question: forty eight. What Is Custom Based Macro ?
Answer:
Essbase macros that we write with Essbase calculator features and special macro functions. Custom-defined macros use an internal essbase macro language that allows you to combine calculation feature and function on a couple of input parameters.
Question: 49. What Do You Mean By Dirty Block ?
Answer:
A facts block containing cells that have been changed since the ultimate calculation. Upper degree blocks are marked as grimy if their toddler blocks are dirty (that is, have been up to date)
Question: 50. How Do You Optimize Outline ?
Answer:
Usually the define is optimized using the hourglass design for size ordering i.E,
1. Dimension with Accounts tag
2. Dimension with Time tag
three. Largest Dense dimension
4. Smallest dense dimension
five. Smallest Sparse size
6. Largest Sparse measurement
Question: fifty one. What Are The Ways To Improve Performance During Data Loads ?
Answer:
There are numerous methods to optimize load
1. Grouping of Sparse member combinations
2. Making the facts source as small as possible
3. Making source fields as small as possible
4. Positioning the statistics inside the equal order because the outline
five. Loading from Essbase Server
6. Managing parallel statistics load processing
Question: fifty two. What Are The Design Considerations For Calculation Optimization ?
Answer:
You can configure a database to optimize calculation overall performance. The high-quality configuration for the web page relies upon on the nature and length of the database.
1. Block Size(8Kb to 100Kb) and Block Density
2. Order of Sparse Dimensions
3. Incremental Data Loading
four. Database Outlines with Two or More Flat Dimensions
5. Formulas and Calculation Scripts
Question: fifty three. When Does Fragmentation Occur ?
Answer:
Fragmentation is probably to occur with the subsequent:
1. Read/write databases that users are constantly updating with data
2. Databases that execute calculations across the clock
3. Databases that regularly update and recalculate dense contributors
4. Data loads which can be poorly designed
5. Databases that incorporate a significant number of Dynamic Calc and Store participants
6. Databases that use an isolation level of uncommitted get admission to with commit block set to zero
Question: fifty four. How Can You Measure Fragmentation ?
Answer:
You can measure fragmentation the use of the common clustering ratio or common fragmentation Quotient.
Using the common fragmentation quotient
Any quotient above the high give up of the variety suggests that lowering fragmentation might also assist performance
Small (up to two hundred MB) 60% or better
Medium (up to two GB) 40% or better
Large (greater than 2 GB) 30% or better
Using the common clustering ratio:
The average clustering ratio database statistic indicates the fragmentation level of the records (.Pag) files. The most fee, 1, shows no fragmentation.
Question: 55. How Do You Can Prevent And Remove Fragmentation ?
Answer:
You can save you and eliminate fragmentation:
1. To save you fragmentation, optimize facts loads through sorting load information based upon sparse measurement contributors. For a complete dialogue of optimizing information load by way of grouping sparse participants.
2. To put off fragmentation, perform an export of the database, delete all information inside the database with CLEARDATA, and reload the export record.
3. To eliminate fragmentation, force a dense restructure of the database.
Question: fifty six. Why Is Database Restructuring ?
Answer:
As your business adjustments, you convert the Essbase database define to seize new product traces, offer facts on new eventualities, mirror new time durations, and so on. Some adjustments to a database outline affect the facts storage association, forcing Essbase to restructure the database.
Question: 57. What Are The Types Of Database Restructuring ?
Answer:
The two methods via which a database restructure is induced:
Implicit Restructures
Dense restructure
Sparse restructure
Outline-best restructure
Explicit Restructures
Question: fifty eight. What Are The Conditions Affecting Database Restructuring ?
Answer:
Intelligent Calculation, name modifications, and components modifications have an effect on database restructuring:
1. If you use Intelligent Calculation within the database, all restructured blocks are marked as grimy on every occasion facts blocks are restructured. Marking the blocks as dirty forces the subsequent default Intelligent Calculation to be a complete calculation.
2. If you convert a name or a method, Essbase does now not mark the affected blocks as dirty. Therefore, you ought to use a technique aside from full calculation to recalculate the member or the database.
Question: fifty nine. What Are The Files Used During Restructuring ?
Answer:
When Essbase restructures each the records blocks and the index, it uses the documents described
essxxxxx.Pag
Essbase data fileessxxxxx.Ind
Essbase index filedbname.Esm
Essbase kernel document that includes manipulate facts used for db recoverydbname.Tct
Transaction control tabledbname.Ind
Free fragment document for information and index loose fragmentsdbname.Otl
Outline file in which is defined all metadata for a database and the way information is saved
Question: 60. What Are The Specified Roles Other Than Administrator To View Sessions, Disconnect Sessions Or Kill Users Requests For A Particular Application ?
Answer:
You should have the position of Application manager for the desired software.
Question: 61. Why Do Objects Gets Locked And When Does This Happens ?
Answer:
Objects receives locked to save you customers to make simultaneous and conflicting changes to Essbase database gadgets. By default whenever an item is accessed via Administrative services console or Excel spreadsheet add-in, it gets locked.
Question: sixty two. How Can We Backup An Aggregate Storage Database?
Answer:
To returned up an mixture garage database, replica the utility directory ARBORPATH/app/appname.
Question: 63. How Does Essbase Recover From A Database Crash ?
Answer:
After a database crash or server interruption, Essbase automatically recovers a database after rolling lower back the transactions that had been energetic at that time.
Question: sixty four. How Can You Make A Max L Script Run At A Specified Time?
Answer:
MaxL scripts may be known as from a BAT document which is used for scheduling.
Question: 65. What Is The Meaning Of The Two Options From Essbase Regarding Storage And What Separates Them ?
Answer:
The Aggregate Storage Option or ASO:
Used for extra than ten dimensions
The majority of the scale might be sparse
It is not possible to write lower back in ASO.
In the following variations we need to be capable of write returned.
The Block Storage Option or BSO:
1. Less dimensions and more dense dimensions
Question: sixty six. With The Aid Of A Single Build Rule File Can We Make At Least 2 Dimensions ?
Answer:
sure, but a exceptional rule file have to be used for every measurement.
Question: 67. What Is The Meaning Of User Defined Attributes Or Uda And What Is The Difference Between Them And Aliases ?
Answer:
The consumer defined attributes are relating to the contributors training while the aliases are most effective exceptional methods to call memebres, they may be completely separate and feature completely separate usages.
Question: 68. Is It Possible To Query A Member For Uda In Calculating Scripts ?
Answer:
Yes, we can question individuals for UDA in calculating scripts.
Question: sixty nine. What Impact Has Uda On The Size Of A Database ?
Answer:
Because UDA’s aren’t wanting any space further, they don’t have any impact on the dimensions of a database.
Question: 70. What Separates Attribute Dimensions From Uda’s ?
Answer:
Attribute dimensions are specific from UDA’s because of their stepped forward flexibility. The calculation with the attribute calculations dimensions with 5 members named: sum, min, max, matter and avg is made routinely and dunamicaly.
Question: seventy one. What Impact Have Uda’s And Attribute Dimensions On The Performance Of Batch Calculations ?
Answer:
The UDA’s don’t have any effect because they don’t make inherent calculations and the Attribute dimensions the identical have no effect due to the fact they simply make dynamic calculations.
Question: seventy two. In What Way Can We Show Uda’s In The Reports And What Impact Have They On The Performance Of The Reports?
Answer:
We can’t show UDA’s in the reports so there’s no overall performance alternate.
Question: seventy three. In What Way Is Data Storage Made In The Database Of Essbase ?
Answer:
In Essbase (a database primarily based on files)the information storage is made in 2GB PAG documents which have a sequential way of growing.
Question: 74. What File Extensions Are Used For Rule File, Calc Script Or Outline ?
Answer:
The extensions are: .RUL, .CSC and .OTL.
Question: 75. What Purpose Do Provider Services Have ?
Answer:
They have the motive of communication of the Essbase with the office gear of Microsoft.
Question: seventy six. How Can We Create Rule File, Load Data Or Metaoutline In A Different Way ?
Answer:
We can make it using Integration offerings and the ESSbase studio from the version 11.
Question: seventy seven. Is It Possible To Begin And End An Application At The Individual Level And Can This Enhance The Performance ?
Answer:
Yes, it’s far. We can begin handiest those applications that have excessive visitors, in this manner we will keep server assets, the reminiscence will be filled with databases at the start of the application.
Question: seventy eight. 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 Is Different From The Production Environment ?
Answer:
There is a device given to us with the aid of the Hyperion Administrative offerings but this most effective enables with the migration of the utility and the items database while the data is not migrating. In the other two cases the answer is sure.
Question: seventy nine. Can We Run On The Same Machine Two Instances Of The Same Essbase Server And Each One Will Have The Test Environment And The Development Environment?
Answer:
We will reply with yes, because we can have times of Essbase with diverse units of offerings on the same machine.
Question: 80. What Is The Role Of The Never Consolidate Operator(^)?
Answer:
It stops member from becoming consolidate on all dimensions
Question: eighty one. What Is The True Meaning Of A Hybrid Analysis ?
Answer:
The contributors with a better stage together with the information associated will stay within the Essbase database whilst the individuals of a smaller level and their associated records will stay within the relational database.
Question: 82. What Is The Real Base For Calling A Parallel Or A Serial Method For Making The Calculations?
Answer:
We will use the serial calculation simplest whilst we’ve got one processor and when we’ve multiple the operation may be break up into threads as a way to work at the diverse available processors.