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.
What is TB First and TB Last?
TB First: in the Sample.Basic database, the accounts 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.Basic database, the accounts 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.
How is data stored in the Essbase database?
Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.
What is Hyperion Planning?
Hyperion Planning is a budgeting and forecasting application from Oracle formerly owned by Hyperion Solutions Corporation. Hyperion Planning uses Essbase (s 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.
What is the need of property sheet?
The property sheet enables you to set various options for the currently selected reports.
How many data bases are used to connect Hyperion financial reporting studio?
Single data base is used to connect reporting studio.
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.
How can a report are 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 CurrentPOV member for the selected axis or choose a member selection function with CurrentPOV 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.
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.
What are the required components to create grid?
Rows,
Columns,
Pages,
Point of view,
Data area
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.
IS IT POSSIBLE TO HAVE A METAOUTLINE BUILT ON TWO SEPARATE OLAP MODELS?
No, it’s not possible.
WHAT PARTITIONING OPTIONS DO WE HAVE IN ESSBASE?
The partitioning options are: replicated, transparent and linked.
EXPLAIN CUSTOM BASED MACRO?
We write Ess base calculator functions and special macro functions under Ess base macros. Custom defined macros makes use of an internal Ess base macro language that enables to combine calculation functions and also helpful to operate on multiple input parameters.
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 has low probability that data will exist for every combination of dimension members.
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
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
Services dependency means?
Hyperion is dependent on services. Means services are to be started in a specified sequence only
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.
How many types of adjustments we can post.?
In HFM we have:
Entity Currency Adjs
Parent Currency Adjs
Parent Adjs
Contribution Adjs
How many level of security in HFM?
User authentication
Task securities
Document securities (Data grids and forms, journals, reports)
Data security