Collaborate 19: Help!! EPRCS, Financial Reports, Smart View, Which Report Tool Do I Use 10801 notes

Please download to get full document.

View again

of 55
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Similar Documents
Information Report
Category:

Data & Analytics

Published:

Views: 0 | Pages: 55

Extension: PDF | Download: 0

Share
Description
1. Session ID: Prepared by: Remember to complete your evaluation for this session within the app! 10801 HELP!! EPRC, Financial Reports, Smart View Which Report Tool Do I…
Transcript
  • 1. Session ID: Prepared by: Remember to complete your evaluation for this session within the app! 10801 HELP!! EPRC, Financial Reports, Smart View Which Report Tool Do I Use? April 11, 2019 Kelliann Hoelscher EPM Practice Director Metaformers
  • 2. Agenda • Introduction • Reporting Overview • Reporting Options in Detail • Summary • Q&A
  • 3. EPM Practice Director, Metaformers 15+ years Experience with Oracle EPM 35+ Full Life Cycle EPM Projects Industries include Public Sector, Commercial, Higher Ed, Retail, Manufacturing, High Tech Oracle EPBCS, PBCS, EPRC, HFM, FCC, Essbase, On-Premise Planning and Budgeting EPBCS Certified PMI-ACP Certified Kelliann Hoelscher, PMI-ACP
  • 4. Strategy & Transformation Assessments Implementations Upgrades Optimization Cloud Services Oracle ERP Oracle HCM Oracle EPM On-Premise Solutions PeopleSoft Hyperion IT & Application Managed Services
  • 5. Goals • Learn the basics of Financial Reporting (FR), Smart View, and Enterprise Performance Reporting Cloud Service (EPRC) functionality • Understand the differences between FR, Smart View, and EPRC • Learn how to choose the best reporting tool for the report type required • Discuss and show specific examples of real world reporting use cases and the results • Review a “Quick Guide” on what reporting tool to select and when
  • 6. Reporting Overview
  • 7. Questions to Answer • What is the purpose of the report? • Who is the audience of the report? • Is this a one-time, ad hoc report or an ongoing report? • If an ongoing report, is the format static or changing frequently? • Do you plan to print the report or just view online? • Is this report stand alone or part of a reporting package? • Does the report require reviews, changes and approvals by multiple resources?
  • 8. Reporting Tools for Oracle EPM Applications Smart View Financial Reporting Enterprise Performance Reporting Cloud Service (EPRC)
  • 9. Smart View
  • 10. Smart View • Is a comprehensive tool that enables formula-based data retrieval by providing a link from MS Office applications to Oracle EPM Products and Business Intelligence (BI) • Can use the Excel environment to interactively investigate the data contained in the source(s) • May start with templates to begin the process • Used to report on data from the following Oracle EPM applications: – PBCS, EPBCS – Oracle Hyperion Planning On-Premise – HFM, FCCS – Oracle Hyperion Essbase (Cloud and On-Premise) – Profitability and Cost Management Cloud – Tax Reporting Cloud
  • 11. Smart View: Best Used When Reports Are ___ • Ad-hoc • Format changes frequently • One-time analysis needed • Need formatting in Excel not available in FR Web Studio • Need to bring in data from multiple Oracle EPM and/or BI applications
  • 12. Smart View: Advantages • Excel users more comfortable with available functionality • Can be used with MS Excel, Word and PowerPoint • All of the formatting and functions of Excel are available for use • Format is easily changed • Able to incorporate data still housed in spreadsheet and workbook-based models with data from the source(s) • Comprehensive VBA toolkit for developing custom Office-based analytic interfaces • Offers unmatched flexibility with Excel
  • 13. Smart View: Disadvantages • More difficult to create the initial report due to very open structure requirements • Increased risk for errors • Requires advanced knowledge of the application and data (unless a template is created by a Super User with limited distributions/use and instructions) • Requires maintenance with “fixed member selection"
  • 14. Smart View in Excel: Sample Ad Hoc - Start • Open Excel with the Smart View, Shared Connections, Application/Database and select Ad hoc analysis at the bottom of the Panel
  • 15. Smart View: Sample Report - Options Box • Basis of all Ad Hoc Queries
  • 16. Smart View: Sample Report - Fully Formatted FR Export
  • 17. Smart View: Sample Report - Query-Ready FR Export
  • 18. Financial Reporting
  • 19. Financial Reporting: Overview • Used to create book-quality financial reports • Can be shown in a wide variety of formats for a range of audiences • A graphical, object-based interface enables the rapid creation of reports • Combines grids of data, text, charts, graphs, and images. Used to report on data from the following Oracle EPM applications: – Enterprise Planning and Budgeting Cloud (EPBC) Planning and Budgeting Cloud (PBC) – Financial Consolidation and Close Cloud (FCC) – Profitability and Cost Management Cloud – Tax Reporting Cloud – Hyperion Financial Management (HFM) – Hyperion Planning On-Premise
  • 20. Financial Reporting: Best Used When Reports Are ___ • Highly formatted • Mostly a static format (not necessarily a “static report”) • Need to be printed • Need to be viewed in HTML or PDF • Need to be sent to non-users • To be combined into a Book (can have a Table of Contents) • To be scheduled to run as a Batch (Book or Report)
  • 21. Financial Reporting: Advantages • If written dynamically, limited maintenance required • A library of reusable report components simplifies and streamlines the process of building and maintaining complex reports • Options to build Reports with Expansion capabilities/drill-down • Allows creation of User Prompts for dynamic report use • Can overwrite/replace member names in report with other text (no “cell links”) • Parts of a report can be saved as a “template object” and reuse (Examples: Title Text box, Column Headers across a report) • Conditional Formatting is available • Can be opened in Smart View as a report or as the basis for an ad hoc sheet
  • 22. Financial Reporting: Disadvantages • Takes longer to create until a larger library is established • Steeper learning curve • It is NOT Excel
  • 23. Financial Reporting: Web Studio • Original Financial Reporting Studio was a desktop client installation • The new web version is fully on the web with no installation required • Web Studio is available for version 11.1.2.4.704 and later for On-Premise and since March 2016 for Cloud • Installed version can still be used for now for clients purchasing EPM software prior to August 2018 (Version 18.08) when the installer was removed • Oracle documentation says the installed version “Existing installations of the Financial Reporting Desktop Studio and command line utilities will no longer work with Financial Reporting starting with the 18.09 update.” • Reports in the original Studio can be opened and modified in the Web version (no migration required) and vice versa • Same base functionality but several navigation differences
  • 24. Financial Reporting: Web Studio vs. Installed Version • Object Browser box is biggest difference • Must be on the correct object in the Browser box to make any edits • Biggest issue: unable to have multiple reports open at the same time
  • 25. Financial Reporting: Sample Report • Can be accessed by: – EPM Workspace from the menu, under Tools, select Launch Reporting Web Studio
  • 26. Financial Reporting: Sample Report • Can be accessed by: – e/PBCS Simplified Interface, Navigator, under Reporting, select Reporting Web Studio
  • 27. Financial Reporting: Sample Report Behind the Scenes Web Studio
  • 28. Financial Reporting: Sample Report Behind the Scenes Web Studio (cont.) • When a specific line is selected in the Object Box, the Edit Panel changes
  • 29. Financial Reporting: PDF Sample
  • 30. Financial Reporting: HTML Sample
  • 31. Financial Reporting: Sample Book TOC
  • 32. Smart View FR in Excel: Sample Report in Excel • Reports can be opened in Excel with Smart View (installed) • Open Excel/Smart View add-in already installed, open the Panel and select “Document Contents” (URL must already be set up), log in • A copy of the Explorer folders and reports will appear
  • 33. Smart View FR: Sample Report - Options Box There is an Option Box to select how to import the Report:
  • 34. Smart View FR: Sample Report - Fully Formatted
  • 35. Smart View FR: Sample Report - Query-Ready
  • 36. Smart View FR: – Sample Report - Query-Ready (cont.)
  • 37. EPRC
  • 38. EPRC: Overview • EPRC is a secure, collaborative, and process driven service for defining, authoring, reviewing, and publishing financial, management, and regulatory report packages for internal and/or external stakeholders. • Debuted in December 2016 • Purpose-built solution which combines financial statements, data, and narrative reporting into a stylized Report Package • Reporting deliverable owners can easily manage and monitor the progress of contributors throughout the reporting lifecycle • Users can access via the web or Microsoft Office • One application within the Oracle EPM cloud suite of products
  • 39. EPRC: Functionality Diagram Provided by Oracle
  • 40. EPRC: Best Used When Reports ____ • Are static in layout and highly formatted • Include narrative reporting • Require collaboration among numerous people such as workflow and status tracking • Must be in specific regulatory formats such as XBRL, SEC EDGAR HTML, or PDF • Require compilation of data from multiple sources, Oracle and/or non-Oracle • Need to include Oracle On-premise, Oracle Cloud, MS Excel/Word, PowerPoint or more in the report package • Must have report content embedded into report packages
  • 41. EPRC: Advantages • Able to compile data from a wide range of applications/sources • Improves data integrity through the use check in/out access permissions and version control • Leverages Essbase functionality in the cloud by obtaining hierarchical and dimensional analysis on financial data • Easy to rollover and reuse content from past periods with centralized maintenance of common dates, text, and data. • Users are notified when tasks are due/important reporting deadlines need to be met • Mobile accessibility is available
  • 42. EPRC: Advantages (cont.) • Contains the Oracle Disclosure Management Option for producing regulatory filings such as XBRL, iXBRL and SEC EDGAR • Integration with Oracle Smart View for Office • Multi-dimensional engine to (optionally) store data in the cloud for Report Packages and powerful analytics via Oracle Smart View for Office • Optional Disclosure Management • XBRL Taxonomy management, editing, and viewing which enables companies to customize their filings for their financial needs
  • 43. EPRC: Disadvantages • Requires a separate license • There is a learning curve, but easy to learn independently • Does not provide rich and interactive data visualizations or dashboards • Management Reporting has not quite achieved full parity with FR, yet
  • 44. EPRC: Workspace Home Page
  • 45. EPRC: Core Components Provides a secure, collaborative,& process driven approach for defining, authoring, reviewing and publishing financial & management reports. Report Packages Native reporting solution for creating cross-cloud financial/managerial reports against EPM cloud, ERP, & Essbase sources Management Reporting Purpose built module to centralize & manage documents needed in the close cycle & assemble financial statements with support for regulatory reporting Disclosure Management Stand alone Essbase Application with up to 5 databases for compilation of data not available from other systems EPRC Direct Application
  • 46. EPRC: Report Packages • Report Package Functionality includes: Full lifecycle support from definition through publishing and phase management; Report Center, Authoring, Review, Distribution, Commenting Framework, Monitoring; Dynamic security, integrated workflow, doclet management, auditing • The Report Package provides the ability for an Admin to: – Control, monitor and engage in a step-by-step process in a report cycle – Assign tasks, due dates, Owners, Signers and Viewers to a singular or multiple sections – Allow/provide commentary through each phase of the package’s development • Report Packages are broken down into 3 phases: – Author Phase: The Admin can grant access/limit a user’s ability to interact within the Reporting Package by controlling which users have access to specific sections/documents within the Reporting Package. – Review Phase: The Admin assigns a user the ability to review specific documents within a constructed timeline. – Sign Off Phase: Enables an Admin to “lock-down” the Reporting Package content and attain a finalized sign off.
  • 47. EPRC: Management Reporting Sources Diagram Provided by Oracle
  • 48. MR vs. FR: What does FR Have that MR Doesn’t • Oracle hopes to have full parity between MR and FR soon • In Feb. 2019 Oracle added to MR: – The ability to import MR Grids into Smart View – A migration tool to migrate FR reports to MR • As of Feb. 2019 (when this presentation was written), the following FR functionality was not available in MR: – Expected later this year: Batches and Bursting – Major Items with Timing TBD: • Export to Office • Only grid objects can be hidden in MR • Auto Calculations • Annotations and Planning Unit Annotations – No update or change expected • Multiple data sources in a single grid (has a workaround)
  • 49. MR vs. FR: What does FR Have that MR Doesn’t (cont.) NOTE: For a full list of differences, see Oracle documentation at: https://docs.oracle.com/en/cloud/saas/enterprise-performance-reporting- cloud/dmepr/diff_fr_mr_100x0d702939.html#GUID-293A9209-306B-4127-ACAF- DFE9DA352017
  • 50. EPRC: Sample Report • Can be accessed by: – In EPRC Workspace, select Library and click on the report to run
  • 51. Summary
  • 52. Quick Guide to Oracle EPM Reporting • Ask and answer the correct questions • Determine the best tool for the job: Smart View, FR, or EPRC • Gather required specifications • Build the report • Test the report • Document the report: backup build, run frequency, maintenance, variables, security) • Make the report available to the assigned audience by placing in a common folder with correct security (if needed) • Maintain/update as needed NOTE: Report is not “permanently” set in the original reporting tool.
  • 53. Summary Attendees should now understand: • The differences between – Smart View – Financial Reporting (FR) – Enterprise Performance Reporting Cloud (EPRC) • Which reporting tool to use based on the report type required • The functionality basics of each tool • Details/differences of the EPRC components: – Report Packages – Management Reporting (MR) – Disclosure Management – EPRC Direct Application
  • 54. Other Prior Metaformers’ Sessions “Under the Covers of EPRC” Session: 11318 Kelliann Hoelscher Sunday, April 7, 2019 1:45 AM - 2:45 PM “Preparing Your Organization for a Successful Migration to the SaaS Cloud” Session: 105160 Jay Miller Tuesday, April 9, 2019 2:00 PM - 3:00 PM “Moving PeopleSoft to the Oracle Cloud - a City’s Experience” Session: 109590 Andrew Beck Wednesday, April 10, 2019 8:00 AM - 9:00 AM
  • 55. Session ID: Remember to complete your evaluation for this session within the app! 10801 Kelliann.Hoelscher@Metaformers.com
  • Recommended
    View more...
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x