Q1 : Why we use Hyperion?
A : We have IIS for HFM although there is no IIS for OLAp’s. If there is no IIS then it is a time taking process to recover financial data.
Q2 : What is Oracle Hyperion Financial Management (HFM)?
A : Oracle Hyperion Financial Management (HFM) is a complete Web-based application that provides global financial alliance, reporting, and examination in a single, highly scalable software solution. Oracle Hyperion Financial Management, part of the Oracle EPM Suite, supports the collection, consolidation, and reporting of financial results in multiple GAAPs as well as IFRS, and the reconciliation of differences among the various standards. Hyperion Financial Management can be deployed quickly to integrate data from multiple Oracle and non-Oracle transactional systems, provide top-side reporting that conforms to IFRS requirements, and help organizations make the transition to IFRS.
Q3 : What is Hyperion Planning?
A : Hyperion Planning is an accounting and forecasting application from Oracle formerly controlled by Hyperion Solutions Corporation. It uses Essbase as a database and calculation engine, a relational repository for business method of reasoning, and fuses a web-based user interface. The Software allows you to add planning or forecast data to actuals.
Q4 : How does Attribute dim impact report performance?
A : Attribute dim highly impact the report performance as the attributes are calculated vigorously when referenced in the report. For very large number of attribute dim displayed in the report, the performance could extremely decrease. While filling the data, you have applied both the selection and the rejection criteria to the same record. The record will be rejected.
Q5 : Explain the data file cache?
A : It signifies buffer in memory which contains compressed data files (.PAG ).
Q6 : Explain Dense and Sparse Dimensions?
A : Dense dimension: It is a dimension in which most data exists for every combination of dimension members.
Sparse dimension: It is a dimension which has less probability that data will exist for every combination of dimension members.
Q7 : What is Hyperion?
A : Hyperion is a file that empowers you to access the data quickly. The association was bought by Oracle in 2007 and has continued upgrading the product. The Fancy name of Hyperion is Business Intelligence and its motto is to support better business decision-making.
Q8 : What are the different types of LOG Files?
A : The important LOG files are:
- Application.log
- Configtool.log
- Essbase.log
- ess base server-install.log
- eas_install.log
Q9 : What is the difference between UDA’s and Attribute dimensions?
A :
- Attribute dimensions offer more flexibility than UDA’s.
- Attribute calculations dimensions include five members with the default names sum, count, min, max, and avg are automatically created for the attribute dimensions and are computed dynamically.
Q10 : Which two functions can produce a report that includes only Elimination entities?
A : The two functions are:
- Fixed Name List
- Dynamic Name List.
Q11 : Can we start and stop an application individually and how to increase performance using this?
A : We can manage our server resources by starting only applications which get heavy user traffic. Right when an application is started, memory is joined by all related databases.
Q12 : What are the three primary build methods for building dimensions?
A : The three primary build methods for building dimensions are:-
- Generation references
- Parent-Child references
- Level references
Q13 : What impact do Attribute dimensions have on the performance of reports?
A : The impact of the Attribute dimensions on the performance of the reports is very high due to the dynamic calculation made referencing the reports. If the number of attribute dimensions shown in the reports is high, this will have a negative impact on performance.
Q14 : What is the real base for calling a parallel or a serial method for making the calculations?
A : We will use the serial estimation exactly when we have one processor and when we have more than one the operation can be part into strings that will wear down the diverse available processors.
Q15 : What is the meaning of a block locking system?
A : The Essbase Services also known analytic will make a lock to all the blocks that capture the Childs of the initial block, this process is block locking system.
Q16 : When do we generally use build rules files?
A : To automate the process of creating dimensions with thousands of members.
Q17 : What is hybrid analysis?
A : Lower level members and associated data remains in relational database whereas upper-level members and associated data resides in Essbase database.
Q18 : On what basis you will decide to invoke a serial or parallel calculation method.
A : If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.
Q19 : What is block locking system?
A : Analytic services (or Essbase Services) locks the block and all other blocks which contain the Childs of that block while calculating this block is block locking system.
Q20 : What are the three options specified in Username and Password management under the security tab in Essbase server properties.
A : 1. Login attempts allowed before username is disabled.
2. Number of inactive days before username is disabled.
3. Number of days before user must change password.
Q21 : How is data stored in the Essbase database?
A : Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.
Q22 : Can we have multiple databases in one single application?
A : Yes. But only one database per application is recommended.
Q23 : What is custom defined function?
A : Essbase calculation functions that you develop in the Java programming language and then add to the standard Essbase calculation scripting language by means of MaxL.
Q24 : Why do objects gets locked and when does this happens?
A : Objects gets locked to prevent users to make simultaneous and conflicting changes to Essbase database objects. By default whenever an object is accessed through Administrative services console or Excel spreadsheet add-in, it gets locked.
Q25 : What are attributes?
A : 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.
Comments are closed.