An Introduction To Hyperion Financial Management

Amit SharmaHyperion/OBIEE TrainerLearnhyperion.wordpress.com

Agenda :

Fundamentals of Financial ConsolidationDescribe the features of Financial ManagementDescribe the Hyperion products bundled with Financial ManagementDescribe the product architectureDescribe related Hyperion products

Hyperion Financial Management

Hyperion Financial Management is a financial consolidation and reporting application built with advanced Web technology, but used and maintained by the finance team. It provides financial managers the ability to rapidly close and report financial results, meet global regulatory requirements, reduce the cost of compliance and deliver confidence in the numbers.

What is Financial ConsolidationFinancial Consolidation [ The Merger of Two Enterprises ] : The combined financial statements of a parent company and its subsidiaries.or Because consolidated financial statements present an aggregated look at the financial position of a parent and its subsidiaries, they enable you to gauge the overall health of an entire group of companies as opposed to one company's stand alone position. Consolidating financial data from diverse locations and across multiple general ledgers, performing multi-currency conversions, untangling outmoded spreadsheet based data collection processes, incorporating changes from reorganizations, mergers, and acquisitions. Business IntelligenceIn another accounting context, financial consolidation refers to various processes that will streamline the internal financial reporting of a single company

When do we need Financial Consolidation : Consolidated financial statements are required when there are two or more affiliated companies. When a parent company either directly or indirectly controls a majority interest of a subsidiary, consolidated financial statements must be presented. (Cash flows, and financial position of the combined entity) When one company acquires another company, a consolidated balance sheet needs to be prepared. The first step is to eliminate the effects of any inter-company transactions.

Consolidate data quickly from multiple general ledgers and multiple charts of account? Consolidate data from various business perspectives and by multiple structure versions (this year, last year, proposed)? Support local and multiple base currency reporting? Report on the impact of currency fluctuations (actual, forecast and budget rates)?

The problems - consolidating financial data from diverse locations and across multiple general ledgers, performing multi-currency conversions, and untangling outdated spreadsheet based data collection processes, incorporating changes from reorganizations, mergers, and acquisitions.

Financial Data Quality Management :Financial consolidation solutions can meet this challenge by streamlining data collection and integration from multiple sources, making the monthly close faster and more efficient while turning disparate data into useful, business critical information.

Financial Consolidation typesThe Consolidation Module enables the user to generate the following ConsolidatedFinancial Statements: Consolidated Balance Sheet A balance sheet in which assets and liabilities of a parent company and its controlled subsidiaries are combined, thereby presenting balance sheet items for the parent and its subsidiaries as if they were a single firm. Consolidated Trial Balance

Consolidated Profit & Loss Statement

Spreadsheets When the spreadsheet approach is used, spreadsheet templates are created by central headquarters and e-mailed to remote locations. Then, on a monthly or quarterly basis, these spreadsheets are updated and e-mailed back to central headquarters, where they are consolidated into a master spreadsheetusually with complex macros. The only advantage of this approach is low cost because there is no software or hardware to buy. Everyone in the organization already has e-mail access and a spreadsheet application on the desktop.

Financial Consolidation, Reporting, and Analysis Financial Management enables highly efficient collection and consolidation of data from diverse sources. It includes these features: Process management for tight control of the review and approval process Data validation Currency translation to support multiple local currencies Automatic eliminations for intercompany transactions

Financial Management is designed for large-scale, centralized Web deployment. You can use Financial Management to consolidate data from diverse general ledger systems and locations around the globe.

KEY FEATURESGlobal consolidation features Scalable web architecture Smart dimensionality Complete audit trails Powerful reporting and analysis tools Robust data integration FDQM

Financial ComplianceIn Sarbanes Oxley 404 scenario, it is important to keep some things in mind which help in the overall controls in the financial closing process.

1. Has the management documented the entire financial closing process in sufficient detail from data collection to final report making. 2. Have control activities been documented which define the controls realting to the financial closure process. 3. Has a risk assessment been conducted to assess the inherent risks in the closure processs.4 How and by whom is the financial closure process monitored. How is completeness of the process determined.5. How are communication procedures defined which ensure a smooth financial closure in a timely manner.The users of a companys financial statements investors, lenders, and managementwish to see accurate results from the latest reporting period as soon as possible

HFM Lifecycle OverviewServerCalculateAdjust dataTranslate & ConsolidateLock dataApprove dataLoad & Add dataRun & Publish Reports

Financial ManagementWhat are the challenges we are facing?An increasing desire to have continuous, comprehensive planning and reportingThe challenges/struggles of making (external) GAAP-based financial reporting mesh with (internal) fund accounting-based reportingThe systems we have/are putting in are not all that conducive to this type of reporting (for fund accounting, for higher education)

Financial ManagementFinancial Management comes bundled with three products that extend its capabilities:Financial Reporting is a reporting and charting tool for Web or print distribution of financial reports.Smart View for Office is a spreadsheet add-in based on Excel for reporting and analysis. Shared Services enables user provisioning and sharing of metadata and data among Financial Management applications or between Financial Management and other products.

