1.What is Oracle Hyperion Financial Management (HFM)?
Oracle Hyperion Financial Management (HFM) is a comprehensive Web-based application that delivers global financial consolidation, reporting and analysis 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.
2.What is TB First and TB Last?
TB First: In the Sample. Basic database, the account’s 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. In The Basic database, the account’s 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.
3.How is data stored in the Essbase database?
Essbase is a file-based database where the data is stored in PAG files of 2 GB each and grows sequentially.
4.What is Hyperion Planning?
Hyperion Planning is a budgeting and forecasting application from Oracle formerly owned by Hyperion Solutions Corporation. Hyperion Planning uses Essbase (a multidimensional database product sold by Hyperion) as a database and calculation engine, a relational repository for business logic, and includes a web-based user interface.
The Software allows you to add planning or forecast data to actuals. You can use Web Forms to add the planning data or use the Excel SmartView tool. Most of the Hyperion reporting tools work great with planning.
Enhance your skills with >> Hyperion ESSBASE
Improve your skills with >> Hyperion Shared Service
5.What is the need for a property sheet?
The property sheet enables you to set various options for the currently selected reports.
6.How many databases are used to connect Hyperion financial reporting studio?
Single database is used to connect the reporting studio.
7.Why are dimensions listed on the user POV when changing them has no effect on the grid?
Multiple grids can be included in a report, where one or more of the grids are affected by Changes to those dimensions on the user POV.
8.How can a report be designed so that any changes to a user’s user POV changes the members selected from a row, column, or page axis on a grid?
Use the Current POV member for the selected axis or choose a member selection function with Current POV as the member parameter. When the report runs, the axis value is taken from the user POV. You can design a grid so that all axis values are taken from the user POV, making the report completely dynamic on a per-user basis.
9.What are Report Member Selections?
The Report Member Selections define the values for any dimensions not on a grid’s row, column, or page axis or set in the grid POV for all Grids in a specific report in the book.
10.What are the required components to create a grid?
Rows
Columns
Pages
Point of view
Data area.
11.WHAT IS THE MEANING OF A BLOCK LOCKING SYSTEM?
The Essbase Services, also called analytic, will make a lock to each of the blocks that encapsulate the childs of the initial block, this is what a block locking system means.
12.IS IT POSSIBLE TO HAVE A META OUTLINE BUILT ON TWO SEPARATE OLAP MODELS?
No, it’s not possible.
13.WHAT PARTITIONING OPTIONS DO WE HAVE IN ESSBASE?
The partitioning options are: replicated, transparent and linked.
14.EXPLAIN CUSTOM BASED MACRO?
We write Ess base calculator functions and special macro functions under Ess base macros. Custom defined macros make use of an internal Ess base macro language that enables combining calculation functions and also helps to operate on multiple input parameters.
Related Courses: Hyperion Financial Data Quality Management
Related Courses: Tibco Spotfire
Develop your skills with >> Tibco BW
15.EXPLAIN DENSE AND SPARSE DIMENSIONS?
Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which have a low probability that data will exist for every combination of dimension members.
16.What is the difference between switch sign for and switch type for ?
Switch type for: It is ticked to change
● ASSET to EXPENSE
● EXPENSE to ASSET
● LIABILITY to REVENUE
● REVENUE to LIABILITY
● BALANCE to FLOW
● FLOW to BALANCE
Switch sign for: It is ticked to change
● ASSET to LIABILITY
● LIABILITY to ASSET
● EXPENSE to REVENUE
● REVENUE to EXPENSE
17.What are the balance types of Journals? Difference between them?
Balanced
Un Balanced
Balanced by entity
Balanced: All the Debits and Credits will be balanced
Unbalanced: Debits and Credits will not be balanced
Balanced by entity: Debits and Credits for particular entity will be balanced
18.Services dependency means?
Hyperion is dependent on services. Means services are to be started in a specified sequence only.
19.What is HFM ARCHITECTURE?
Hyperion Financial Management is designed to operate as a multi-tier system.
Client tier:
●The client tier contains the user interface and the ability to communicate with the application tier. You can display data and metadata, enter data, and maintain metadata in this tier.
Web tier:
●The Web server tier contains the Web server. You can access the Web-enabled portions of Hyperion Financial Management in this tier. The Hyperion Financial Management Web client contains all functionality available in the Windows client with the exception of security administration.
Middle tier:
●The middle tier contains the domain intelligence and connections to the relational database.
Database tier:
●The data tier contains the relational database and all Hyperion Financial Management data and metadata.
20.How many types of adjustments we can post?
In HFM we have:
Entity Currency Adjs
Parent Currency Adjs
Parent Adjs
Contribution Adjs
21.How many levels of security in HFM?
1.User authentication
2.Task securities
3.Document securities (Data grids and forms, journals, reports)
4.Data security
