{"id":21,"date":"2017-04-08T05:48:56","date_gmt":"2017-04-08T05:48:56","guid":{"rendered":"http:\/\/www.gologica.com\/blog\/?p=21"},"modified":"2025-04-06T02:38:12","modified_gmt":"2025-04-06T02:38:12","slug":"hyperion-financial-reporting-interview-questions","status":"publish","type":"post","link":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/","title":{"rendered":"Hyperion Financial Reporting Interview Questions"},"content":{"rendered":"

What is Oracle Hyperion Financial Management (HFM)?<\/strong><\/p>\n

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\u00a0 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.
\nHyperion Financial Management can be deployed quickly to integrate data from multiple Oracle and non-Oracle transactional\u00a0 systems, provide top-side reporting that conforms to IFRS requirements, and help organizations make the transition to IFRS.
\nWhat is TB First and TB Last?<\/strong><\/p>\n

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\u2019s parent. For example, the value for Qtr1 is the same as the value for Jan.
\nTB 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\u2019s parent. For example, the value for Qtr1 is the same as the value for Mar.<\/p>\n

How is data stored in the Essbase database?<\/strong><\/p>\n

Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.<\/p>\n\n\n\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"Hyperion<\/a><\/p>\n

What is Hyperion Planning?<\/strong><\/p>\n

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.
\nThe 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\u00a0Hyperion reporting tools\u00a0work great with planning.<\/p>\n

What is the need of property sheet?<\/strong><\/p>\n

The property sheet enables you to set various options for the currently selected reports.<\/p>\n

How many data bases are used to connect Hyperion financial reporting studio?<\/strong><\/p>\n

Single data base is used to connect reporting studio.<\/p>\n

Why are dimensions listed on the user POV when changing them has no effect on the grid?<\/strong><\/p>\n

Multiple grids can be included in a report, where one or more of the grids are affected by\u00a0Changes to those dimensions on the user POV.<\/p>\n

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?<\/strong><\/p>\n

Use the CurrentPOV member for the selected axis or choose a member selection function with\u00a0 CurrentPOV as the member parameter. When the report runs, the axis value is taken from the\u00a0 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.<\/p>\n

What are Report Member Selections?<\/strong><\/p>\n

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.<\/p>\n

What are the required components to create grid?<\/strong><\/p>\n

Rows,
\nColumns,
\nPages,
\nPoint of view,
\nData area<\/p>\n

WHAT IS THE MEANING OF A BLOCK LOCKING SYSTEM?<\/strong><\/p>\n

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.<\/p>\n

IS IT POSSIBLE TO HAVE A METAOUTLINE BUILT ON TWO SEPARATE OLAP MODELS?<\/strong><\/p>\n

No, it\u2019s not possible.<\/p>\n

WHAT PARTITIONING OPTIONS DO WE HAVE IN ESSBASE?<\/strong><\/p>\n

The partitioning options are: replicated, transparent and linked.<\/p>\n

EXPLAIN CUSTOM BASED MACRO?<\/strong><\/p>\n

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.<\/p>\n

EXPLAIN DENSE AND SPARSE DIMENSIONS<\/strong><\/p>\n

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.<\/p>\n

What is the difference between switch sign for and switch type for ?<\/strong><\/p>\n

Switch type for:\u00a0It is ticked to change
\nASSET to EXPENSE
\nEXPENSE to ASSET
\nLIABILITY to REVENUE
\nREVENUE to LIABILITY
\nBALANCE to FLOW
\nFLOW to BALANCE
\nSwitch sign for:\u00a0It is ticked to change
\nASSET to LIABILITY
\nLIABILITY to ASSET
\nEXPENSE to REVENUE
\nREVENUE to EXPENSE<\/p>\n

What are the balance types of Journals?\u00a0 Difference between them?<\/strong><\/p>\n

Balanced
\nUn Balanced
\nBalanced by entity
\nBalanced:\u00a0All the Debits and Credits will be balanced
\nUnbalanced:\u00a0Debits and Credits will not be balanced
\nBalanced by entity:\u00a0Debits and Credits for particular entity will be balanced<\/p>\n

Services dependency means?<\/strong><\/p>\n

Hyperion is dependent on services. Means services are to be started in a specified sequence only<\/p>\n

What is HFM ARCHITECTURE?<\/strong><\/p>\n

Hyperion Financial Management is designed to operate as a multi tier system.
\nClient tier:
\nThe 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.
\nWeb tier:
\nThe 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.
\nMiddle tier:
\nThe middle tier contains the domain intelligence and connections to the relational database.
\nDatabase tier:
\nThe data tier contains the relational database and all Hyperion Financial Management data and metadata.<\/p>\n\n\n\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"Hyperion<\/a><\/p>\n

How many types of adjustments we can post.?<\/strong><\/p>\n

In HFM we have:
\nEntity Currency Adjs
\nParent Currency Adjs
\nParent Adjs
\nContribution Adjs<\/p>\n

How many level of security in HFM?<\/strong><\/p>\n

User authentication
\nTask securities
\nDocument securities (Data grids and forms, journals, reports)
\nData security<\/p>\n","protected":false},"excerpt":{"rendered":"

What is Oracle Hyperion Financial Management (HFM)? Oracle Hyperion Financial Management (HFM) is a comprehensive Web-based application that delivers global …<\/p>\n","protected":false},"author":1,"featured_media":2186,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"pmpro_default_level":"","footnotes":""},"categories":[12],"tags":[],"coauthors":[182],"class_list":["post-21","post","type-post","status-publish","format-aside","has-post-thumbnail","hentry","category-oracle_intervew_questions","post_format-post-format-aside","pmpro-has-access","user-has-not-earned"],"yoast_head":"\nHyperion Financial Reporting Interview Questions - GoLogica<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hyperion Financial Reporting Interview Questions - GoLogica\" \/>\n<meta property=\"og:description\" content=\"What is Oracle Hyperion Financial Management (HFM)? Oracle Hyperion Financial Management (HFM) is a comprehensive Web-based application that delivers global …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"GoLogica\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-08T05:48:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-06T02:38:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"175\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62\"},\"headline\":\"Hyperion Financial Reporting Interview Questions\",\"datePublished\":\"2017-04-08T05:48:56+00:00\",\"dateModified\":\"2025-04-06T02:38:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\"},\"wordCount\":1008,\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg\",\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\",\"url\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\",\"name\":\"Hyperion Financial Reporting Interview Questions - GoLogica\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg\",\"datePublished\":\"2017-04-08T05:48:56+00:00\",\"dateModified\":\"2025-04-06T02:38:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg\",\"width\":300,\"height\":175,\"caption\":\"Hyperion Financial Reporting Interview Questions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gologica.com\/elearning\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hyperion Financial Reporting Interview Questions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\",\"url\":\"https:\/\/www.gologica.com\/elearning\/\",\"name\":\"GoLogica\",\"description\":\"E-Learning Portal\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/d0ab308492a1bfcbec1a1ce1637996db\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.gologica.com\/elearning\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hyperion Financial Reporting Interview Questions - GoLogica","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"Hyperion Financial Reporting Interview Questions - GoLogica","og_description":"What is Oracle Hyperion Financial Management (HFM)? Oracle Hyperion Financial Management (HFM) is a comprehensive Web-based application that delivers global …","og_url":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/","og_site_name":"GoLogica","article_published_time":"2017-04-08T05:48:56+00:00","article_modified_time":"2025-04-06T02:38:12+00:00","og_image":[{"width":300,"height":175,"url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#article","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/"},"author":{"name":"admin","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62"},"headline":"Hyperion Financial Reporting Interview Questions","datePublished":"2017-04-08T05:48:56+00:00","dateModified":"2025-04-06T02:38:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/"},"wordCount":1008,"image":{"@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg","articleSection":["Oracle"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/","url":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/","name":"Hyperion Financial Reporting Interview Questions - GoLogica","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg","datePublished":"2017-04-08T05:48:56+00:00","dateModified":"2025-04-06T02:38:12+00:00","author":{"@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62"},"breadcrumb":{"@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#primaryimage","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/Hyperion-Financial-Reporting-Interview-Questions.jpg","width":300,"height":175,"caption":"Hyperion Financial Reporting Interview Questions"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gologica.com\/elearning\/hyperion-financial-reporting-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gologica.com\/elearning\/"},{"@type":"ListItem","position":2,"name":"Hyperion Financial Reporting Interview Questions"}]},{"@type":"WebSite","@id":"https:\/\/www.gologica.com\/elearning\/#website","url":"https:\/\/www.gologica.com\/elearning\/","name":"GoLogica","description":"E-Learning Portal","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/d0ab308492a1bfcbec1a1ce1637996db","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg","caption":"admin"},"url":"https:\/\/www.gologica.com\/elearning\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/21","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/comments?post=21"}],"version-history":[{"count":5,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":6742,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/21\/revisions\/6742"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media\/2186"}],"wp:attachment":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media?parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/categories?post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/tags?post=21"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/coauthors?post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}