Oracle Hyperion Financial Management is a web based financial consolidation tool. What is Consolidation? Consolidation is aggregating the Base level entities amounts with the Parent level entities amounts. How many Custom dimensions are there in HFM?

Author:Tolrajas Akinoll
Language:English (Spanish)
Published (Last):7 September 2011
PDF File Size:11.86 Mb
ePub File Size:18.16 Mb
Price:Free* [*Free Regsitration Required]

Nice tutorial. Keep Sharing Tutorials. Do you know your hidden name meaning? Click here to find your hidden name meaning. Total Pageviews. What is HFM? Ans: Oracle Hyperion Financial Management is a financial consolidation and reporting application built with advanced Web technology.

It provides financial managers the ability to rapidly consolidate and report financial results, meet global regulatory requirements, reduce the cost of compliance and deliver confidence in the numbers.

How many standard dimensions are there in HFM? There are 12 standard dimensions in HFM. How do you create members in HFM? Ans: Using manage metadata, we create child or sibling. Ans: ICP members are not created by us directly. Explain about Enity curr adj member in HFM.

Ans: We give entity currency adjustments to POV when we are loading journals. What are rules used for? How many rules an application can have?

Rules are used to automate the calculations of data within an application. An application can have. Rules are used to:. What is application profile, can we change application profile at any point of time? No, application profile once created, cannot be changed. What are custom top members? Custom top member is a member of Account Dimension, where we have to mention which top member in the hierarchy of a custom dimension is valid for the account.

Only the specified member, including all descendants, is valid for the account. What is the Node security? Ans: Node security is a member in Application Settings. If we mention entity level. Security is given at the node level. If we mention parent level, security is given at parent level including its children.

What is data audit in HFM? Ans: Data audit feature is used to view data changes performed by users. We can filter the data changes by date range, application server, user and the dimension members of cells. EnableDataAudit metadata attribute is available in Scenario and Account dimensions. Ans: We need to write a rule for it.

What are different ways of running consolidation in HFM? Consolidate- will consolidate only what has changed from the previous execution of consolidation, including the execution of all necessary calculations and currency translations for individual entities the ones that have the impacted status of course Consolidate All- will consolidate everything whether changed or not as if it has never run before.

It will also include in execution entities for which there is no data at all. What is cash flow statement? Essentially, the cash flow statement is concerned with the flow of cash in and out of the business.

What does an income statement contain Rough outline? What does a balance sheet contain? Ans: Yes, we can use historical rate. We can use historical rate to convert some assets to historical value. What is the minimum role to be given to a user to access HFM? Ans: Default or view access. Where do you give roles to user? Ans: In Shared Services. How do we know whether consolidation has been run for a particular entity or not in a particular month?

What are the combinations to enter exchange rates? Ans: From customer 1 and customer 2, there is a system defined member list called currency. So, in customer 1, we are going to have source currency and in customer 2, we have destination currency. Ans: There is no relation between account type and translation. Child entities have data, but there is no data in parent entity? What could be the reason?

Not able to create journals for an entity, what options do you check? Ans: Allow adjs is enabled or not. What are member lists? Have you used any? Ans: A member list can be created and used for a variety of activities: data extracts, data grids and. Member lists enable you to specify a segment of information within a dimension. How to enter it? Ans: Line Item detail are additional information to the data. It is entered in the data file. Can I display line item details in any report?

Ans: No. What are the differences between data grid and data form? Ans: a. We can export the data form to the excel file and import file and we can bring back the changes to the DB.

This is called offline working on data forms. How do you achieve closing process in HFM? Ans: We are going to handle through process management. Where is data stored in HFM?

How do you take backup of HFM applications? Ans: Using copy in utilities. This is available under HFM utilities. We can copy everything except data. How do you migrate HFM application from one environment to another?

How to set dimensions in HFM? Ans: We are not going to set dimensions till We have 12 standard dimensions. How many types of account? Ans: There are 10 account types- Asset, liability, revenue, expense, balance, balance recurring, flow, dynamic, group label, currency rate. What is mean value dimension? Where is the translation done?

Ans: Translations can be done in data grid, data forms and at process management level. What is meant by switchsignflow and swiitchsigntype? Specifies the account type change for FLOW accounts that use these rules:. What is ICP? Ans: The Intercompany dimension represents all intercompany balances that exist for an account.

This is a reserved dimension that is used in combination with the Account dimension and any custom dimension. How to setup ICP? Y means what? N means what? R means what? What is meant by plugaccount? Ans: The plug account specifies the account name used for identifying discrepancies in intercompany transactions. It must be blank or the name of a valid account. If blank, intercompany eliminations for the account are not processed.


Hyperion Financial Management Interview Questions

Free Computer Training..!!! What is HFM? What is Consolidation? Consolidation is aggregating the Base level entities amounts with the Parent level entities amounts..


Top Hyperion Interview Questions And Answers

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. TB First: in the Sample. For example, the value for Qtr1 is the same as the value for Jan. TB Last: in the Sample. For example, the value for Qtr1 is the same as the value for Mar. Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially. Hyperion Planning is a budgeting and forecasting application from Oracle formerly owned by Hyperion Solutions Corporation.


Hyperion Financial Reporting Interview Questions

Some Journals we use repeatedly. So, for that purpose, we will create recurring templates. By using the recurring templates, we will create recurring Journals.. If we create a journal as Auto Reversing Journal, the journal will post in the next period by reversing the Debit and Credit.


HFM Interview Questions and Answers

Are you an expert at handling financial Management? Do you want a job that can fully utilize your skills? Wisdomjobs got the perfect job you are searching for. Hyperion Financial Management jobs are the trending jobs with highest growth rate. Hyperion Financial Management is a Web-based application that utilizes today's most advanced technology to deliver global financial consolidation in a single and highly scalable software solution. Visit our www. Subscribe to our jobs portal to search and find all the latest job notifications that can challenge your skills to the utmost.

Related Articles