Hyperion Interactive Report Course Content
Overview:
Oracle Hyperion Interactive Reporting is one of the main products in the Oracle Business Intelligence Enterprise Edition Plus software suite, an industry-leading business intelligence platform. This Software Completely shares common administration, user management, and installation and configuration support with other Hyperion BI modules of Oracle Business Intelligence Suite Enterprise Edition Plus.
Training Objectives of Hyperion Interactive Report:
The main Objective of this Course is to providing 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 web page
- Exporting document as 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 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 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