Hyperion Online Training Course

Syllabus of Hyperion Online Training Course

• 1. Multidimensional Analysis
• 2. Oracle�s Enterprise Performance Management System
• 3. Essbase
• 4. Production Environment Components
• 5. Designing Applications and Databases
• 6. Creating Applications and Databases
• 7. Creating Outlines
• 8. Designing Data Descriptor Dimensions
• 9. Data Descriptor Dimensions Overview
• 10. Designing Time Dimensions
• 11. Designing Scenario Dimensions
• 12. Outline Calculations
• 13. Designing Accounts Dimensions
• 14. Testing Outline Calculations
• 15. Optimizing Data Descriptor Dimensions
• 16. Creating Member Aliases
• 17. Dimension Types
• 18. Creating Period to Date Totals
• 19. Dynamic Calc Members
• 20. Enhancing Accounts Dimensions
• 21. Optimizing Data Storage
• 22. Developing Dimension Designs
• 23. Business View Dimensions Overview
• 24. Attributes in Database Design
• 25. Combining Business Views
• 26. Developing Label Outlines
• 27. Creating Basic Dimension Build Rules Files
• 28. Rules Files Overview
• 29. Creating Dimension Build Rules Files
• 30. Configuring Dimension Maintenance Settings
• 31. Creating Advanced Dimension Build Rules Files
• 32. Advanced Dimension Build Rules Files Overview
• 33. Creating Shared Members
• 34. Manipulating Fields
• 35. Creating User Defined Attributes
• 36. Creating Attribute Dimensions with Rules Files
• 37. Loading Data
• 38. Data Load Overview
• 39. Creating Data Load Rules Files
• 40. Selecting and Rejecting Records
• 41. Capturing New Members
• 42. Getting Started with Smart View
• 43. Navigating Smart View
• 44. Connecting to Data Sources
• 45. Creating Ad Hoc Grids
• 46. Setting the Point of View
• 47. Associating Data Sources with Worksheets
• 48. Creating Free Form Grids
• 49. Creating Reports with Smart View
• 50. Updating Essbase Data
• 51. Integrating Essbase Data with Microsoft Office
• 52. Creating Shared Database Perspectives

• 1. Oracle's Enterprise Performance Management System
• 2. Oracle's BI Suite Enterprise Edition Plus
• 3. Financial Reporting Features and Architecture
• 4. Financial Management Data Sources

• 1. Workspace Overview
• 2. Setting Preferences
• 3. Browsing the Repository
• 4. Searching for Items
• 5. Previewing and Printing Reports

• 1. Annotations Overview
• 2. Creating, Viewing, and Replying to Annotations
• 3. Integrating Reports into Microsoft Office Applications

• 1. Reporting Studio Overview
• 2. Opening Reports
• 3. Previewing and Printing Reports

• 1. Report Creation Overview
• 2. Creating Reports and Grids
• 3. Selecting Members for Rows and Columns
• 4. Setting the Point of View
• 5. Adding Rows or Columns
• 6. Saving Reports

• 1. Lists Overview
• 2. Selecting Members by Using Lists
• 3. Selecting Members by Using Functions
• 4. Selecting Members for the Page Axis

• 1. Selecting Database Connections in Reports
• 2. Attaching Documents to Reports
• 3. Displaying Line Item Details
• 4. Setting Up Expansions to Display Detail Data
• 5. Adding Related Content Links to Reports

• 1. Formatting Cells
• 2. Formatting Grids
• 3. Suppressing Data
• 4. Applying Conditional Formatting in Grids
• 5. Setting Up Pages

• 1. Adding Text Boxes and Images
• 2. Saving Report Objects
• 3. Inserting Saved Report Objects
• 4. Designing Headers and Footers
• 5. Designing Row and Column Templates

• 1. Text Functions Overview
• 2. Inserting Text Functions
• 3. Common Text Functions

• 1. Auto Calculations Overview
• 2. Mathematical Functions
• 3. Mathematical Operators in Expressions
• 4. Formulas Overview
• 5. Common Mathematical Functions
• 6. Creating Books
• 7. Books Overview
• 8. Previewing and Printing Books
• 9. Changing the Book Point of View
• 10. Importing Files into the Repository
• 11. Creating Books
• 12. Changing the Appearance of Books

• 1. Working with Batches
• 2. Scheduling Batches
• 3. Scheduling Batch Bursting Options
• 4. Monitoring Batch Schedules

• 1. Managing User Points of View
• 2. Creating E Mail Links
• 3. Managing Repository Items
• 4. Managing Database Connections
• 5. Setting Permissions for Repository Items

• 1.Introduction to Financial Management
• 2. About Enterprise Performance Management

• 1. Dimensions
• 2. Define Application Profile
• 3. Create application

• 1. About Metadata Load Files
• 2. Loading Metadata
• 3. Manage Metadata
• 4. Prepare own Metadata

• 1. About Accounts and Custom Dimensions
• 2. Setting Up Account Types and Hierarchies
• 3. Setting Up Accounts and Custom Dimensions
• 4. Intercompany Account and Other Account Properties

• 1. Setting up Entities
• 2. Setting Up Calendars
• 3. Setting Up Scenarios

• 1. Loading Data Files
• 2. Extracting Data
• 3. and Removing Data

• 1. About Data Forms
• 2. Accessing the Form Builder
• 3. Defining the Point of View
• 4. Defining Columns and Rows
• 5. Setting Row and Column Options
• 6. Exporting Data to Spreadsheets

• 1. About Data Grids and Accessing Data Grids
• 2. Changing the Grid Layout and Display
• 3. Selecting Members for Dimensions
• 4. Selecting Members
• 5. Saving Grid Settings
• 6. Entering Data and Filling Multiple Cells
• 7. Spreading and Calculating Data
• 8. Adding Cell Text and Line Item Detail