Management, legal, and tax reporting Complex currency translations Intercompany and minority interest eliminations Complete audit trails Journal adjustments Multidimensional analysis Cash flow reporting Extensible Business Reporting Language (XBRL) reporting HFM Artifacts

HyperionStrategic FinanceHyperionFinancialManagementHyperionPlanningAutomatedDataIntegrationBetween the SystemsUsing Hyperion Tools to IntegrateDetailed BudgetingStrategic ModelingFinancial ReportingDistributed and Customizable Modeling; Real-time AccessDifferent Levels of Data Detail as Relevant to the Different Needs

In Next Session Well LearnApplication Fundamentals.Types of Application\ Classic Application and EPM ApplicationCreating Application

THANK YOU

To learn more about hyperion please visithttp://learnhyperion.wordpress.com

ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication Prohibitedssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication Prohibitedssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedHyperion Financial Management use a muti-tier architecture that includes a client tier, and application tier and a data tier.The client tier contains the user interface. It communicates with the application tier. The primary function of this tier is to display, enter and maintain data and maintain metadata.The application tier contains the application as well as the report and web servers. The Web server lets you access the Web-architected portions of Hyperion Financial Management. The application server contains the financial intelligence and connections to the relational database and OLAP engine.The data tier contains the relational database for all Hyperion Financial Management application data and source data.

