Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2)
Duration : 2 Days (16 Hours)
Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2) Course Overview:
The certification signifies expertise in utilizing Hyperion Financial Reporting (11.1.2) to produce advanced reports. The tool retrieves data from Essbase, a multi-dimensional database system. Industries employ this certification to validate adeptness in report creation, user preference management, and batch scheduling. It’s especially valuable for financial forecasting, budgeting, and delivering financial and management reports. Certified professionals adeptly employ features like conditional suppression, automatic text functions, and linked content for dynamic reports. Industries leverage this certification to bolster reporting, analysis, planning, and forecasting capabilities.
Intended Audience:
• Finance professionals dealing with reporting tasks
• IT professionals managing financial data systems
• Database engineers in charge of data management
• Team leaders responsible for financial planning and budgeting
• Tech-savvy business owners for detailed performance analysis
• Business Analysts seeking advanced report generation
• Oracle EPM system admins.
Learning Objectives of Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2):
The Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning course is structured to achieve key learning objectives. Participants will acquire in-depth expertise in creating and overseeing reports through the Financial Reporting Studio. The course imparts skills in report design, managing metadata data sources, and crafting or modifying grids, text boxes, charts, and other elements. Participants will also develop a comprehensive grasp of dimensionality, data sources, and objects. Moreover, they will explore functionalities like scheduling batches, snapshotting reports and books. The course aims to enable proficient utilization of security features and effective navigation of the Workspace user interface.
Module 1: Financial Reporting Overview
- Oracle’s Enterprise Performance Management System
- Financial Reporting Functionality and Architecture
- Financial Reporting Data Sources
Module 2: Navigating Reports in EPM Workspace
- Navigating EPM Workspace
- Previewing Reports and Snapshots
- Setting Preferences
- Integrating Reports into Microsoft Office Applications
Module 3: Creating Basic Reports
- Reporting Studio Overview
- Report Creation Overview
- Creating Reports
- Adding Grids
- Selecting Members for Grids
- Setting the Point of View
- Adding Rows or Columns
- Saving, Previewing, and Printing Reports
Module 4: Applying Advanced Member Selections
- Selecting Members by Using Lists
- Creating User-Defined Lists
- Selecting Members by Using Functions
- Selecting Members for the Page Axis
Module 5: Customizing Grids
- Displaying Details in Reports
- Attaching External Documents
- Displaying Planning Supporting Details
- Setting Up Expansions
- Creating Related Content in Reports
Module 6: Formatting Cells and Grids
- Formatting Cells
- Formatting Grids
- Suppressing Data
- Applying Conditional Formatting in Grids
- Setting Up Pages
Module 7: Creating Report Objects
- Report Objects Overview
- Creating Text Boxes
- Adding Images
- Saving and Linking Report Objects
- Inserting Saved Report Objects
- Adding Headers and Footers
- Designing Row and Column Templates
Module 8: Adding Text Functions
- Text Functions Overview
- Inserting Text Functions in Text Boxes
- Inserting Text Functions in Headings and Text Cells
- Customizing Page Headings
- Creating Dynamic Values with the Current Keyword
- Displaying the Row and Column IDs
- Displaying Text Function Errors
- Common Text Functions
Module 9: Adding Auto Calculations and Mathematical Functions
- Setting Up Auto Calculations in Data Rows and Columns
- Applying Mathematical Functions and Properties
- Mathematical Operators in Expressions
- Creating Formulas
- Common Mathematical Functions
Module 10: Creating Books
- Books Overview
- Previewing and Printing Books
- Changing the Book Point of View
- Creating Books in EPM Workspace
- Changing the Appearance of Books
Module 11: Creating Batches
- Batches Overview
- Creating and Scheduling Batches
- Scheduling Batch-Bursting Options
- Previewing Static HTML Output
- Monitoring Batch Schedules
Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2) Course Prerequisites:
• Previous experience with Oracle Hyperion Essbase
• Basic knowledge of Oracle Hyperion Financial Management
• Understanding of financial reporting concepts
• Technical expertise in SQL and relational databases
• Familiarity with administering IT systems
• Ability to design and implement financial reports.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!