ArchiTech IT

Course information

HYPERION REPORTING: Oracle Hyperion Financial Reporting helps businesses generate highly formatted, book-quality financial and management reports. Through Oracle Hyperion Financial Reporting Training, learn how to create and manage reports with Financial Reporting, including how to report objects, books, batches, format reports, add auto calculations and functions and more.

Training Objectives of Hyperion Interactive Report:
The main Objective of this Course is to providing a complete overview of the Interactive Reporting Web Client and EPM Workspace, providing the business analyst with the skills necessary to work with the tool on a daily basis. At End of the Completion of the Course, students must be able to create queries against a relational data source and create reports with Hyperion Interactive Reporting Studio and they will learn the concepts of request items filter and sort data and process queries.
Target Students / Prerequisites:
Students must have Basic knowledge of data warehouse and database concepts and familiar to write SQL queries on multiple database objects and Basic knowledge of Javascript Required.
Starting Interactive Reporting
Starting Interactive Reporting.
Opening and Saving a Sample File
Opening and Saving a Sample File.
Creating a sample query
Creating a sample query
Viewing Database Tables
Viewing Database Tables.
Adding Topics to query
Adding Topics to query
Viewing Results
Reordering Columns.
Sorting Columns
Filtering Data.
Calculating Data.
Pivoting Data.
Drilling Down.
Hiding Data.
Adding Color.
Charting data
Sorting Charts.
Inserting Text Labels.
Designing Reports
Creating smart Reports.
Sorting Columns.
Setting up a Report page.
Inserting Sections and Breaks
Inserting Sections and Breaks.
Changing Views
Changing Views.
Formatting Text and other elements
Formatting Text and other elements.
Setting interactive reporting options
Setting interactive reporting options.
Exporting document as a web page
Exporting document as a web page.
Export to HTML Wizard
Export to HTML Wizard.
Spot lighter
Spot lighter.
Querying
Query Section.
Building queries.
Processing Queries
Saving Queries
Derived Tables.
Working with query section data.
Results
Results section.
Enhancing your results set.
Working with a results table.
Saving Results set.
Exporting Results set
Working with Tables
Table Section.
Creating Tables.
Manipulating Table Data.
Working with Table Components.
Querying Multidimensional Databases
Olap Query Section
Defining OLAP Query Options
Building OLAP Queries.
Refining OLAP Query data.
Processing OLAP Queries.
Applying Filters.
Cube query
Cube Query Catalog.
Member selection.
Query options.
Showing as Chart.
Exporting a Cube query.
Analyzing Data with Pivot Tables
Creating Pivot Table.
Charting a Pivot table.
Working with Pivot table.
Pivoting Data.
Report Designer
Report Section.
Creating a custom report.
Working with a report page.
Formatting report items.
Computed Items
About Computed Items.
Adding Computed items.
Common computed item example.
Applying Sorts
Sorting Data.
Simple Sort.
Sort lines.
Complex Sorting.
Nested Sorting.
Understanding Connectivity in Interactive Reporting
About IR Database connection files.
Working with interactive reporting connection.
Connecting to the database.
Data Modeling
About Modeling.
Building a data model.
Understanding joins.
Working with Data Models.
Security for Interactive reporting
Security for Interactive reporting.
Introduction to dashboards
Introduction to dashboards.
Migrating reports with dashboards
Migrating reports with dashboards