Hyperion Financial Management is designed to operate as a multitier system.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.On the Web server tier, you can access the Web-enabled portions of Hyperion Financial Management. The middle tier contains the domain intelligence and connections to the relational database.The data tier contains the relational database and all Hyperion Financial Management data and metadata.

ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 3: Bullet Slide FormatUse for headlines that require one or two lines of text.Body text and/or inserted graphics should not cover the top and bottom color bars framing the slide.Insert session number and title of presentation in lower left-hand corner of the slide by going to View > Header and Footer, then input appropriate information.If an additional logo is needed, please go to View > Master > Slide Master and remove the logo placeholder and position your logo in the lower right-hand corner of the slide.If an additional logo is not needed, please go to View > Master > Slide Master and remove the logo placeholder in the lower right-hand corner of the slide.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedHyperion Financial Management is designed for large-scale, centralized Web deployment..You can use Hyperion Financial Management to consolidate data from diverse general ledger systems and locations around the globe.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication Prohibitedssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedHyperion Financial Management is designed for large-scale, centralized Web deployment..You can use Hyperion Financial Management to consolidate data from diverse general ledger systems and locations around the globe.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication Prohibitedssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 2: Presentation GuidelinesPowerPoint presentations must be in English.Limit the amount of information on each slide for optimum legibility.Include only as many slides as is reasonable to present in a 50-minute period (allowing 10 minutes for Q&A).When editing the PPT template, click on normal view instead of slide view or slide sorter view.All Hyperion products and names must be spelled out entirely in titles, bullet text, and text in graphics. Examples: Use Hyperion Financial Management and Hyperion Performance Suite, Do not use abbreviations such as HFM and HPS. Use Hyperion Planning and Hyperion Business Modeling, not Planning and Business Modeling.If you are using an existing presentation, you must apply the Solutions 2006 template and color scheme.Each presentation cannot exceed 8 MB. (If your companys e-mail size restrictions are smaller, please abide by that file size restriction.) If you are submitting more than one presentation, please send each presentation in a separate e-mail.Delete any unused sample slides provided in the template before submitting your final presentation.Check each slide for spelling and grammar.Before you submit your presentation, rename the PPT file to include the 5-digit session number and primary presenters name. Example: 9999A John Doe.ppt. Use the same file name in the subject line of your e-mail when you submit your presentation.Only submit complete and final presentations. Send to solutions2006ppt@hyperion.com.All presentations are due by March 8, 2006. Hyperion reserves the right to cancel sessions if presentations are not received by this deadline.Hyperion will review all presentations and reserves the right to edit them. Hyperion will notify you if changes are made.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 2: Presentation GuidelinesPowerPoint presentations must be in English.Limit the amount of information on each slide for optimum legibility.Include only as many slides as is reasonable to present in a 50-minute period (allowing 10 minutes for Q&A).When editing the PPT template, click on normal view instead of slide view or slide sorter view.All Hyperion products and names must be spelled out entirely in titles, bullet text, and text in graphics. Examples: Use Hyperion Financial Management and Hyperion Performance Suite, Do not use abbreviations such as HFM and HPS. Use Hyperion Planning and Hyperion Business Modeling, not Planning and Business Modeling.If you are using an existing presentation, you must apply the Solutions 2006 template and color scheme.Each presentation cannot exceed 8 MB. (If your companys e-mail size restrictions are smaller, please abide by that file size restriction.) If you are submitting more than one presentation, please send each presentation in a separate e-mail.Delete any unused sample slides provided in the template before submitting your final presentation.Check each slide for spelling and grammar.Before you submit your presentation, rename the PPT file to include the 5-digit session number and primary presenters name. Example: 9999A John Doe.ppt. Use the same file name in the subject line of your e-mail when you submit your presentation.Only submit complete and final presentations. Send to solutions2006ppt@hyperion.com.All presentations are due by March 8, 2006. Hyperion reserves the right to cancel sessions if presentations are not received by this deadline.Hyperion will review all presentations and reserves the right to edit them. Hyperion will notify you if changes are made.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 2: Presentation GuidelinesPowerPoint presentations must be in English.Limit the amount of information on each slide for optimum legibility.Include only as many slides as is reasonable to present in a 50-minute period (allowing 10 minutes for Q&A).When editing the PPT template, click on normal view instead of slide view or slide sorter view.All Hyperion products and names must be spelled out entirely in titles, bullet text, and text in graphics. Examples: Use Hyperion Financial Management and Hyperion Performance Suite, Do not use abbreviations such as HFM and HPS. Use Hyperion Planning and Hyperion Business Modeling, not Planning and Business Modeling.If you are using an existing presentation, you must apply the Solutions 2006 template and color scheme.Each presentation cannot exceed 8 MB. (If your companys e-mail size restrictions are smaller, please abide by that file size restriction.) If you are submitting more than one presentation, please send each presentation in a separate e-mail.Delete any unused sample slides provided in the template before submitting your final presentation.Check each slide for spelling and grammar.Before you submit your presentation, rename the PPT file to include the 5-digit session number and primary presenters name. Example: 9999A John Doe.ppt. Use the same file name in the subject line of your e-mail when you submit your presentation.Only submit complete and final presentations. Send to solutions2006ppt@hyperion.com.All presentations are due by March 8, 2006. Hyperion reserves the right to cancel sessions if presentations are not received by this deadline.Hyperion will review all presentations and reserves the right to edit them. Hyperion will notify you if changes are made.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 2: Presentation GuidelinesPowerPoint presentations must be in English.Limit the amount of information on each slide for optimum legibility.Include only as many slides as is reasonable to present in a 50-minute period (allowing 10 minutes for Q&A).When editing the PPT template, click on normal view instead of slide view or slide sorter view.All Hyperion products and names must be spelled out entirely in titles, bullet text, and text in graphics. Examples: Use Hyperion Financial Management and Hyperion Performance Suite, Do not use abbreviations such as HFM and HPS. Use Hyperion Planning and Hyperion Business Modeling, not Planning and Business Modeling.If you are using an existing presentation, you must apply the Solutions 2006 template and color scheme.Each presentation cannot exceed 8 MB. (If your companys e-mail size restrictions are smaller, please abide by that file size restriction.) If you are submitting more than one presentation, please send each presentation in a separate e-mail.Delete any unused sample slides provided in the template before submitting your final presentation.Check each slide for spelling and grammar.Before you submit your presentation, rename the PPT file to include the 5-digit session number and primary presenters name. Example: 9999A John Doe.ppt. Use the same file name in the subject line of your e-mail when you submit your presentation.Only submit complete and final presentations. Send to solutions2006ppt@hyperion.com.All presentations are due by March 8, 2006. Hyperion reserves the right to cancel sessions if presentations are not received by this deadline.Hyperion will review all presentations and reserves the right to edit them. Hyperion will notify you if changes are made.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 3: Bullet Slide FormatUse for headlines that require one or two lines of text.Body text and/or inserted graphics should not cover the top and bottom color bars framing the slide.Insert session number and title of presentation in lower left-hand corner of the slide by going to View > Header and Footer, then input appropriate information.If an additional logo is needed, please go to View > Master > Slide Master and remove the logo placeholder and position your logo in the lower right-hand corner of the slide.If an additional logo is not needed, please go to View > Master > Slide Master and remove the logo placeholder in the lower right-hand corner of the slide.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedHyperion Financial Management use a muti-tier architecture that includes a client tier, and application tier and a data tier.The client tier contains the user interface. It communicates with the application tier. The primary function of this tier is to display, enter and maintain data and maintain metadata.The application tier contains the application as well as the report and web servers. The Web server lets you access the Web-architected portions of Hyperion Financial Management. The application server contains the financial intelligence and connections to the relational database and OLAP engine.The data tier contains the relational database for all Hyperion Financial Management application data and source data.

Hyperion Financial Management is designed to operate as a multitier system.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.On the Web server tier, you can access the Web-enabled portions of Hyperion Financial Management. The middle tier contains the domain intelligence and connections to the relational database.The data tier contains the relational database and all Hyperion Financial Management data and metadata.

ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication ProhibitedSlide 5: Quote SlideInsert quote inside the quote marks.Place attributions in lower right-hand side of the slide.ssmailto : aloo_a2@yahoo.com for all Hyperion video tutorial/Training/Certification/MaterialCopyright 2008 Adaequare Inc.All Rights Reserved. Unauthorized Duplication Prohibited