• 1. About Member Lists
• 2. System and User Defined Member Lists
• 3. Creating Member Lists
• 4. Identifying Member Lists in a File
• 5. Creating Static Member Lists
• 6. Creating Dynamic Member Lists for the Entity Dimension and Other Dimensions
• 7. Loading and Extracting Member Lists

• 1. About Intercompany Transactions
• 2 Intercompany Account Balances
• 3. Elimination Process
• 4. Plug Accounts
• 5. Intercompany Eliminations and the Value Dimension
• 6. Setting Up Entities and Accounts for Intercompany Data
• 7. Creating and Running Intercompany Matching Reports

• 1. About Journals and Journal Benefits and Adjusting Data
• 2. Journals Review Process and the Value Dimension
• 3. Multiple Journal Postings, Accessing Journals and Opening Periods for Journal Entry
• 4. Creating Journal Templates and Journal Balance Types
• 5. Creating Journals and Entering Journal Data
• 6. Creating, Previewing, Running and Viewing Adjustments with the Entity Details Report
• 7. Setting Journal Report Properties and Selecting Columns and Filters
• 8. Saving Journal Reports Locally and Remotely

• 1. Consolidation Process and Percentages
• 2. Entering Consolidation Information Using Ownership Management
• 3. Running Consolidations
• 4. Checking Consolidation Status
• 5. Data Translation
• 6. Entering Exchange Rates

• 1. About Smart View
• 2. Smart View Installation and Components
• 3. Connecting to a Data Source
• 4. Entering Data with Web Data Forms
• 5. Functions in Smart View

• 1. About Rules and Rules Syntax
• 2. Rule Types and Rules Files
• 3. Objects and Functions in Rules
• 4. Assigning Values to Accounts
• 5. Account Expressions
• 6. Setting Values for Multiple Accounts
• 7. Subcubes, Data Retrieval, and Rules
• 8. Loading and Extracting Rules

• 1. Oracle's Enterprise Performance Management System
• 2. Benefits and Features of FDM
• 3. ERP Integrator
• 4. Processing Data Overview

• 1. Accessing FDM
• 2. Working with the POV
• 3. Locking Out Users for Maintenance
• 4. Running Reports
• 5. Viewing Graphical Timelines

• 1. About FDM Applications
• 2. Creating Applications
• 3. Managing Applications

• 1. Integration Overview
• 2. Importing, Registering, and Configuring Adapters
• 3. Adding Machine Profiles
• 4. Configuring Application Settings
• 5. Configuring Integration Settings
• 6. Testing Integrations
• 7. Setting Up Standard Reports and Templates

• 1. Viewing Control Tables
• 2. Managing Control Tables
• 3. Viewing Locations
• 4. Managing Locations
• 5. Setting Location Attributes
• 6. Searching Control Trees

• 1. Mapping Dimension Members
• 2. Building Maps
• 3. Map Types
• 4. Processing Order
• 5. Building Maps Externally
• 6. Copying Maps
• 7. Sharing Dimension Maps
• 8. Setting Up Conditional Mapping
• 9. Building Import Formats
• 10. About Import Formats
• 11. Creating Import Groups
• 12. Creating Import Formats
• 13. Assigning Import Formats
• 14. Adding Import Expressions

• 1. About Loading Data
• 2. Importing Source Data
• 3. Working with Records
• 4. Validating Dimension Mappings
• 5. Loading Data to Target Systems
• 6. Drilling into Data
• 7. Drilling Through from Target Applications

• 1. About Validation Rules and Reports
• 2. Creating Validation Rule Groups
• 3. Creating Validation Rules
• 4. Creating Validation Rules with Validation Editor
• 5. Assigning Validation Rules to Locations
• 6. Checking Validation Rules

• 1. About Validation Entities
• 2. Creating Validation Entity Groups
• 3. Creating Validation Entities
• 4. Assigning Validation Entity Groups to Locations
• 5. Verifying Consolidations

• 1. About Batch Processing
• 2. Setting Up Batch Load Files
• 3. Processing Batches
• 4. Creating Batch Scripts
• 5. Scheduling Batch Scripts in Task Manager

• 1. About Logic Accounts
• 2. Creating Logic Groups
• 3. Creating Simple Logic Accounts
• 4. Creating Complex Logic Accounts
• 5. Assigning Logic Groups to Locations

• 1. About FDM Journals
• 2. Creating Journal Templates
• 3. Adding Metadata Tags
• 4. Loading Journal Templates

• 1. About Multiload Files
• 2. Creating Multiload Excel Templates
• 3. Creating Multiload Text Files
• 5. Loading Multiload Files
• 6. Viewing Errors

• 1. About FDM Security
• 2. Security Levels
• 3. Setting Up Object Security
• 4. Setting Up User Security
• 5. Locking and Unlocking the Local POV Mode
• 6. Setting Up Report Group Security

• 1. About Financial Controls
• 2. Creating Controls Groups, Sections, and Questions
• 3. Deleting and Restoring Controls Groups, Sections, and Questions
• 4. Assigning Reviewer, Submitter, and Proxy Rights
• 5. Accessing Financial Controls
• 6. Selecting Application Settings for Financial Controls

• 1. About Scripting in FDM
• 2. Working with Scripting Components
• 3. Creating Import Scripts
• 4. Assigning Import Scripts to Import Formats
• 5. Applying Scripting Functions to Import Scripts
• 6. Working with Temporary Variables
• 7. Manually Executing Custom Custom Web Scripts

• 1. About Import Integration Scripts
• 2. Creating Import Integration Scripts
• 3. Assigning Import Integration Scripts to Import Formats

• 1. About Event Scripts
• 2. Creating Event Scripts
• 3. Changing Import Formats Dynamically