financial reporting odtug
DESCRIPTION
Financial Reporting Presentation ODTUGTRANSCRIPT
![Page 1: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/1.jpg)
FINANCIAL REPORTING
![Page 2: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/2.jpg)
AGENDAAGENDA
![Page 3: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/3.jpg)
AGENDA
� Background
� Hyperion Financial Reports
� Hyperion Smartview
� Demo of Key Advanced Concepts
� Questions33
![Page 4: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/4.jpg)
PRACTICE BACKGROUND
� Leader of Oracle Practice, 1st Original Customer of Hyperion Planning
� 1st Customer Migration of OFA to Hyperion
�Member of Oracle Customer Advisory Board�Member of Oracle Customer Advisory Board
�Member of Hyperion SIG
�Member of Oracle Beta Development Team
� Consultant experiences (100’s of Implementation)
� Dozens of Certified Hyperion Consultants
44
![Page 5: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/5.jpg)
INDUSTRY BACKGROUND
� Solutions built around the following industries� Financial Services
� Aerospace and Defense
� Manufacturing
Retail
5
� Retail
� High Tech
� Consumer
� Higher Education
� Healthcare
� Communications
� Hospitality, and Real Estate
5
![Page 6: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/6.jpg)
CURRENT IMPLEMENTATIONS
� Oracle 11.1.1 Retail Application-Multiple
Apps
� Oracle 9.3.1 Multiple Implementations
A&D
6
� A&D
� Financial Services
� Government
6
![Page 7: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/7.jpg)
UNDERSTANDING YOUR REPORTING NEEDSUNDERSTANDING YOUR REPORTING NEEDS
![Page 8: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/8.jpg)
REPORTING AUDIENCE
� Read Only Viewers of the Data
� Integration with Office
� Ad-Hoc Analysis/Pivot Tables
� Dashboard Like Feel
� Provide variances to the Data
8
![Page 9: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/9.jpg)
DATA SOURCES FOR REPORTINGDATA SOURCES FOR REPORTING
![Page 10: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/10.jpg)
DATA SOURCE FOR REPORTING
� Relational
� Essbase
� Planning
� Hyperion Financial Management
10
![Page 11: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/11.jpg)
REPORTING TOOLSREPORTING TOOLS
![Page 12: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/12.jpg)
REPORTING TOOLS
� Financial Reports
� SmartView
� Web Analysis
� Interactive Reporting
� Answers +
� OBIEE Dashboards
12
![Page 13: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/13.jpg)
FINANCIAL REPORTSFINANCIAL REPORTS
![Page 14: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/14.jpg)
FINANCIAL REPORTS
� Advantages� Highly formatted reports
� Distribution of Reports
� SnapshotsSnapshots
� Scheduling
� Cell Text and Supporting Detail
� Data Integrity
� Workspace Integration
� Multiple output methods
� Annotations
14
![Page 15: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/15.jpg)
FINANCIAL REPORTS
� Disadvantages� Report Client
� Limited Ad-Hoc Analysis
� Performance� Performance
� Prompts
� No Relational Reporting
15
![Page 16: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/16.jpg)
REPORT KEY DESIGN PRINCIPLES
� Point of View, prompts by user
� Batches, Scheduling monthly books
� Snapshots, be careful with security
Create a Standard Set 30 to 50 Reports� Create a Standard Set 30 to 50 Reports
� Disable Access for Certain Report during critical process times
� Create ASO Model for Archiving and Report Distribution
16
![Page 17: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/17.jpg)
FINANCIAL REPORT-FORMULAS
� Report Formulas vs. Essbase Formulas
� Column Formulas
� Row Formulas
![Page 18: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/18.jpg)
FINANCIAL REPORTS-TEXT
�Cell Text
�Supporting Detail
�Annotations
�Planning Annotations
![Page 19: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/19.jpg)
FINANCIAL REPORT-BOOKS
� Concept of Books
� Report Books
� Snapshot Books
![Page 20: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/20.jpg)
SNAPSHOTS
� Concept of Snapshots
� Snapshot Books
� Snapshots
![Page 21: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/21.jpg)
SECURITY
� Reports Security
� Books Security
� Snapshot Security
![Page 22: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/22.jpg)
SMARTVIEW INTEGRATION
� Datasources
� Importing Documents
� Refreshing Documents
� Leveraging Ad-Hoc
![Page 23: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/23.jpg)
FINANCIAL REPORTING 11.1.1
�Copy and paste repository items
�Apply improved search options
�Set permissions for multiple repository items
Apply folder permissions to children�Apply folder permissions to children
�Support Adobe Distiller 8 for PDF generation
�Add external content to books
�Add and manage annotations in reports
![Page 24: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/24.jpg)
COPY & PASTE
� You can copy repository items from one folder
to the same folder or to another folder.
� With this feature, you save time by duplicating
and then modifying similar reportsand then modifying similar reports
![Page 25: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/25.jpg)
SEARCH OPTIONS
� With these improved search options, you save
time when searching for repository items.
� You initiate a search in the Search box.
� You can use the * and ? wildcards in the � You can use the * and ? wildcards in the
Search box.
� The search is not case-sensitive.
![Page 26: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/26.jpg)
REPOSITORY PERMISSION
� You can select multiple repository items and
define their permissions.
� With this feature, you save time by managing
many items at one time.many items at one time.
� You can define folder permissions that apply to
all items created in the folder.
� This feature saves you time by assigning
permissions to items when you create them.
![Page 27: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/27.jpg)
EXTERNAL CONTENT IN BOOKS
� Microsoft Word (DOC and RTF)
� Microsoft Excel (XLS)
� Microsoft PowerPoint (PPT and PPS)
Adobe Acrobat (PDF)� Adobe Acrobat (PDF)
� Text files (TXT)
� You must import the documents into the
repository before you can insert them into
books.
![Page 28: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/28.jpg)
ANNOTATIONS
� Threaded Annotations
� Attach Documents
� Footnotes
Printing� Printing
� Source Intersection of Annotations
![Page 29: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/29.jpg)
CAPITAL DETAIL
29
![Page 30: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/30.jpg)
INCOME STATEMENT
30
![Page 31: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/31.jpg)
EMPLOYEE STATUS REPORT
31
![Page 32: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/32.jpg)
SMARTVIEWSMARTVIEW
![Page 33: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/33.jpg)
HYPERION SMARTVIEW ADHOC
� Advantages� Excel Like Functionality
� Pivot Tables
� Formatting/Conditional Formatting� Formatting/Conditional Formatting
� Point of View
� Distribute to excel users
� Smart Slices
� Report Designer
33
![Page 34: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/34.jpg)
HYPERION SMARTVIEW ADHOC
� Dis-advantages� Data Integrity
� Dimensional Model Knowledge
� Training� Training
� Reliance on Excel
34
![Page 35: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/35.jpg)
AD-HOC LAYOUT SAMPLE
35
![Page 36: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/36.jpg)
OFFICE INTEGRATION
� Tools� Financial Reports
� Web Analysis
� Interactive Reporting� Interactive Reporting
� Ability to Update Documents
36
![Page 37: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/37.jpg)
SMARTVIEW 11.1.1
� Architecture and Data Source Support
� Data Source Security
� Smart slices
� Report Designer� Report Designer
� Other Enhancements
![Page 38: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/38.jpg)
WORKSPACE
� Integrate all financial documents
� Create Department Folders
� Create Excel Ad-Hoc models� Create Excel Ad-Hoc models
� Create Dashboard for both KPI’s Metrics and
Ad-Hoc Analysis (Standard, and Ad-Hoc)
38
![Page 39: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/39.jpg)
OFFICE IMPORT EXAMPLE
39
![Page 40: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/40.jpg)
WHAT TOOL TO USE AND WHEN?
� Financial Reporting Deck-HFR
� Smartview Word and Powerpoint-Integrate Financial Documents
� Ad Hoc Analysis-Smartview and WA� Ad Hoc Analysis-Smartview and WA
� Simple Dashboards-WA
40
![Page 41: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/41.jpg)
DEMODEMO
![Page 42: Financial Reporting Odtug](https://reader034.vdocuments.us/reader034/viewer/2022051314/54c0e63d4a795978508b456f/html5/thumbnails/42.jpg)
QUESTIONS AND CONTACT
Email: [email protected]
Cell: 949-235-4285
Website: www.linium.com
Linked In Oracle Group: Linium Oracle Practice
Linium Oracle Practice